public int EditStocklog(B2b_com_pro_groupbuystocklog m)
{
using (var helper = new SqlHelper())
{
int result = new InternalB2b_com_pro_groupbuystocklog(helper).EditStocklog(m);
return(result);
}
}
internal int EditStocklog(B2b_com_pro_groupbuystocklog m)
{
if (m.id > 0)
{
string sql = "UPDATE [b2b_com_pro_groupbuystocklog] "
+ " SET [proid] =@proid"
+ ",[proname] =@proname "
+ " ,[isstock] = @isstock"
+ ",[stocktime] = @stocktime"
+ ",[operuserid] = @operuserid"
+ ",[comid] = @comid "
+ ",[stockagentcompanyid] = @stockagentcompanyid "
+ ",[stockagentcompanyname] =@stockagentcompanyname"
+ ",[groupbuytype] = @groupbuytype"
+ ",[groupbuystatus] = @groupbuystatus"
+ ",[groupbuystatusdesc] =@groupbuystatusdesc "
+ " WHERE id=" + m.id;
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@proid", m.proid);
cmd.AddParam("@proname", m.proname);
cmd.AddParam("@isstock", m.isstock);
cmd.AddParam("@stocktime", m.stocktime);
cmd.AddParam("@operuserid", m.operuserid);
cmd.AddParam("@comid", m.comid);
cmd.AddParam("@stockagentcompanyid", m.stockagentcompanyid);
cmd.AddParam("@stockagentcompanyname", m.stockagentcompanyname);
cmd.AddParam("@groupbuytype", m.groupbuytype);
cmd.AddParam("@groupbuystatus", m.groupbuystatus);
cmd.AddParam("@groupbuystatusdesc", m.groupbuystatusdesc);
cmd.ExecuteNonQuery();
return(m.id);
}
else
{
string sql = "INSERT INTO [b2b_com_pro_groupbuystocklog] " +
"([proid] " +
",[proname] " +
",[isstock] " +
",[stocktime] " +
",[operuserid] " +
",[comid] " +
",[stockagentcompanyid] " +
",[stockagentcompanyname] " +
",[groupbuytype] " +
",[groupbuystatus] " +
",[groupbuystatusdesc]) " +
"VALUES " +
"(@proid" +
",@proname" +
",@isstock" +
",@stocktime" +
",@operuserid " +
",@comid " +
",@stockagentcompanyid " +
",@stockagentcompanyname " +
",@groupbuytype " +
",@groupbuystatus" +
",@groupbuystatusdesc);select @@identity;";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@proid", m.proid);
cmd.AddParam("@proname", m.proname);
cmd.AddParam("@isstock", m.isstock);
cmd.AddParam("@stocktime", m.stocktime);
cmd.AddParam("@operuserid", m.operuserid);
cmd.AddParam("@comid", m.comid);
cmd.AddParam("@stockagentcompanyid", m.stockagentcompanyid);
cmd.AddParam("@stockagentcompanyname", m.stockagentcompanyname);
cmd.AddParam("@groupbuytype", m.groupbuytype);
cmd.AddParam("@groupbuystatus", m.groupbuystatus);
cmd.AddParam("@groupbuystatusdesc", m.groupbuystatusdesc);
object o = cmd.ExecuteScalar();
return(int.Parse(o.ToString()));
}
}
