public int Insert(M_Pro_Progress model)
{
if (model.OrderID == 0)
{
model.OrderID = GetMaxOrder(model.ProID);
}
return(Sql.insertID(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
//-----------------Insert
/// <summary>
/// 如有同名返回-1,否则返回被插入ID;
/// </summary>
public int Insert(M_IDC_DomPrice model)
{
if (CheckIsExist(model.DomName) != null)
{
return(-1);
}
return(Sql.insert(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public int AddContent(DataTable ContentDT, M_CommonData model)
{
int itemid = 0;
if (!string.IsNullOrEmpty(model.TableName) && ContentDT.Rows.Count > 0)
{
string sql = InsertSql(ContentDT);
if (!string.IsNullOrEmpty(sql))
{
string strSql = "Insert Into " + model.TableName + sql + ";select @@IDENTITY AS newID";
SqlParameter[] sp = ContentPara(ContentDT);
itemid = SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql, sp));
}
}
string strSql3 = "select max(OrderID) from ZL_CommonModel";
int OrderID = SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql3, null)) + 1;
model.ItemID = itemid;
model.OrderID = OrderID;
//throw new Exception(model.ItemID.ToString() + ":" + itemid);
// model.GetParameters()
return(Sql.insertID("ZL_CommonModel", model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
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 int GetInsert(M_Usermagazine model)
{
return(Sql.insert(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public int insert(M_Adzone model)
{
return(Sql.insertID(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public int Insert(M_Order_Repair model)
{
return(Sql.insertID(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
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));
}
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 AddLabel(M_Zone_Node model)
{
return(Sql.insert(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public int Insert(Appinfo model)
{
return(Sql.insertID(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public int Insert(M_Publish_Node model)
{
return(Sql.insert(model.TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public int Insert(M_User_Plat model)
{
SyncUB(model);
model.PK = "";
return(Sql.insert("ZL_User_Plat", model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public int Insert(M_EDU_AutoPK model)
{
return(Sql.insertID(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public int Insert(M_Shop_FareTlp model)
{
return(Sql.insertID(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public int Add(M_PageReg m_PageReg)
{
string strSQL = "INSERT INTO [" + strTableName + "](" + BLLCommon.GetFields(m_PageReg) + ")VALUES(" + BLLCommon.GetParas(m_PageReg) + ")";
return(DataConverter.CLng(SqlHelper.ExecuteScalar(CommandType.Text, strSQL, m_PageReg.GetParameters())));
}
public static int Insert(M_Com_VisitCount model)
{
return(Sql.insertID(model.TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public int Insert(M_IDC_Sites model)
{
return(Sql.insert(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public int Insert(M_IDC_DomainList model)
{
return(Sql.insertID(strTableName, model.GetParameters(model), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public int Insert(M_User_UnitWeek model)
{
return(Sql.insert(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public int Insert(M_Plat_File model)
{
return(Sql.insert(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public int insert(M_PlanSql model)
{
return(Sql.insertID(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public int Insert(M_Content_FileBuy model)
{
return(Sql.insertID(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
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));
}
public void CreateLink()
{
int Mid = DataConverter.CLng(Request["ID"]);
M_QrCode codeMod = null;
if (Mid > 0)
{
codeMod = codeBll.SelReturnModel(Mid);
}
if (codeMod == null)
{
codeMod = new M_QrCode();
}
codeMod.UserName = Request.Form["alias_t"].Trim();
codeMod.Urls = DeviceHelper.Agent.Android + "$" + StrHelper.UrlDeal(Request.Form["android_t"].Trim()) + ","
+ DeviceHelper.Agent.iPhone + "$" + StrHelper.UrlDeal(Request.Form["iphone_t"].Trim()) + ","
+ DeviceHelper.Agent.iPad + "$" + StrHelper.UrlDeal(Request.Form["ipad_t"].Trim()) + ","
+ DeviceHelper.Agent.WindowsPhone + "$" + StrHelper.UrlDeal(Request.Form["wphone_t"].Trim()) + ","
+ DeviceHelper.Agent.PC + "$" + StrHelper.UrlDeal(Request.Form["pc_t"].Trim());
if (codeMod.ID <= 0)
{
codeMod.AppID = DataConverter.CLng(function.GetRandomString(6, 2));
codeMod.ID = Sql.insertID(codeBll.strTableName, codeMod.GetParameters(codeMod), BLLCommon.GetParas(codeMod), BLLCommon.GetFields(codeMod));
}
else
{
codeBll.UpdateByID(codeMod);
}
Response.Redirect("CL?ID=" + codeMod.ID);
}
//-----------------Insert
public int Insert(M_IDC_DNSTable model)
{
return(Sql.insert(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public int Insert(M_OA_Borrow model)
{
return(Sql.insertID(TbName, model.GetParameters(model), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
/// <summary>
/// 添加版位
/// </summary>
/// <param name="adZone"></param>
/// <returns></returns>
static bool ADZone_Adds(M_Adzone model)
{
Sql.insert(model.TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model));
return(true);
}
public int Insert(M_Exam_Answer model)
{
return(Sql.insertID(TbName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
