public bool UpdateByID(M_CRMS_Client model, DataTable table) { int ItemID = model.ItemID; if (table != null && table.Rows.Count > 0) { List <SqlParameter> splist = new List <SqlParameter>(); splist.AddRange(BLLCommon.GetParameters(table)); DBCenter.UpdateSQL(model.ModelTable, BLLCommon.GetFieldAndPara(table), "ID=" + ItemID, splist); } return(DBCenter.UpdateByID(model, model.ID)); }
public bool Update(DataTable ContentDT, M_Product model) { int ItemID = model.ItemID; if (ContentDT != null && ContentDT.Rows.Count > 0) { if (string.IsNullOrEmpty(model.TableName)) { throw new Exception("商品附表为空"); } List <SqlParameter> splist = new List <SqlParameter>(); splist.AddRange(BLLCommon.GetParameters(ContentDT)); if (DBCenter.IsExist(model.TableName, "ID=" + ItemID)) { DBCenter.UpdateSQL(model.TableName, BLLCommon.GetFieldAndPara(ContentDT), "ID=" + ItemID, splist); } else { DBCenter.Insert(model.TableName, BLLCommon.GetFields(ContentDT), BLLCommon.GetParas(ContentDT), splist.ToArray()); } } UpdateByID(model); return(true); }
public void UpdateByID(DataRow dr, string pk = "id") { Sql.UpdateByIDs(TbName, pk, dr[pk].ToString(), BLLCommon.GetFieldAndPara(dr, pk), BLLCommon.GetParameters(dr, pk)); }
public int Insert(DataRow dr, string pk = "id") { return(Sql.insertID(TbName, BLLCommon.GetParameters(dr, pk), BLLCommon.GetParas(dr, pk), BLLCommon.GetFields(dr, pk))); }
public int Insert(M_CRMS_Client model, DataTable table) { int itemid = 0; if (!string.IsNullOrEmpty(model.ModelTable) && table.Rows.Count > 0) { itemid = DBCenter.Insert(model.ModelTable, BLLCommon.GetFields(table), BLLCommon.GetParas(table), BLLCommon.GetParameters(table).ToArray()); } model.ItemID = itemid; return(DBCenter.Insert(model)); }
protected void Button1_Click1(object sender, EventArgs e) { double money = 5; M_UserInfo mu = buser.GetLogin(); DataTable pubdt = SqlHelper.ExecuteTable(CommandType.Text, "select * from ZL_Pub_code where PubUserID=" + mu.UserID + " And Pubstart=1 And DATEDIFF(MINUTE,PubAddTime,GETDATE())<=5", null); if (pubdt.Rows.Count > 0) { function.WriteErrMsg("五分钟之内只能购买一次!"); } else { DataTable bmdt = SqlHelper.ExecuteTable("select * from ZL_CommonModel left join ZL_C_yjbl on ItemID=ID where ModelID=51 And Status=99 And bm=" + bm.Text); if (bmdt.Rows.Count > 0) { DataTable bmudt = SqlHelper.ExecuteTable("select * from ZL_Pub_code where Pubstart=1 And bm=" + bm.Text); if (bmudt.Rows.Count > 0) { function.WriteErrMsg("该编码已使用,请重新输入!"); } else { pubMod = pubBll.SelReturnModel(PubID); string Mdata = "[{PubContentid:'" + bm.Text + "',PubTitle:'业绩信息',PubContent:'" + PubContent.Text + "',bm:'" + bm.Text + "'}]"; DataTable dt = JsonConvert.DeserializeObject <DataTable>(Mdata); ForDataColumn(pubMod, dt); DataRow dr = dt.Rows[0]; if (DBCenter.Insert(pubMod.PubTableName, BLLCommon.GetFields(dr), BLLCommon.GetParas(dr), BLLCommon.GetParameters(dr)) > 0) { M_Uinfo umub = buser.GetUserBaseByuserid(mu.UserID); switch (umub.Province) { case "北京": money = 10; break; default: break; } buser.ChangeVirtualMoney(mu.UserID, new M_UserExpHis() { score = 10, ScoreType = 1, detail = "销售产品获得资金:" + money + ",业绩编码:" + bm.Text }); function.WriteSuccessMsg("销售成功!", "/User/Info/ConsumeDetail1.aspx?SType=1"); } } } else { function.WriteErrMsg("该编码无效,请重新输入!"); } } }
public int Add(DataTable ContentDT, M_Product model) { //m_Product.ItemID = ItemID; int itemid = 0; if (!string.IsNullOrEmpty(model.TableName) && ContentDT.Rows.Count > 0) { itemid = DBCenter.Insert(model.TableName, BLLCommon.GetFields(ContentDT), BLLCommon.GetParas(ContentDT), BLLCommon.GetParameters(ContentDT).ToArray()); } model.ItemID = itemid; return(Insert(model)); }