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