@using ZoomLa.BLL.Content @using Newtonsoft.Json @using ZoomLa.BLL.Shop @using ZoomLa.SQLDAL @using ZoomLaCMS.Resources @functions { B_Node nodeBll = new B_Node(); B_Content_ScheTask scheBll = new B_Content_ScheTask(); B_User buser = new B_User(); B_Payment payBll = new B_Payment(); B_PayPlat platBll = new B_PayPlat(); B_OrderList orderBll = new B_OrderList(); OrderCommon orderCom = new OrderCommon(); B_ModelField modelBll = new B_ModelField(); public string data1, data2, data3_1, data3_2; public string GetExecuteType(DataRow dr) { return scheBll.GetExecuteType(Convert.ToInt32(dr["ExecuteType"])); } public IHtmlContent GetResult(DataRow dr) { if (DataConverter.CLng(dr["Result"])==1) { return MvcHtmlString.Create(ComRE.Icon_OK); } else { return MvcHtmlString.Create(ComRE.Icon_Error); } } public string formatzt(string zt, string selects) { string result = ""; int status = DataConverter.CLng(zt); int type = DataConverter.CLng(selects); switch (type) { case 0: result = OrderHelper.GetOrderStatus(status); break; case 1: result = OrderHelper.GetPayStatus(status); break; case 2: result = OrderHelper.GetExpStatus(status); break; default: result = @L.未知请求; break; } return result; } protected string getusername(string userid) { M_UserInfo uinfo = buser.GetUserByUserID(DataConverter.CLng(userid)); return uinfo.UserName; } protected string getPayPlat(string id) { string result = ""; M_PayPlat payMod = platBll.SelReturnModel(DataConverter.CLng(id)); if (payMod != null) { result = payMod.PayPlatName; } return result; } } @{ M_AdminInfo adminMod = B_Admin.GetLogin(Context); //内容,商品,会员 //只显示有数据的第一级父节点 DataTable condt = nodeBll.SelForShowAll(0); condt.DefaultView.RowFilter = "ItemCount>0 AND NodeType>0"; condt = condt.DefaultView.ToTable(); condt = condt.DefaultView.ToTable(false, "ItemCount", "NodeName"); data1 = JsonConvert.SerializeObject(condt); //商品 //DataTable prodt = SqlHelper.JoinQuery("A.*,B.NodeName", "(SELECT COUNT(ID) AS ICount,NodeID FROM ZL_Commodities Group BY NodeID)", "ZL_Node", "A.NodeID=B.NodeID"); //data2 = JsonConvert.SerializeObject(prodt); //商品,数量与销量 string prosql = "SELECT Pro.*,Cart.SellCount FROM " + " (SELECT A.*,B.NodeName FROM (SELECT COUNT(ID) AS ProCount,Nodeid FROM ZL_Commodities GROUP BY Nodeid) A LEFT JOIN ZL_Node B ON A.Nodeid=B.NodeID WHERE B.NodeName IS NOT NULL) Pro" + " LEFT JOIN" + " (SELECT COUNT(A.ID) AS SellCount,B.Nodeid FROM ZL_CartPro A LEFT JOIN ZL_Commodities B ON A.ProID=B.ID GROUP BY B.Nodeid) Cart" + " ON Pro.Nodeid=Cart.Nodeid"; DataTable prodt = SqlHelper.ExecuteTable(prosql); DataRow dr = prodt.NewRow(); dr["NodeName"] = "总计"; dr["ProCount"] = prodt.Compute("SUM(ProCount)", ""); dr["SellCount"] = prodt.Compute("SUM(SellCount)", ""); prodt.Rows.Add(dr); data2 = JsonConvert.SerializeObject(prodt); //内芯 DataTable userdt1 = SqlHelper.ExecuteTable("SELECT COUNT(UserID) AS count1,(SELECT COUNT(UserID) FROM ZL_User Where ParentUserID>0) AS count2 FROM ZL_User"); data3_1 = JsonConvert.SerializeObject(userdt1); DataTable userdt2 = SqlHelper.JoinQuery("A.*,B.GroupName", "(SELECT COUNT(UserID) AS ICount,GroupID FROM ZL_User Group BY GroupID)", "ZL_Group", "A.GroupID=B.GroupID"); data3_2 = JsonConvert.SerializeObject(userdt2); string litDate = "", litDate_1 = ""; if (SiteConfig.SiteOption.Language.ToLower().Equals("zh-cn")) { litDate = DateTime.Now.ToShortDateString() + " 农历" + Season.GetLunarCalendar(DateTime.Now) + " " + Season.GetWeekCHA() + " " + Season.ChineseTwentyFourDay(DateTime.Now); litDate_1= DateTime.Now.ToShortDateString() + " " + Season.GetWeekCHA() + " " + Season.ChineseTwentyFourDay(DateTime.Now); } else { litDate = DateTime.Now.ToShortDateString(); litDate_1= DateTime.Now.ToShortDateString() + " " + Season.GetWeekCHA() + " " + Season.ChineseTwentyFourDay(DateTime.Now); } //------------------------------- DataTable payDT = payBll.SelPage(1,5,new F_Payment() {status=3 }).dt; DataTable orderDT = orderBll.U_SelPage(new Filter_Order() {psize=5 }).dt; DataTable scheDT = new B_Content_ScheLog().Sel(5); } @section head{ @L.信息概览} @section content{
@(string.Format(Call.SiteName+L.后台管理系统,BLLCommon.VersionStr))
@L.欢迎 @adminMod.AdminName @litDate_1 [@L.万年历]
@L.内容管理 More
@L.商品 @L.订单 @L.流水 More
@L.会员管理More
@L.浏览信息
@Html.Partial("BrowserCheck") @*@L.服务器信息总览*@
@L.任务计划 @L.备忘录
@foreach (DataRow scheDR in scheDT.Rows) { }
@L.任务ID@L.任务名称@L.创建时间@L.执行计划@L.结果
@scheDR["ID"] @scheDR["TaskName"] @scheDR["CDate"] @GetExecuteType(scheDR) @GetResult(scheDR)
@*@L.任务中心 @L.添加任务 @L.执行记录*@
} @section script{ }