/// <summary>
/// 增加一条数据
/// </summary>
public static int Add(OrderPrintSystem.Model.ProOrdersDetailMOD model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into proOrdersDetail(");
strSql.Append("orderNum,proType,proNum,ProPrice)");
strSql.Append(" values (");
strSql.Append("@orderNum,@proType,@proNum,@ProPrice)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@orderNum", SqlDbType.VarChar,100),
new SqlParameter("@proType", SqlDbType.VarChar,100),
new SqlParameter("@proNum", SqlDbType.Int,4),
new SqlParameter("@ProPrice", SqlDbType.Decimal,9)};
parameters[0].Value = model.orderNum;
parameters[1].Value = model.proType;
parameters[2].Value = model.proNum;
parameters[3].Value = model.ProPrice;
return SqlHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int Add(OrderPrintSystem.Model.ProOrdersMOD model)
{
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat("IF not exists(select 1 from proOrders where orderNum='{0}') BEGIN ",model.orderNum);
strSql.Append("insert into proOrders(");
strSql.Append("orderNum,customNum,heTongNum,customOrderNum,customWLBH,customManager,remark,editTime,ShuChuXianchang,ShuRuXianchang,发货状态)");
strSql.Append(" values (");
strSql.Append("@orderNum,@customNum,@heTongNum,@customOrderNum,@customWLBH,@customManager,@remark,@editTime,@ShuChuXianchang,@ShuRuXianchang,@发货状态)");
strSql.Append(";select @@IDENTITY");
strSql.Append(" END");
SqlParameter[] parameters = {
new SqlParameter("@orderNum", SqlDbType.VarChar,100),
new SqlParameter("@customNum", SqlDbType.VarChar,100),
new SqlParameter("@heTongNum", SqlDbType.VarChar,100),
new SqlParameter("@customOrderNum", SqlDbType.VarChar,100),
new SqlParameter("@customWLBH", SqlDbType.VarChar,100),
new SqlParameter("@customManager", SqlDbType.VarChar,100),
new SqlParameter("@remark", SqlDbType.Text),
new SqlParameter("@editTime", SqlDbType.DateTime),
new SqlParameter("@ShuChuXianchang",SqlDbType.VarChar,100),
new SqlParameter("@ShuRuXianchang",SqlDbType.VarChar,100),
new SqlParameter("@发货状态",SqlDbType.VarChar,100)
};
parameters[0].Value = model.orderNum;
parameters[1].Value = model.customNum;
parameters[2].Value = model.heTongNum;
parameters[3].Value = model.customOrderNum;
parameters[4].Value = model.customWLBH;
parameters[5].Value = model.customManager;
parameters[6].Value = model.remark;
parameters[7].Value = model.editTime;
parameters[8].Value = model.ShuChuXianchang;
parameters[9].Value = model.ShuRuXianchang;
parameters[10].Value = model.发货状态;
return SqlHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static int Update(OrderPrintSystem.Model.ProOrdersMOD model)
{
return ProOrdersDAO.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int Add(OrderPrintSystem.Model.ProOrdersMOD model)
{
return ProOrdersDAO.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static int Update(OrderPrintSystem.Model.ProOrdersMOD model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update proOrders set ");
strSql.Append("orderNum=@orderNum,");
strSql.Append("customNum=@customNum,");
strSql.Append("heTongNum=@heTongNum,");
strSql.Append("customOrderNum=@customOrderNum,");
strSql.Append("customWLBH=@customWLBH,");
strSql.Append("customManager=@customManager,");
strSql.Append("remark=@remark,");
strSql.Append("editTime=@editTime,");
strSql.Append("updateTime=@updateTime,");
strSql.Append("yikaipiaoMoney=@yikaipiaoMoney,");
strSql.Append("yijiekuanMoney=@yijiekuanMoney,");
strSql.Append("FaPiaoDanhao=@FaPiaoDanhao,");
strSql.Append("ChengShuiHao=@ChengShuiHao,");
strSql.Append("Remark1=@Remark1,");
strSql.Append("EditUser=@EditUser,");
strSql.Append("IsTiXing=@IsTiXing,");
strSql.Append("ShuChuXianchang=@ShuChuXianchang,");
strSql.Append("ShuRuXianchang=@ShuRuXianchang");
strSql.Append(" where orderId=@orderId");
SqlParameter[] parameters = {
new SqlParameter("@orderNum", SqlDbType.VarChar,100),
new SqlParameter("@customNum", SqlDbType.VarChar,100),
new SqlParameter("@heTongNum", SqlDbType.VarChar,100),
new SqlParameter("@customOrderNum", SqlDbType.VarChar,100),
new SqlParameter("@customWLBH", SqlDbType.VarChar,100),
new SqlParameter("@customManager", SqlDbType.VarChar,100),
new SqlParameter("@remark", SqlDbType.Text),
new SqlParameter("@editTime", SqlDbType.DateTime),
new SqlParameter("@updateTime",SqlDbType.DateTime),
new SqlParameter("@yikaipiaoMoney",SqlDbType.Decimal),
new SqlParameter("@yijiekuanMoney",SqlDbType.Decimal),
new SqlParameter("@FaPiaoDanhao", SqlDbType.VarChar,100),
new SqlParameter("@ChengShuiHao", SqlDbType.VarChar,100),
new SqlParameter("@Remark1", SqlDbType.VarChar,5000),
new SqlParameter("@EditUser",SqlDbType.Int,4),
new SqlParameter("@IsTiXing",SqlDbType.Int,4),
new SqlParameter("@ShuChuXianchang", SqlDbType.VarChar,100),
new SqlParameter("@ShuRuXianchang", SqlDbType.VarChar,100),
new SqlParameter("@orderId", SqlDbType.Int,4)};
parameters[0].Value = model.orderNum;
parameters[1].Value = model.customNum;
parameters[2].Value = model.heTongNum;
parameters[3].Value = model.customOrderNum;
parameters[4].Value = model.customWLBH;
parameters[5].Value = model.customManager;
parameters[6].Value = model.remark;
parameters[7].Value = model.editTime;
parameters[8].Value = model.UpdateTime;
parameters[9].Value = model.YikaipiaoMoney;
parameters[10].Value = model.YijiekuanMoney;
parameters[11].Value = model.FaPiaoDanhao;
parameters[12].Value = model.ChengShuiHao;
parameters[13].Value = model.Remark1;
parameters[14].Value = model.EditUser;
parameters[15].Value = model.IsTiXing;
parameters[16].Value = model.ShuChuXianchang;
parameters[17].Value = model.ShuRuXianchang;
parameters[18].Value = model.orderId;
int readers = SqlHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
return readers;
}
/// <summary>
/// 更新一条数据
/// </summary>
public static int UpdateOrder(OrderPrintSystem.Model.ProOrdersDetailMOD model)
{
return ProOrdersDetailDAO.UpdateOrder(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int Add(OrderPrintSystem.Model.ProductsMOD model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into products(");
strSql.Append(@"productName,productNum,waiBZ,NeiBZ,NeiBZDW,bian,jingDu,xianXingdu,eDingJC,tieXiCount,guiGe,caiLiao,xingNeng,chuLiMethod,baoHeDian,xianQuanCount,chujZaShu,chujXianJing,chujRaoXianZD,chujXianTouCD,chujXiantouCL,chujTongMD,cijZaShu,cijXianJing,cijRaoXianZD,cijXianTouCD,cijXianTouCL,cijTongMD,xqjcyqEquip,xqjcyqShuRuState,xqjcyqShuChuState,xqjcyqJiaoCha,xqjcyqFuZai,biaoShiNo,waiKeNo,waiKeCount,yongJiaoCS,shuRu,shuChu,biaoShiAddress,chajianNo,chajianCount,waiXingTZ,cpjccsEquip,cpjccsShuRuState,cpjccsShuChuState,CpjccsJiaoChaBH,cpjccsFuZai,cpjccsNaiYa,cpjccsTongMD,guanJiaoZhenLX,guanJIaoZhenLXCount,guanJiaoZhenLXTOW,guanJiaoZhenLXTOWCount,shuRuXC,shuChuXC,peiXianSR,peiXianSRCount,peiXianSC,peiXianSCCount,remark,isModifyTZ,biaoShiPicture,isModifyWaikeNo,GongyiZYSX,
baoZhuangHeGG,
baoZhuangXiangGG,
baoHeDianTestTJ,
guJia,
tongPai,
ciHuan,
duanZi,
xianLuBan,
jiaoPian,
pingBi,
wenYaGuan,
dianZu,
luoSi,
reSuoTaoGuan,
anZhuangPJ,
yuanQiJian1,
yuanQiJian2,
yuanQiJian3,
yuanQiJian4,
gujiaCanshu,
gujiaCount,
tongpaiCanshu,
tongpaoCount,
cihuanCanshu,
cihuanCount,
duanziCanshu,
duanziCount,
xianlubanCanshu,
xianlubanCount,
jiaopianCanshu,
jiaopianCount,
pingbiCanshu,
pingbiCount,
wenyaguanCanshu,
wenyaguanCount,
dianzuCanshu,
dianzuCount,
luosiCanshu,
luosiCount,
resuotaoguanCanshu,
resuotaoguanCount,
anzhuangPJCanshu,
anzhuangPJCount,
yuanqijian1Canshu,
Yuanqijian1Count,
Yuanqijian2Canshu,
Yuanqijian2Count,
Yuanqijian3Canshu,
Yuanqijian3Count,
Yuanqijian4Canshu,
Yuanqijian4Count)");
strSql.Append(" values (");
strSql.Append(@"@productName,@productNum,@waiBZ,@NeiBZ,@NeiBZDW,@bian,@jingDu,@xianXingdu,@eDingJC,@tieXiCount,@guiGe,@caiLiao,@xingNeng,@chuLiMethod,@baoHeDian,@xianQuanCount,@chujZaShu,@chujXianJing,@chujRaoXianZD,@chujXianTouCD,@chujXiantouCL,@chujTongMD,@cijZaShu,@cijXianJing,@cijRaoXianZD,@cijXianTouCD,@cijXianTouCL,@cijTongMD,@xqjcyqEquip,@xqjcyqShuRuState,@xqjcyqShuChuState,@xqjcyqJiaoCha,@xqjcyqFuZai,@biaoShiNo,@waiKeNo,@waiKeCount,@yongJiaoCS,@shuRu,@shuChu,@biaoShiAddress,@chajianNo,@chajianCount,@waiXingTZ,@cpjccsEquip,@cpjccsShuRuState,@cpjccsShuChuState,@CpjccsJiaoChaBH,@cpjccsFuZai,@cpjccsNaiYa,@cpjccsTongMD,@guanJiaoZhenLX,@guanJIaoZhenLXCount,@guanJiaoZhenLXTOW,@guanJiaoZhenLXTOWCount,@shuRuXC,@shuChuXC,@peiXianSR,@peiXianSRCount,@peiXianSC,@peiXianSCCount,@remark,@isModifyTZ,@biaoShiPicture,@isModifyWaikeNo,@GongyiZYSX,
@baoZhuangHeGG,
@baoZhuangXiangGG,
@baoHeDianTestTJ,
@guJia,
@tongPai,
@ciHuan,
@duanZi,
@xianLuBan,
@jiaoPian,
@pingBi,
@wenYaGuan,
@dianZu,
@luoSi,
@reSuoTaoGuan,
@anZhuangPJ,
@yuanQiJian1,
@yuanQiJian2,
@yuanQiJian3,
@yuanQiJian4,
@gujiaCanshu,
@gujiaCount,
@tongpaiCanshu,
@tongpaoCount,
@cihuanCanshu,
@cihuanCount,
@duanziCanshu,
@duanziCount,
@xianlubanCanshu,
@xianlubanCount,
@jiaopianCanshu,
@jiaopianCount,
@pingbiCanshu,
@pingbiCount,
@wenyaguanCanshu,
@wenyaguanCount,
@dianzuCanshu,
@dianzuCount,
@luosiCanshu,
@luosiCount,
@resuotaoguanCanshu,
@resuotaoguanCount,
@anzhuangPJCanshu,
@anzhuangPJCount,
@yuanqijian1Canshu,
@Yuanqijian1Count,
@Yuanqijian2Canshu,
@Yuanqijian2Count,
@Yuanqijian3Canshu,
@Yuanqijian3Count,
@Yuanqijian4Canshu,
@Yuanqijian4Count)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@productName", SqlDbType.VarChar,500),
new SqlParameter("@productNum", SqlDbType.VarChar,500),
new SqlParameter("@waiBZ", SqlDbType.Int,4),
new SqlParameter("@NeiBZ", SqlDbType.VarChar,500),
new SqlParameter("@NeiBZDW", SqlDbType.VarChar,500),
new SqlParameter("@bian", SqlDbType.VarChar,500),
new SqlParameter("@jingDu", SqlDbType.VarChar,500),
new SqlParameter("@xianXingdu", SqlDbType.VarChar,500),
new SqlParameter("@eDingJC", SqlDbType.VarChar,500),
new SqlParameter("@tieXiCount", SqlDbType.Int,4),
new SqlParameter("@guiGe", SqlDbType.VarChar,500),
new SqlParameter("@caiLiao", SqlDbType.VarChar,500),
new SqlParameter("@xingNeng", SqlDbType.VarChar,500),
new SqlParameter("@chuLiMethod", SqlDbType.VarChar,500),
new SqlParameter("@baoHeDian", SqlDbType.VarChar,500),
new SqlParameter("@xianQuanCount", SqlDbType.Decimal),
new SqlParameter("@chujZaShu", SqlDbType.VarChar,500),
new SqlParameter("@chujXianJing", SqlDbType.VarChar,500),
new SqlParameter("@chujRaoXianZD", SqlDbType.VarChar,500),
new SqlParameter("@chujXianTouCD", SqlDbType.VarChar,500),
new SqlParameter("@chujXiantouCL", SqlDbType.VarChar,500),
new SqlParameter("@chujTongMD", SqlDbType.VarChar,500),
new SqlParameter("@cijZaShu", SqlDbType.VarChar,500),
new SqlParameter("@cijXianJing", SqlDbType.VarChar,500),
new SqlParameter("@cijRaoXianZD", SqlDbType.VarChar,500),
new SqlParameter("@cijXianTouCD", SqlDbType.VarChar,500),
new SqlParameter("@cijXianTouCL", SqlDbType.VarChar,500),
new SqlParameter("@cijTongMD", SqlDbType.VarChar,500),
new SqlParameter("@xqjcyqEquip", SqlDbType.VarChar,500),
new SqlParameter("@xqjcyqShuRuState", SqlDbType.VarChar,500),
new SqlParameter("@xqjcyqShuChuState", SqlDbType.VarChar,500),
new SqlParameter("@xqjcyqJiaoCha", SqlDbType.VarChar,500),
new SqlParameter("@xqjcyqFuZai", SqlDbType.VarChar,500),
new SqlParameter("@biaoShiNo", SqlDbType.VarChar,500),
new SqlParameter("@waiKeNo", SqlDbType.VarChar,500),
new SqlParameter("@waiKeCount", SqlDbType.Int,4),
new SqlParameter("@yongJiaoCS", SqlDbType.VarChar,500),
new SqlParameter("@shuRu", SqlDbType.VarChar,500),
new SqlParameter("@shuChu", SqlDbType.VarChar,500),
new SqlParameter("@biaoShiAddress", SqlDbType.VarChar,500),
new SqlParameter("@chajianNo", SqlDbType.VarChar,500),
new SqlParameter("@chajianCount", SqlDbType.Int,4),
new SqlParameter("@waiXingTZ", SqlDbType.VarChar,500),
new SqlParameter("@cpjccsEquip", SqlDbType.VarChar,500),
new SqlParameter("@cpjccsShuRuState", SqlDbType.VarChar,500),
new SqlParameter("@cpjccsShuChuState", SqlDbType.VarChar,500),
new SqlParameter("@CpjccsJiaoChaBH", SqlDbType.VarChar,500),
new SqlParameter("@cpjccsFuZai", SqlDbType.VarChar,500),
new SqlParameter("@cpjccsNaiYa", SqlDbType.VarChar,500),
new SqlParameter("@cpjccsTongMD", SqlDbType.VarChar,500),
new SqlParameter("@guanJiaoZhenLX", SqlDbType.VarChar,500),
new SqlParameter("@guanJIaoZhenLXCount", SqlDbType.Int,4),
new SqlParameter("@guanJiaoZhenLXTOW", SqlDbType.VarChar,500),
new SqlParameter("@guanJiaoZhenLXTOWCount", SqlDbType.Int,4),
new SqlParameter("@shuRuXC", SqlDbType.VarChar,500),
new SqlParameter("@shuChuXC", SqlDbType.VarChar,500),
new SqlParameter("@peiXianSR", SqlDbType.VarChar,500),
new SqlParameter("@peiXianSRCount", SqlDbType.Decimal,9),
new SqlParameter("@peiXianSC", SqlDbType.VarChar,500),
new SqlParameter("@peiXianSCCount", SqlDbType.Decimal,9),
new SqlParameter("@remark", SqlDbType.Text),
new SqlParameter("@isModifyTZ", SqlDbType.Int,4),
new SqlParameter("@biaoShiPicture", SqlDbType.VarChar,500),
new SqlParameter("@isModifyWaikeNo",SqlDbType.Int,4),
new SqlParameter("@GongyiZYSX",SqlDbType.VarChar,5000),
new SqlParameter("@baoZhuangHeGG",SqlDbType.VarChar,100),
new SqlParameter("@baoZhuangXiangGG",SqlDbType.VarChar,100),
new SqlParameter("@baoHeDianTestTJ",SqlDbType.VarChar,100),
new SqlParameter("@guJia",SqlDbType.VarChar,100),
new SqlParameter("@tongPai",SqlDbType.VarChar,100),
new SqlParameter("@ciHuan",SqlDbType.VarChar,100),
new SqlParameter("@duanZi",SqlDbType.VarChar,100),
new SqlParameter("@xianLuBan",SqlDbType.VarChar,100),
new SqlParameter("@jiaoPian",SqlDbType.VarChar,100),
new SqlParameter("@pingBi",SqlDbType.VarChar,100),
new SqlParameter("@wenYaGuan",SqlDbType.VarChar,100),
new SqlParameter("@dianZu",SqlDbType.VarChar,100),
new SqlParameter("@luoSi",SqlDbType.VarChar,100),
new SqlParameter("@reSuoTaoGuan",SqlDbType.VarChar,100),
new SqlParameter("@anZhuangPJ",SqlDbType.VarChar,100),
new SqlParameter("@yuanQiJian1",SqlDbType.VarChar,100),
new SqlParameter("@yuanQiJian2",SqlDbType.VarChar,100),
new SqlParameter("@yuanQiJian3",SqlDbType.VarChar,100),
new SqlParameter("@yuanQiJian4",SqlDbType.VarChar,100),
new SqlParameter("@gujiaCanshu",SqlDbType.VarChar,500),
new SqlParameter("@gujiaCount",SqlDbType.Decimal),
new SqlParameter("@tongpaiCanshu",SqlDbType.VarChar,500),
new SqlParameter("@tongpaoCount",SqlDbType.Decimal),
new SqlParameter("@cihuanCanshu",SqlDbType.VarChar,500),
new SqlParameter("@cihuanCount",SqlDbType.Decimal),
new SqlParameter("@duanziCanshu",SqlDbType.VarChar,500),
new SqlParameter("@duanziCount",SqlDbType.Decimal),
new SqlParameter("@xianlubanCanshu",SqlDbType.VarChar,500),
new SqlParameter("@xianlubanCount",SqlDbType.Decimal),
new SqlParameter("@jiaopianCanshu",SqlDbType.VarChar,500),
new SqlParameter("@jiaopianCount",SqlDbType.Decimal),
new SqlParameter("@pingbiCanshu",SqlDbType.VarChar,500),
new SqlParameter("@pingbiCount",SqlDbType.Decimal),
new SqlParameter("@wenyaguanCanshu",SqlDbType.VarChar,500),
new SqlParameter("@wenyaguanCount",SqlDbType.Decimal),
new SqlParameter("@dianzuCanshu",SqlDbType.VarChar,500),
new SqlParameter("@dianzuCount",SqlDbType.Decimal),
new SqlParameter("@luosiCanshu",SqlDbType.VarChar,500),
new SqlParameter("@luosiCount",SqlDbType.Decimal),
new SqlParameter("@resuotaoguanCanshu",SqlDbType.VarChar,500),
new SqlParameter("@resuotaoguanCount",SqlDbType.Int,4),
new SqlParameter("@anzhuangPJCanshu",SqlDbType.VarChar,500),
new SqlParameter("@anzhuangPJCount",SqlDbType.Decimal),
new SqlParameter("@yuanqijian1Canshu",SqlDbType.VarChar,500),
new SqlParameter("@Yuanqijian1Count",SqlDbType.Decimal),
new SqlParameter("@Yuanqijian2Canshu",SqlDbType.VarChar,500),
new SqlParameter("@Yuanqijian2Count",SqlDbType.Decimal),
new SqlParameter("@Yuanqijian3Canshu",SqlDbType.VarChar,500),
new SqlParameter("@Yuanqijian3Count",SqlDbType.Decimal),
new SqlParameter("@Yuanqijian4Canshu",SqlDbType.VarChar,500),
new SqlParameter("@Yuanqijian4Count",SqlDbType.Decimal)
};
parameters[0].Value = model.productName;
parameters[1].Value = model.productNum;
parameters[2].Value = model.waiBZ;
parameters[3].Value = model.NeiBZ;
parameters[4].Value = model.NeiBZDW;
parameters[5].Value = model.bian;
parameters[6].Value = model.jingDu;
parameters[7].Value = model.xianXingdu;
parameters[8].Value = model.eDingJC;
parameters[9].Value = model.tieXiCount;
parameters[10].Value = model.guiGe;
parameters[11].Value = model.caiLiao;
parameters[12].Value = model.xingNeng;
parameters[13].Value = model.chuLiMethod;
parameters[14].Value = model.baoHeDian;
parameters[15].Value = model.xianQuanCount;
parameters[16].Value = model.chujZaShu;
parameters[17].Value = model.chujXianJing;
parameters[18].Value = model.chujRaoXianZD;
parameters[19].Value = model.chujXianTouCD;
parameters[20].Value = model.chujXiantouCL;
parameters[21].Value = model.chujTongMD;
parameters[22].Value = model.cijZaShu;
parameters[23].Value = model.cijXianJing;
parameters[24].Value = model.cijRaoXianZD;
parameters[25].Value = model.cijXianTouCD;
parameters[26].Value = model.cijXianTouCL;
parameters[27].Value = model.cijTongMD;
parameters[28].Value = model.xqjcyqEquip;
parameters[29].Value = model.xqjcyqShuRuState;
parameters[30].Value = model.xqjcyqShuChuState;
parameters[31].Value = model.xqjcyqJiaoCha;
parameters[32].Value = model.xqjcyqFuZai;
parameters[33].Value = model.biaoShiNo;
parameters[34].Value = model.waiKeNo;
parameters[35].Value = model.waiKeCount;
parameters[36].Value = model.yongJiaoCS;
parameters[37].Value = model.shuRu;
parameters[38].Value = model.shuChu;
parameters[39].Value = model.biaoShiAddress;
parameters[40].Value = model.chajianNo;
parameters[41].Value = model.chajianCount;
parameters[42].Value = model.waiXingTZ??"";
parameters[43].Value = model.cpjccsEquip;
parameters[44].Value = model.cpjccsShuRuState;
parameters[45].Value = model.cpjccsShuChuState;
parameters[46].Value = model.CpjccsJiaoChaBH;
parameters[47].Value = model.cpjccsFuZai;
parameters[48].Value = model.cpjccsNaiYa;
parameters[49].Value = model.cpjccsTongMD;
parameters[50].Value = model.guanJiaoZhenLX;
parameters[51].Value = model.guanJIaoZhenLXCount;
parameters[52].Value = model.guanJiaoZhenLXTOW;
parameters[53].Value = model.guanJiaoZhenLXTOWCount;
parameters[54].Value = model.shuRuXC;
parameters[55].Value = model.shuChuXC;
parameters[56].Value = model.peiXianSR;
parameters[57].Value = model.peiXianSRCount;
parameters[58].Value = model.peiXianSC;
parameters[59].Value = model.peiXianSCCount;
parameters[60].Value = model.remark;
parameters[61].Value = model.isModifyTZ;
parameters[62].Value = model.biaoShiPicture;
parameters[63].Value = model.IsModifyWaikeNo;
parameters[64].Value = model.GongyiZYSX;
parameters[65].Value = model.BaoZhuangHeGG;
parameters[66].Value = model.BaoZhuangXiangGG;
parameters[67].Value = model.BaoHeDianTestTJ;
parameters[68].Value = model.GuJia;
parameters[69].Value = model.TongPai;
parameters[70].Value = model.CiHuan;
parameters[71].Value = model.DuanZi;
parameters[72].Value = model.XianLuBan;
parameters[73].Value = model.JiaoPian;
parameters[74].Value = model.PingBi;
parameters[75].Value = model.WenYaGuan;
parameters[76].Value = model.DianZu;
parameters[77].Value = model.LuoSi;
parameters[78].Value = model.ReSuoTaoGuan;
parameters[79].Value = model.AnZhuangPJ;
parameters[80].Value = model.YuanQiJian1;
parameters[81].Value = model.YuanQiJian2;
parameters[82].Value = model.YuanQiJian3;
parameters[83].Value = model.YuanQiJian4;
parameters[84].Value = model.GujiaCanshu;
parameters[85].Value = model.GujiaCount;
parameters[86].Value = model.TongpaiCanshu;
parameters[87].Value = model.TongpaoCount;
parameters[88].Value = model.CihuanCanshu;
parameters[89].Value = model.CihuanCount;
parameters[90].Value = model.DuanziCanshu;
parameters[91].Value = model.DuanziCount;
parameters[92].Value = model.XianlubanCanshu;
parameters[93].Value = model.XianlubanCount;
parameters[94].Value = model.JiaopianCanshu;
parameters[95].Value = model.JiaopianCount;
parameters[96].Value = model.PingbiCanshu;
parameters[97].Value = model.PingbiCount;
parameters[98].Value = model.WenyaguanCanshu;
parameters[99].Value = model.WenyaguanCount;
parameters[100].Value = model.DianzuCanshu;
parameters[101].Value = model.DianzuCount;
parameters[102].Value = model.LuosiCanshu;
parameters[103].Value = model.LuosiCount;
parameters[104].Value = model.ResuotaoguanCanshu;
parameters[105].Value = model.ResuotaoguanCount;
parameters[106].Value = model.AnzhuangPJCanshu;
parameters[107].Value = model.AnzhuangPJCount;
parameters[108].Value = model.Yuanqijian1Canshu;
parameters[109].Value = model.Yuanqijian1Count1;
parameters[110].Value = model.Yuanqijian2Canshu1;
parameters[111].Value = model.Yuanqijian2Count1;
parameters[112].Value = model.Yuanqijian3Canshu1;
parameters[113].Value = model.Yuanqijian3Count1;
parameters[114].Value = model.Yuanqijian4Canshu1;
parameters[115].Value = model.Yuanqijian4Count1;
return SqlHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static int Update(OrderPrintSystem.Model.ProductsMOD model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update products set ");
strSql.Append("productName=@productName,");
strSql.Append("productNum=@productNum,");
strSql.Append("waiBZ=@waiBZ,");
strSql.Append("NeiBZ=@NeiBZ,");
strSql.Append("NeiBZDW=@NeiBZDW,");
strSql.Append("bian=@bian,");
strSql.Append("jingDu=@jingDu,");
strSql.Append("xianXingdu=@xianXingdu,");
strSql.Append("eDingJC=@eDingJC,");
strSql.Append("tieXiCount=@tieXiCount,");
strSql.Append("guiGe=@guiGe,");
strSql.Append("caiLiao=@caiLiao,");
strSql.Append("xingNeng=@xingNeng,");
strSql.Append("chuLiMethod=@chuLiMethod,");
strSql.Append("baoHeDian=@baoHeDian,");
strSql.Append("xianQuanCount=@xianQuanCount,");
strSql.Append("chujZaShu=@chujZaShu,");
strSql.Append("chujXianJing=@chujXianJing,");
strSql.Append("chujRaoXianZD=@chujRaoXianZD,");
strSql.Append("chujXianTouCD=@chujXianTouCD,");
strSql.Append("chujXiantouCL=@chujXiantouCL,");
strSql.Append("chujTongMD=@chujTongMD,");
strSql.Append("cijZaShu=@cijZaShu,");
strSql.Append("cijXianJing=@cijXianJing,");
strSql.Append("cijRaoXianZD=@cijRaoXianZD,");
strSql.Append("cijXianTouCD=@cijXianTouCD,");
strSql.Append("cijXianTouCL=@cijXianTouCL,");
strSql.Append("cijTongMD=@cijTongMD,");
strSql.Append("xqjcyqEquip=@xqjcyqEquip,");
strSql.Append("xqjcyqShuRuState=@xqjcyqShuRuState,");
strSql.Append("xqjcyqShuChuState=@xqjcyqShuChuState,");
strSql.Append("xqjcyqJiaoCha=@xqjcyqJiaoCha,");
strSql.Append("xqjcyqFuZai=@xqjcyqFuZai,");
strSql.Append("biaoShiNo=@biaoShiNo,");
strSql.Append("waiKeNo=@waiKeNo,");
strSql.Append("waiKeCount=@waiKeCount,");
strSql.Append("yongJiaoCS=@yongJiaoCS,");
strSql.Append("shuRu=@shuRu,");
strSql.Append("shuChu=@shuChu,");
strSql.Append("biaoShiAddress=@biaoShiAddress,");
strSql.Append("chajianNo=@chajianNo,");
strSql.Append("chajianCount=@chajianCount,");
strSql.Append("waiXingTZ=@waiXingTZ,");
strSql.Append("cpjccsEquip=@cpjccsEquip,");
strSql.Append("cpjccsShuRuState=@cpjccsShuRuState,");
strSql.Append("cpjccsShuChuState=@cpjccsShuChuState,");
strSql.Append("CpjccsJiaoChaBH=@CpjccsJiaoChaBH,");
strSql.Append("cpjccsFuZai=@cpjccsFuZai,");
strSql.Append("cpjccsNaiYa=@cpjccsNaiYa,");
strSql.Append("cpjccsTongMD=@cpjccsTongMD,");
strSql.Append("guanJiaoZhenLX=@guanJiaoZhenLX,");
strSql.Append("guanJIaoZhenLXCount=@guanJIaoZhenLXCount,");
strSql.Append("guanJiaoZhenLXTOW=@guanJiaoZhenLXTOW,");
strSql.Append("guanJiaoZhenLXTOWCount=@guanJiaoZhenLXTOWCount,");
strSql.Append("shuRuXC=@shuRuXC,");
strSql.Append("shuChuXC=@shuChuXC,");
strSql.Append("peiXianSR=@peiXianSR,");
strSql.Append("peiXianSRCount=@peiXianSRCount,");
strSql.Append("peiXianSC=@peiXianSC,");
strSql.Append("peiXianSCCount=@peiXianSCCount,");
strSql.Append("remark=@remark,");
strSql.Append("isModifyTZ=@isModifyTZ,");
strSql.Append("biaoShiPicture=@biaoShiPicture,");
strSql.Append("IsModifyWaikeNo=@IsModifyWaikeNo,");
strSql.Append("GongyiZYSX=@GongyiZYSX,");
strSql.Append("baoZhuangHeGG=@baoZhuangHeGG,");
strSql.Append("baoZhuangXiangGG=@baoZhuangXiangGG,");
strSql.Append("baoHeDianTestTJ=@baoHeDianTestTJ,");
strSql.Append("guJia=@guJia,");
strSql.Append("tongPai=@tongPai,");
strSql.Append("ciHuan=@ciHuan,");
strSql.Append("duanZi=@duanZi,");
strSql.Append("xianLuBan=@xianLuBan,");
strSql.Append("jiaoPian=@jiaoPian,");
strSql.Append("pingBi=@pingBi,");
strSql.Append("wenYaGuan=@wenYaGuan,");
strSql.Append("dianZu=@dianZu,");
strSql.Append("luoSi=@luoSi,");
strSql.Append("reSuoTaoGuan=@reSuoTaoGuan,");
strSql.Append("anZhuangPJ=@anZhuangPJ,");
strSql.Append("yuanQiJian1=@yuanQiJian1,");
strSql.Append("yuanQiJian2=@yuanQiJian2,");
strSql.Append("yuanQiJian3=@yuanQiJian3,");
strSql.Append("yuanQiJian4=@yuanQiJian4,");
strSql.Append("gujiaCanshu=@gujiaCanshu,");
strSql.Append("gujiaCount=@gujiaCount,");
strSql.Append("tongpaiCanshu=@tongpaiCanshu,");
strSql.Append("tongpaoCount=@tongpaoCount,");
strSql.Append("cihuanCanshu=@cihuanCanshu,");
strSql.Append("cihuanCount=@cihuanCount,");
strSql.Append("duanziCanshu=@duanziCanshu,");
strSql.Append("duanziCount=@duanziCount,");
strSql.Append("xianlubanCanshu=@xianlubanCanshu,");
strSql.Append("xianlubanCount=@xianlubanCount,");
strSql.Append("jiaopianCanshu=@jiaopianCanshu,");
strSql.Append("jiaopianCount=@jiaopianCount,");
strSql.Append("pingbiCanshu=@pingbiCanshu,");
strSql.Append("pingbiCount=@pingbiCount,");
strSql.Append("wenyaguanCanshu=@wenyaguanCanshu,");
strSql.Append("wenyaguanCount=@wenyaguanCount,");
strSql.Append("dianzuCanshu=@dianzuCanshu,");
strSql.Append("dianzuCount=@dianzuCount,");
strSql.Append("luosiCanshu=@luosiCanshu,");
strSql.Append("luosiCount=@luosiCount,");
strSql.Append("resuotaoguanCanshu=@resuotaoguanCanshu,");
strSql.Append("resuotaoguanCount=@resuotaoguanCount,");
strSql.Append("anzhuangPJCanshu=@anzhuangPJCanshu,");
strSql.Append("anzhuangPJCount=@anzhuangPJCount,");
strSql.Append("yuanqijian1Canshu=@yuanqijian1Canshu,");
strSql.Append("Yuanqijian1Count=@Yuanqijian1Count,");
strSql.Append("Yuanqijian2Canshu=@Yuanqijian2Canshu,");
strSql.Append("Yuanqijian2Count=@Yuanqijian2Count,");
strSql.Append("Yuanqijian3Canshu=@Yuanqijian3Canshu,");
strSql.Append("Yuanqijian3Count=@Yuanqijian3Count,");
strSql.Append("Yuanqijian4Canshu=@Yuanqijian4Canshu,");
strSql.Append("Yuanqijian4Count=@Yuanqijian4Count");
strSql.Append(" where productId=@productId");
SqlParameter[] parameters = {
new SqlParameter("@productName", SqlDbType.VarChar,500),
new SqlParameter("@productNum", SqlDbType.VarChar,500),
new SqlParameter("@waiBZ", SqlDbType.Int,4),
new SqlParameter("@NeiBZ", SqlDbType.VarChar,500),
new SqlParameter("@NeiBZDW", SqlDbType.VarChar,500),
new SqlParameter("@bian", SqlDbType.VarChar,500),
new SqlParameter("@jingDu", SqlDbType.VarChar,500),
new SqlParameter("@xianXingdu", SqlDbType.VarChar,500),
new SqlParameter("@eDingJC", SqlDbType.VarChar,500),
new SqlParameter("@tieXiCount", SqlDbType.Int,4),
new SqlParameter("@guiGe", SqlDbType.VarChar,500),
new SqlParameter("@caiLiao", SqlDbType.VarChar,500),
new SqlParameter("@xingNeng", SqlDbType.VarChar,500),
new SqlParameter("@chuLiMethod", SqlDbType.VarChar,500),
new SqlParameter("@baoHeDian", SqlDbType.VarChar,500),
new SqlParameter("@xianQuanCount", SqlDbType.Int,4),
new SqlParameter("@chujZaShu", SqlDbType.VarChar,500),
new SqlParameter("@chujXianJing", SqlDbType.VarChar,500),
new SqlParameter("@chujRaoXianZD", SqlDbType.VarChar,500),
new SqlParameter("@chujXianTouCD", SqlDbType.VarChar,500),
new SqlParameter("@chujXiantouCL", SqlDbType.VarChar,500),
new SqlParameter("@chujTongMD", SqlDbType.VarChar,500),
new SqlParameter("@cijZaShu", SqlDbType.VarChar,500),
new SqlParameter("@cijXianJing", SqlDbType.VarChar,500),
new SqlParameter("@cijRaoXianZD", SqlDbType.VarChar,500),
new SqlParameter("@cijXianTouCD", SqlDbType.VarChar,500),
new SqlParameter("@cijXianTouCL", SqlDbType.VarChar,500),
new SqlParameter("@cijTongMD", SqlDbType.VarChar,500),
new SqlParameter("@xqjcyqEquip", SqlDbType.VarChar,500),
new SqlParameter("@xqjcyqShuRuState", SqlDbType.VarChar,500),
new SqlParameter("@xqjcyqShuChuState", SqlDbType.VarChar,500),
new SqlParameter("@xqjcyqJiaoCha", SqlDbType.VarChar,500),
new SqlParameter("@xqjcyqFuZai", SqlDbType.VarChar,500),
new SqlParameter("@biaoShiNo", SqlDbType.VarChar,500),
new SqlParameter("@waiKeNo", SqlDbType.VarChar,500),
new SqlParameter("@waiKeCount", SqlDbType.Int,4),
new SqlParameter("@yongJiaoCS", SqlDbType.VarChar,500),
new SqlParameter("@shuRu", SqlDbType.VarChar,500),
new SqlParameter("@shuChu", SqlDbType.VarChar,500),
new SqlParameter("@biaoShiAddress", SqlDbType.VarChar,500),
new SqlParameter("@chajianNo", SqlDbType.VarChar,500),
new SqlParameter("@chajianCount", SqlDbType.Int,4),
new SqlParameter("@waiXingTZ", SqlDbType.VarChar,500),
new SqlParameter("@cpjccsEquip", SqlDbType.VarChar,500),
new SqlParameter("@cpjccsShuRuState", SqlDbType.VarChar,500),
new SqlParameter("@cpjccsShuChuState", SqlDbType.VarChar,500),
new SqlParameter("@CpjccsJiaoChaBH", SqlDbType.VarChar,500),
new SqlParameter("@cpjccsFuZai", SqlDbType.VarChar,500),
new SqlParameter("@cpjccsNaiYa", SqlDbType.VarChar,500),
new SqlParameter("@cpjccsTongMD", SqlDbType.VarChar,500),
new SqlParameter("@guanJiaoZhenLX", SqlDbType.VarChar,500),
new SqlParameter("@guanJIaoZhenLXCount", SqlDbType.Int,4),
new SqlParameter("@guanJiaoZhenLXTOW", SqlDbType.VarChar,500),
new SqlParameter("@guanJiaoZhenLXTOWCount", SqlDbType.Int,4),
new SqlParameter("@shuRuXC", SqlDbType.VarChar,500),
new SqlParameter("@shuChuXC", SqlDbType.VarChar,500),
new SqlParameter("@peiXianSR", SqlDbType.VarChar,500),
new SqlParameter("@peiXianSRCount", SqlDbType.Decimal,9),
new SqlParameter("@peiXianSC", SqlDbType.VarChar,500),
new SqlParameter("@peiXianSCCount", SqlDbType.Decimal,9),
new SqlParameter("@remark", SqlDbType.Text),
new SqlParameter("@isModifyTZ", SqlDbType.Int,4),
new SqlParameter("@biaoShiPicture", SqlDbType.VarChar,500),
new SqlParameter("@IsModifyWaikeNo",SqlDbType.Int,4),
new SqlParameter("@GongyiZYSX",SqlDbType.VarChar,5000),
new SqlParameter("@baoZhuangHeGG",SqlDbType.VarChar,100),
new SqlParameter("@baoZhuangXiangGG",SqlDbType.VarChar,100),
new SqlParameter("@baoHeDianTestTJ",SqlDbType.VarChar,100),
new SqlParameter("@guJia",SqlDbType.VarChar,100),
new SqlParameter("@tongPai",SqlDbType.VarChar,100),
new SqlParameter("@ciHuan",SqlDbType.VarChar,100),
new SqlParameter("@duanZi",SqlDbType.VarChar,100),
new SqlParameter("@xianLuBan",SqlDbType.VarChar,100),
new SqlParameter("@jiaoPian",SqlDbType.VarChar,100),
new SqlParameter("@pingBi",SqlDbType.VarChar,100),
new SqlParameter("@wenYaGuan",SqlDbType.VarChar,100),
new SqlParameter("@dianZu",SqlDbType.VarChar,100),
new SqlParameter("@luoSi",SqlDbType.VarChar,100),
new SqlParameter("@reSuoTaoGuan",SqlDbType.VarChar,100),
new SqlParameter("@anZhuangPJ",SqlDbType.VarChar,100),
new SqlParameter("@yuanQiJian1",SqlDbType.VarChar,100),
new SqlParameter("@yuanQiJian2",SqlDbType.VarChar,100),
new SqlParameter("@yuanQiJian3",SqlDbType.VarChar,100),
new SqlParameter("@yuanQiJian4",SqlDbType.VarChar,100),
new SqlParameter("@gujiaCanshu",SqlDbType.VarChar,500),
new SqlParameter("@gujiaCount",SqlDbType.Decimal),
new SqlParameter("@tongpaiCanshu",SqlDbType.VarChar,500),
new SqlParameter("@tongpaoCount",SqlDbType.Decimal),
new SqlParameter("@cihuanCanshu",SqlDbType.VarChar,500),
new SqlParameter("@cihuanCount",SqlDbType.Decimal),
new SqlParameter("@duanziCanshu",SqlDbType.VarChar,500),
new SqlParameter("@duanziCount",SqlDbType.Decimal),
new SqlParameter("@xianlubanCanshu",SqlDbType.VarChar,500),
new SqlParameter("@xianlubanCount",SqlDbType.Decimal),
new SqlParameter("@jiaopianCanshu",SqlDbType.VarChar,500),
new SqlParameter("@jiaopianCount",SqlDbType.Decimal),
new SqlParameter("@pingbiCanshu",SqlDbType.VarChar,500),
new SqlParameter("@pingbiCount",SqlDbType.Decimal),
new SqlParameter("@wenyaguanCanshu",SqlDbType.VarChar,500),
new SqlParameter("@wenyaguanCount",SqlDbType.Decimal),
new SqlParameter("@dianzuCanshu",SqlDbType.VarChar,500),
new SqlParameter("@dianzuCount",SqlDbType.Decimal),
new SqlParameter("@luosiCanshu",SqlDbType.VarChar,500),
new SqlParameter("@luosiCount",SqlDbType.Decimal),
new SqlParameter("@resuotaoguanCanshu",SqlDbType.VarChar,500),
new SqlParameter("@resuotaoguanCount",SqlDbType.Decimal),
new SqlParameter("@anzhuangPJCanshu",SqlDbType.VarChar,500),
new SqlParameter("@anzhuangPJCount",SqlDbType.Decimal),
new SqlParameter("@yuanqijian1Canshu",SqlDbType.VarChar,500),
new SqlParameter("@Yuanqijian1Count",SqlDbType.Decimal),
new SqlParameter("@Yuanqijian2Canshu",SqlDbType.VarChar,500),
new SqlParameter("@Yuanqijian2Count",SqlDbType.Decimal),
new SqlParameter("@Yuanqijian3Canshu",SqlDbType.VarChar,500),
new SqlParameter("@Yuanqijian3Count",SqlDbType.Decimal),
new SqlParameter("@Yuanqijian4Canshu",SqlDbType.VarChar,500),
new SqlParameter("@Yuanqijian4Count",SqlDbType.Decimal),
new SqlParameter("@productId", SqlDbType.Int,4)};
parameters[0].Value = model.productName;
parameters[1].Value = model.productNum;
parameters[2].Value = model.waiBZ;
parameters[3].Value = model.NeiBZ;
parameters[4].Value = model.NeiBZDW;
parameters[5].Value = model.bian;
parameters[6].Value = model.jingDu;
parameters[7].Value = model.xianXingdu;
parameters[8].Value = model.eDingJC;
parameters[9].Value = model.tieXiCount;
parameters[10].Value = model.guiGe;
parameters[11].Value = model.caiLiao;
parameters[12].Value = model.xingNeng;
parameters[13].Value = model.chuLiMethod;
parameters[14].Value = model.baoHeDian;
parameters[15].Value = model.xianQuanCount;
parameters[16].Value = model.chujZaShu;
parameters[17].Value = model.chujXianJing;
parameters[18].Value = model.chujRaoXianZD;
parameters[19].Value = model.chujXianTouCD;
parameters[20].Value = model.chujXiantouCL;
parameters[21].Value = model.chujTongMD;
parameters[22].Value = model.cijZaShu;
parameters[23].Value = model.cijXianJing;
parameters[24].Value = model.cijRaoXianZD;
parameters[25].Value = model.cijXianTouCD;
parameters[26].Value = model.cijXianTouCL;
parameters[27].Value = model.cijTongMD;
parameters[28].Value = model.xqjcyqEquip;
parameters[29].Value = model.xqjcyqShuRuState;
parameters[30].Value = model.xqjcyqShuChuState;
parameters[31].Value = model.xqjcyqJiaoCha;
parameters[32].Value = model.xqjcyqFuZai;
parameters[33].Value = model.biaoShiNo;
parameters[34].Value = model.waiKeNo;
parameters[35].Value = model.waiKeCount;
parameters[36].Value = model.yongJiaoCS;
parameters[37].Value = model.shuRu;
parameters[38].Value = model.shuChu;
parameters[39].Value = model.biaoShiAddress;
parameters[40].Value = model.chajianNo;
parameters[41].Value = model.chajianCount;
parameters[42].Value = model.waiXingTZ;
parameters[43].Value = model.cpjccsEquip;
parameters[44].Value = model.cpjccsShuRuState;
parameters[45].Value = model.cpjccsShuChuState;
parameters[46].Value = model.CpjccsJiaoChaBH;
parameters[47].Value = model.cpjccsFuZai;
parameters[48].Value = model.cpjccsNaiYa;
parameters[49].Value = model.cpjccsTongMD;
parameters[50].Value = model.guanJiaoZhenLX;
parameters[51].Value = model.guanJIaoZhenLXCount;
parameters[52].Value = model.guanJiaoZhenLXTOW;
parameters[53].Value = model.guanJiaoZhenLXTOWCount;
parameters[54].Value = model.shuRuXC;
parameters[55].Value = model.shuChuXC;
parameters[56].Value = model.peiXianSR;
parameters[57].Value = model.peiXianSRCount;
parameters[58].Value = model.peiXianSC;
parameters[59].Value = model.peiXianSCCount;
parameters[60].Value = model.remark;
parameters[61].Value = model.isModifyTZ;
parameters[62].Value = model.biaoShiPicture;
parameters[63].Value = model.IsModifyWaikeNo;
parameters[64].Value = model.GongyiZYSX;
parameters[65].Value = model.BaoZhuangHeGG;
parameters[66].Value = model.BaoZhuangXiangGG;
parameters[67].Value = model.BaoHeDianTestTJ;
parameters[68].Value = model.GuJia;
parameters[69].Value = model.TongPai;
parameters[70].Value = model.CiHuan;
parameters[71].Value = model.DuanZi;
parameters[72].Value = model.XianLuBan;
parameters[73].Value = model.JiaoPian;
parameters[74].Value = model.PingBi;
parameters[75].Value = model.WenYaGuan;
parameters[76].Value = model.DianZu;
parameters[77].Value = model.LuoSi;
parameters[78].Value = model.ReSuoTaoGuan;
parameters[79].Value = model.AnZhuangPJ;
parameters[80].Value = model.YuanQiJian1;
parameters[81].Value = model.YuanQiJian2;
parameters[82].Value = model.YuanQiJian3;
parameters[83].Value = model.YuanQiJian4;
parameters[84].Value = model.GujiaCanshu;
parameters[85].Value = model.GujiaCount;
parameters[86].Value = model.TongpaiCanshu;
parameters[87].Value = model.TongpaoCount;
parameters[88].Value = model.CihuanCanshu;
parameters[89].Value = model.CihuanCount;
parameters[90].Value = model.DuanziCanshu;
parameters[91].Value = model.DuanziCount;
parameters[92].Value = model.XianlubanCanshu;
parameters[93].Value = model.XianlubanCount;
parameters[94].Value = model.JiaopianCanshu;
parameters[95].Value = model.JiaopianCount;
parameters[96].Value = model.PingbiCanshu;
parameters[97].Value = model.PingbiCount;
parameters[98].Value = model.WenyaguanCanshu;
parameters[99].Value = model.WenyaguanCount;
parameters[100].Value = model.DianzuCanshu;
parameters[101].Value = model.DianzuCount;
parameters[102].Value = model.LuosiCanshu;
parameters[103].Value = model.LuosiCount;
parameters[104].Value = model.ResuotaoguanCanshu;
parameters[105].Value = model.ResuotaoguanCount;
parameters[106].Value = model.AnzhuangPJCanshu;
parameters[107].Value = model.AnzhuangPJCount;
parameters[108].Value = model.Yuanqijian1Canshu;
parameters[109].Value = model.Yuanqijian1Count1;
parameters[110].Value = model.Yuanqijian2Canshu1;
parameters[111].Value = model.Yuanqijian2Count1;
parameters[112].Value = model.Yuanqijian3Canshu1;
parameters[113].Value = model.Yuanqijian3Count1;
parameters[114].Value = model.Yuanqijian4Canshu1;
parameters[115].Value = model.Yuanqijian4Count1;
parameters[116].Value = model.productId;
return SqlHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public static int UpdateOrder(OrderPrintSystem.Model.ProOrdersDetailMOD model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update proOrdersDetail set ");
strSql.Append("piHao=@piHao,");
strSql.Append("planSendTime=@planSendTime,");
strSql.Append("productAddress=@productAddress,");
strSql.Append("SGDCount=@SGDCount");
strSql.Append(" where orderDetailId=@orderDetailId");
SqlParameter[] parameters = {
new SqlParameter("@piHao",SqlDbType.VarChar,50),
new SqlParameter("@planSendTime",SqlDbType.DateTime),
new SqlParameter("@productAddress",SqlDbType.VarChar,100),
new SqlParameter("@SGDCount",SqlDbType.Int,4),
new SqlParameter("@orderDetailId", SqlDbType.Int,4)
};
parameters[0].Value = model.PiHao;
parameters[1].Value = model.PlanSendTime;
parameters[2].Value = model.ProductAddress;
parameters[3].Value = model.SGDCount;
parameters[4].Value = model.orderDetailId;
int readers = SqlHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
return readers;
}
/// <summary>
/// 更新一条数据
/// </summary>
public static int Update(OrderPrintSystem.Model.ProOrdersDetailMOD model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update proOrdersDetail set ");
strSql.Append("orderNum=@orderNum,");
strSql.Append("proType=@proType,");
strSql.Append("proNum=@proNum,");
strSql.Append("ProPrice=@ProPrice,");
strSql.Append("withWorkNo=@withWorkNo,");
strSql.Append("piHao=@piHao,");
strSql.Append("planSendTime=@planSendTime,");
strSql.Append("productAddress=@productAddress");
strSql.Append(" where orderDetailId=@orderDetailId");
SqlParameter[] parameters = {
new SqlParameter("@orderNum", SqlDbType.VarChar,100),
new SqlParameter("@proType", SqlDbType.VarChar,100),
new SqlParameter("@proNum", SqlDbType.Int,4),
new SqlParameter("@ProPrice", SqlDbType.Decimal,9),
new SqlParameter("@withWorkNo", SqlDbType.VarChar,50),
new SqlParameter("@piHao",SqlDbType.VarChar,50),
new SqlParameter("@planSendTime",SqlDbType.DateTime),
new SqlParameter("@productAddress",SqlDbType.VarChar,100),
new SqlParameter("@orderDetailId", SqlDbType.Int,4)};
parameters[0].Value = model.orderNum;
parameters[1].Value = model.proType;
parameters[2].Value = model.proNum;
parameters[3].Value = model.ProPrice;
parameters[4].Value = model.withWorkNo;
parameters[5].Value = model.PiHao;
parameters[6].Value = model.PlanSendTime;
parameters[7].Value = model.ProductAddress;
parameters[8].Value = model.orderDetailId;
int readers = SqlHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
return readers;
}
