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));
}
