public bool UpdateByID(M_WX_APPID model) { DataRow dr = GetReaderFromModel(model); //return Sql.UpdateByIDs(TbName, PK, model.ID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters(model)); codeBll.UpdateByID(GetReaderFromModel(model)); return(true); }
protected void Save_Btn_Click(object sender, EventArgs e) { SqlParameter[] sp = new SqlParameter[] { new SqlParameter("name", FzUserName) }; DataRow dr = hostBll.SelByWhere("Name=@name", "Name", sp).Rows[0]; dr["CDate"] = DataConverter.CDate(CDate_T.Text); dr["EndDate"] = DataConverter.CDate(EndDate_T.Text); dr["SiteInfo"] = SiteInfo_T.Text.Trim(); hostBll.UpdateByID(dr, "Name"); function.WriteSuccessMsg("操作成功", "HostList.aspx"); }
protected void Page_Load(object sender, EventArgs e) { M_AdminInfo adminMod = B_Admin.GetLogin(); if (adminMod == null || adminMod.AdminId != 1) { throw new Exception("no access"); } //---------------------181120 if (false) { #region 初始化填充店铺数据 B_Ex_Store stBll = new B_Ex_Store(); DataTable userDT = DBCenter.Sel("ZL_User", "PageID>0"); DBCenter.UpdateSQL(stBll.TbName, "cdate='" + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") + "',dpzt=99", ""); foreach (DataRow user in userDT.Rows) { DataRow stDR = stBll.SelReturnModel(DataConvert.CLng(user["PageID"])); stDR["djid"] = Convert.ToInt32(user["UserID"]); stBll.UpdateById(stDR); } #endregion } if (true) { #region 内容迁移为移动编辑器 B_CodeModel codeBll = new B_CodeModel("ZL_C_LSSQ"); DataTable dt = codeBll.Sel(); //jxtd jxjl cgal for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; dr["jxtd"] = UeditorToMB(DataConvert.CStr(dr["jxtd"])); dr["jxjl"] = UeditorToMB(DataConvert.CStr(dr["jxjl"])); dr["cgal"] = UeditorToMB(DataConvert.CStr(dr["cgal"])); codeBll.UpdateByID(dr); } #endregion } throw new Exception("操作完成"); }
//更新商品所用原料信息 private void IsHaveMaterial(M_Product proMod) { B_Shop_Material matBll = new B_Shop_Material(); B_CodeModel codeBll = new B_CodeModel("ZL_Shop_ProMaterial"); try { DataTable dt = DBCenter.SelWithField(matBll.TbName, "ID"); foreach (DataRow dr in dt.Rows) { int id = Convert.ToInt32(dr["ID"]); int matnum = DataConvert.CLng(Request.Form["mat_" + id + "_num"]); if (matnum < 0) { matnum = 0; } DataTable codeMod = codeBll.SelByWhere("ProID=" + proMod.ID + " AND MatID=" + id, "ID DESC"); if (codeMod.Rows.Count < 1) { codeMod.Rows.Add(codeMod.NewRow()); } codeMod.Rows[0]["ProID"] = proMod.ID; codeMod.Rows[0]["MatID"] = id; codeMod.Rows[0]["MatNum"] = matnum; codeMod.Rows[0]["Remind"] = ""; if (DataConvert.CLng(codeMod.Rows[0]["ID"]) > 0) { codeBll.UpdateByID(codeMod.Rows[0]); } else { codeBll.Insert(codeMod.Rows[0]); } } } catch { } }
protected void Add_Btn_Click(object sender, EventArgs e) { M_CommonData CData = new M_CommonData(); M_AdminInfo adminMod = B_Admin.GetLogin(); M_ModelInfo model = modelBll.SelReturnModel(ModelID); artBll = new B_CodeModel(model.TableName); if (GeneralID > 0) { CData = conBll.SelReturnModel(GeneralID); } else { CData.NodeID = NodeID; CData.ModelID = ModelID; CData.TableName = model.TableName; CData.Inputer = adminMod.AdminName; string parentTree = ""; CData.FirstNodeID = nodeBll.SelFirstNodeID(NodeID, ref parentTree); CData.ParentTree = parentTree; } //------------------------ CData.Title = Title_T.Text.Trim(); switch ((sender as Button).CommandArgument) { case "add": CData.Status = (int)ZLEnum.ConStatus.Audited; break; case "draft": CData.Status = (int)ZLEnum.ConStatus.Draft; break; default: break; } if (GeneralID > 0) { DataRow dr = artBll.SelByID(CData.ItemID); dr["Content"] = content_t.Text; artBll.UpdateByID(dr, "ID"); conBll.UpdateByID(CData); } else { DataRow dr = artBll.NewModel(); dr["Content"] = content_t.Text; CData.ItemID = artBll.Insert(dr); CData.GeneralID = conBll.insert(CData); } //----------------同步版权印 double repPrice = DataConverter.CDouble(RepPrice_T.Text.Trim()); double matPrice = DataConverter.CDouble(MatPrice_T.Text.Trim()); string content = StringHelper.StripHtml(content_t.Text); M_Content_CR crMod = crBll.CreateFromContent(CData, content, repPrice, matPrice); string result = copyBll.Create(crMod); JObject obj = JsonConvert.DeserializeObject <JObject>(result); crMod.Status = DataConverter.CLng(obj["value"]); crMod.WorksID = obj["data"].ToString(); crBll.Insert(crMod); if (crMod.Status == 1) { function.WriteSuccessMsg("操作成功,文章编号为:" + crMod.WorksID, "WorksList.aspx"); } else { function.WriteErrMsg("操作失败:" + obj["msg"]); } }