protected void Save_B_Click(object sender, EventArgs e) { //存商品表中,这样只有显示的逻辑需要扩展,其他逻辑可不变 //商品增加筛选模型,便于扩展 M_UserInfo mu = buser.GetLogin(); M_Product proMod = proBll.GetproductByid(Mid); if (proMod == null) { proMod = new M_Product(); } proMod.Proname = Name_T.Text.Trim(); //proMod.BindIDS = UProIDS_Hid.Value; proMod.Procontent = UProIDS_Hid.Value; if (SFileUp.HasFile) { SFileUp.SaveUrl = ZLHelper.GetUploadDir_System("shop", "product", "yyyyMMdd"); proMod.Thumbnails = SFileUp.SaveFile(); } proMod.LinPrice = DataConverter.CDouble(Price_T.Text); //proMod.BookPrice = DataConverter.CDouble(BookPrice_T.Text); proMod.ShiPrice = proMod.LinPrice; //proMod.Istrue = ZStatus_Chk.Checked ? 1 : 0; proMod.Proinfo = Remind_T.Text; proMod.Nodeid = 16; proMod.ModelID = 20; proMod.GuessXML = Request.Form["GuessXML"]; proMod.UserShopID = mu.SiteID; if (proMod.ID > 0) { proBll.UpdateByID(proMod); } else { proMod.FirstNodeID = nodeBll.SelFirstNodeID(proMod.Nodeid); proMod.Class = 2; proMod.ProClass = 1; proMod.UserID = mu.UserID; proMod.AddUser = mu.UserName; proBll.Insert(proMod); } function.WriteSuccessMsg("操作成功", "SuitPro.aspx"); }
public void ProcessRequest(HttpContext context) { M_UserInfo mu = buser.GetLogin(); retMod.retcode = M_APIResult.Failed; if (mu.IsNull) { retMod.retmsg = "用户未登录"; RepToClient(retMod); } int siteID = DataConvert.CLng(Req("SiteID")); //retMod.callback = CallBack;//暂不开放JsonP try { switch (Action) { case "mb_list": #region { string fields = "wxico,wxsize,wxbk,flag,wxlink,content,dbtype"; DataTable dt = GetListDT(); foreach (DataRow dr in dt.Rows) { M_CommonData conMod = conBll.SelReturnModel(Convert.ToInt32(dr["id"])); //if (!conMod.Inputer.Equals(mu.UserName)) { continue; } List <SqlParameter> sp1 = GetSPByDR(dr, "title"); List <SqlParameter> sp2 = GetSPByDR(dr, fields); DBCenter.UpdateSQL("ZL_CommonModel", GetSet(sp1), "GeneralID=" + conMod.GeneralID, sp1); DBCenter.UpdateSQL("ZL_C_Article", GetSet(sp2), "ID=" + conMod.ItemID, sp2); } retMod.retcode = M_APIResult.Success; } #endregion break; case "mb_nav": { DataTable dt = GetListDT(); foreach (DataRow dr in dt.Rows) { M_CommonData conMod = conBll.SelReturnModel(Convert.ToInt32(dr["id"])); //if (!conMod.Inputer.Equals(mu.UserName)) { continue; } List <SqlParameter> sp1 = new List <SqlParameter>() { new SqlParameter("title", dr["title"].ToString()) }; List <SqlParameter> sp2 = new List <SqlParameter>() { new SqlParameter("wxico", dr["wxico"].ToString()) }; DBCenter.UpdateSQL("ZL_CommonModel", "Title=@title", "GeneralID=" + conMod.GeneralID, sp1); DBCenter.UpdateSQL("ZL_C_Article", "wxico=@wxico", "ID=" + conMod.ItemID, sp2); } retMod.retcode = M_APIResult.Success; } break; case "mg_footbar": { DataTable dt = GetListDT(); foreach (DataRow dr in dt.Rows) { M_CommonData conMod = conBll.SelReturnModel(Convert.ToInt32(dr["id"])); //if (!conMod.Inputer.Equals(mu.UserName)) { continue; } List <SqlParameter> sp1 = new List <SqlParameter>() { new SqlParameter("title", dr["title"].ToString()) }; List <SqlParameter> sp2 = new List <SqlParameter>() { new SqlParameter("wxico", dr["wxico"].ToString()) }; DBCenter.UpdateSQL("ZL_CommonModel", "Title=@title", "GeneralID=" + conMod.GeneralID, sp1); DBCenter.UpdateSQL("ZL_C_Article", "wxico=@wxico", "ID=" + conMod.ItemID, sp2); } retMod.retcode = M_APIResult.Success; } break; case "mb_image": //更新单个内容的指定字段,是否需要扩展为,根据字段更新目标表,以减少代码 { string flag = Req("flag"); //传了该值,则代表单条数据更新 DataTable dt = GetListDT(); foreach (DataRow dr in dt.Rows) { List <SqlParameter> sp2 = new List <SqlParameter>() { new SqlParameter("wxico", dr["wxico"].ToString()), new SqlParameter("flag", dr["flag"].ToString()) }; DBCenter.UpdateSQL("ZL_C_Article", "wxico=@wxico", "Flag=@flag", sp2); } retMod.retcode = M_APIResult.Success; } break; case "mb_byid": //主用于内容更新 { string fields = "wxico,wxsize,wxbk,flag,wxlink,content,dbtype"; //dbtype DataTable dt = GetListDT(); foreach (DataRow dr in dt.Rows) { M_CommonData conMod = conBll.SelReturnModel(Convert.ToInt32(dr["id"])); List <SqlParameter> sp1 = GetSPByDR(dr, "title"); List <SqlParameter> sp2 = GetSPByDR(dr, fields); DBCenter.UpdateSQL("ZL_CommonModel", GetSet(sp1), "GeneralID=" + conMod.GeneralID, sp1); DBCenter.UpdateSQL("ZL_C_Article", GetSet(sp2), "ID=" + conMod.ItemID, sp2); } retMod.retcode = M_APIResult.Success; } break; case "mb_new": { B_CodeModel codeBll = new B_CodeModel("ZL_C_Article"); string nodeName = Req("type").Equals("nav") ? "微站图片" : "微站内容"; DataTable nodedt = DBCenter.Sel("ZL_Node", "NodeBySite=" + siteID + " AND NodeName='" + nodeName + "'"); if (nodedt.Rows.Count < 1) { retMod.retmsg = nodeName + "节点不存在"; } else { DataRow dr = GetListDT().Rows[0]; M_CommonData conMod = new M_CommonData(); DataRow artdr = codeBll.NewModel(); conMod.Title = dr["title"].ToString(); conMod.Inputer = mu.UserName; conMod.Status = (int)ZLEnum.ConStatus.Audited; conMod.TableName = "ZL_C_Article"; conMod.ModelID = 2; //文章ID conMod.NodeID = Convert.ToInt32(nodedt.Rows[0]["NodeID"]); //放入微内容处 //----------------------------- artdr["content"] = "ajax添加"; artdr["wxico"] = dr["wxico"]; artdr["wxsize"] = dr["wxsize"]; artdr["wxbk"] = dr["wxbk"]; artdr["flag"] = dr["flag"]; artdr["dbtype"] = dr["dbtype"]; conMod.ItemID = codeBll.Insert(artdr); conMod.GeneralID = conBll.insert(conMod); retMod.retcode = M_APIResult.Success; retMod.result = conMod.GeneralID.ToString(); } } break; case "mb_del": { int id = Convert.ToInt32(Req("id")); M_CommonData conMod = conBll.SelReturnModel(id); if (conMod == null) { retMod.retmsg = "内容[" + id + "]不存在"; } else if (!conMod.Inputer.Equals(mu.UserName)) { retMod.retmsg = "你无权删除[" + id + "]内容"; } else { conBll.SetDel(conMod.GeneralID); retMod.retcode = M_APIResult.Success; } } break; case "mb_pro_update": //新建,或更新 { DataRow dr = GetListDT().Rows[0]; M_Product proMod = new M_Product(); if (DataConvert.CLng(dr["id"]) > 0) { int id = Convert.ToInt32(dr["id"]); proMod = proBll.GetproductByid(id); if (proMod == null) { retMod.retmsg = "商品[" + id + "]不存在"; RepToClient(retMod); } else if (proMod.UserID != mu.UserID) { retMod.retmsg = "无权修改[" + id + "]商品"; RepToClient(retMod); } } proMod.Proname = dr["proname"].ToString(); proMod.ActPrice = dr["price"].ToString(); proMod.LinPrice = DataConvert.CDouble(dr["price"]); proMod.UserID = mu.UserID; proMod.AddUser = mu.UserName; proMod.Nodeid = B_Design_MBSite.UserShopNodeID; proMod.ParentID = siteID; proMod.Proinfo = dr["proinfo"].ToString(); proMod.Procontent = dr["content"].ToString(); proMod.Clearimg = dr["pics"].ToString(); proMod.Thumbnails = proMod.Clearimg; if (proMod.ID > 0) { proBll.updateinfo(proMod); } else { proMod.ID = proBll.Insert(proMod); } retMod.retmsg = proMod.ID.ToString(); retMod.retcode = M_APIResult.Success; } break; case "mb_pro_del": { int id = Convert.ToInt32(Req("id")); M_Product proMod = proBll.GetproductByid(id); if (proMod == null) { retMod.retmsg = "商品[" + id + "]不存在"; } else if (proMod.UserID != mu.UserID) { retMod.retmsg = "你无权删除[" + id + "]商品"; } else { proBll.RealDelByIDS(id.ToString()); retMod.retcode = M_APIResult.Success; } } break; default: retMod.retmsg = "[" + Action + "]接口不存在"; break; } } catch (Exception ex) { retMod.retmsg = ex.Message; retMod.retcode = M_APIResult.Failed; } RepToClient(retMod); }
//----------Logical ////用户无微站信息,则自动创建 //public M_Design_MBSite AutoCreate(M_UserInfo mu) //{ // if (mu == null || mu.IsNull) { return null; } // if (DBCenter.IsExist(TbName, "UserID=" + mu.UserID)) { return null; } // M_Design_MBSite mbMod = new M_Design_MBSite(); // mbMod.UserID = mu.UserID; // mbMod.TlpID = 1; // mbMod.SiteID = mu.SiteID; // mbMod.ID = Insert(mbMod); // return mbMod; //} /// <summary> /// 根据用户与模板信息,创建站点 /// </summary> public M_Design_MBSite CreateSite(M_UserInfo mu, M_Design_MBSite mbMod, out string err) { B_Design_Node desNodeBll = new B_Design_Node(); B_Node nodeBll = new B_Node(); B_Product proBll = new B_Product(); //int mbsitecount = SiteConfig.SiteOption.DN_MBSiteCount; int mbsitecount = 10000;//取消数量限制 if (mu == null || mu.IsNull) { err = "用户不存在"; return(null); } else if (mbMod.TlpID < 1 || mbMod.TlpID > 8) { err = "未指定模板或模板[" + mbMod.TlpID + "]不存在"; return(null); } else if (GetSiteCount(mu.UserID) >= mbsitecount) { err = "用户只能创建" + mbsitecount + "个微站"; return(null); } if (string.IsNullOrEmpty(mbMod.SiteName)) { mbMod.SiteName = B_User.GetUserName(mu.HoneyName, mu.UserName) + "的微站" + DBCenter.Count(TbName, "UserID=" + mu.UserID) + 1; } mbMod.UserID = mu.UserID; mbMod.ID = Insert(mbMod); //-----建立微站节点信息,从指定的模板处拷节点数据,父节点需要自建 M_Node pnode = desNodeBll.GetUserRootNode(mu); if (pnode.IsNull) { pnode = desNodeBll.CreateUserRootNode(mu); } M_Node nodeMod = new M_Node(); nodeMod.NodeName = "微建站"; nodeMod.NodeDir = function.GetRandomString(6); nodeMod.CUser = mu.UserID; nodeMod.CUName = mu.UserName; nodeMod.NodeBySite = mbMod.ID; nodeMod.NodeType = 1;//标识自身为主栏目 nodeMod.ParentID = pnode.NodeID; nodeMod.NodeID = nodeBll.Insert(nodeMod); //---导入对应的模板节点数据 string nodename = "微建站" + mbMod.TlpID; DataTable nodeDT = SelNodeByPName(nodename); CopyNodeAndContent(nodeDT, nodeMod); //---如果有商品数据,则导入商品 DataTable proDT = SelProByPName(nodename); foreach (DataRow dr in proDT.Rows) { M_Product proMod = new M_Product().GetModelFromReader(dr); proMod.ID = 0; proMod.ParentID = mbMod.ID;//所属哪个站点 proMod.UserID = mu.UserID; proMod.AddUser = mu.UserName; proMod.Nodeid = UserShopNodeID; proMod.AddTime = DateTime.Now; proMod.UpdateTime = DateTime.Now; proBll.Insert(proMod); } err = ""; return(mbMod); }