/// <summary> /// 删除一条数据 /// </summary> public bool Delete(string Barcode, string FYDH, int CKDH, string PCH, string WLH, DateTime WeightRQ, string ProduceData) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from WMS_Bms_Inv_OutInfo "); strSql.Append(" where Barcode=:Barcode and FYDH=:FYDH and CKDH=:CKDH and PCH=:PCH and WLH=:WLH and WeightRQ=:WeightRQ and ProduceData=:ProduceData "); SqlParameter[] parameters = { new SqlParameter(":Barcode", SqlDbType.VarChar, 20), new SqlParameter(":FYDH", SqlDbType.VarChar, 50), new SqlParameter(":CKDH", SqlDbType.Int, 4), new SqlParameter(":PCH", SqlDbType.VarChar, 20), new SqlParameter(":WLH", SqlDbType.VarChar, 20), new SqlParameter(":WeightRQ", SqlDbType.DateTime), new SqlParameter(":ProduceData", SqlDbType.VarChar, 20) }; parameters[0].Value = Barcode; parameters[1].Value = FYDH; parameters[2].Value = CKDH; parameters[3].Value = PCH; parameters[4].Value = WLH; parameters[5].Value = WeightRQ; parameters[6].Value = ProduceData; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(string ZKDH, string CPH, string Barcode, string PCH, string SX) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from WMS_Bms_Tra_ZKD_Detail "); strSql.Append(" where ZKDH=:ZKDH and CPH=:CPH and Barcode=:Barcode and PCH=:PCH and SX=:SX "); SqlParameter[] parameters = { new SqlParameter(":ZKDH", SqlDbType.VarChar, 50), new SqlParameter(":CPH", SqlDbType.VarChar, 30), new SqlParameter(":Barcode", SqlDbType.VarChar, 20), new SqlParameter(":PCH", SqlDbType.VarChar, 20), new SqlParameter(":SX", SqlDbType.VarChar, 30) }; parameters[0].Value = ZKDH; parameters[1].Value = CPH; parameters[2].Value = Barcode; parameters[3].Value = PCH; parameters[4].Value = SX; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(string WGDH, string PCH, string PH, string GG, string SCX, string WLH) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from WMS_Bms_Rec_WGD "); strSql.Append(" where WGDH=:WGDH and PCH=:PCH and PH=:PH and GG=:GG and SCX=:SCX and WLH=:WLH "); SqlParameter[] parameters = { new SqlParameter(":WGDH", SqlDbType.VarChar, 50), new SqlParameter(":PCH", SqlDbType.VarChar, 20), new SqlParameter(":PH", SqlDbType.VarChar, 30), new SqlParameter(":GG", SqlDbType.VarChar, 30), new SqlParameter(":SCX", SqlDbType.VarChar, 50), new SqlParameter(":WLH", SqlDbType.VarChar, 20) }; parameters[0].Value = WGDH; parameters[1].Value = PCH; parameters[2].Value = PH; parameters[3].Value = GG; parameters[4].Value = SCX; parameters[5].Value = WLH; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(string ZKDH, string SCK, string TCK, string WLH) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from WMS_Bms_Tra_ZKD "); strSql.Append(" where ZKDH=:ZKDH and SCK=:SCK and TCK=:TCK and WLH=:WLH "); SqlParameter[] parameters = { new SqlParameter(":ZKDH", SqlDbType.VarChar, 50), new SqlParameter(":SCK", SqlDbType.VarChar, 30), new SqlParameter(":TCK", SqlDbType.VarChar, 30), new SqlParameter(":WLH", SqlDbType.VarChar, 20) }; parameters[0].Value = ZKDH; parameters[1].Value = SCK; parameters[2].Value = TCK; parameters[3].Value = WLH; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_SeZJB_Shift_Record model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SeZJB_Shift_Record set "); strSql.Append("ywdh=@ywdh,"); strSql.Append("ck=@ck,"); strSql.Append("shw=@shw,"); strSql.Append("dhw=@dhw,"); strSql.Append("czry=@czry,"); strSql.Append("czrq=@czrq,"); strSql.Append("ZJBstatus=@ZJBstatus,"); strSql.Append("ts=@ts,"); strSql.Append("by1=@by1,"); strSql.Append("by2=@by2,"); strSql.Append("by3=@by3,"); strSql.Append("by4=@by4,"); strSql.Append("by5=@by5"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@ywdh", SqlDbType.VarChar, 50), new SqlParameter("@ck", SqlDbType.VarChar, 50), new SqlParameter("@shw", SqlDbType.VarChar, 50), new SqlParameter("@dhw", SqlDbType.VarChar, 50), new SqlParameter("@czry", SqlDbType.VarChar, 50), new SqlParameter("@czrq", SqlDbType.DateTime), new SqlParameter("@ZJBstatus", SqlDbType.Int, 4), new SqlParameter("@ts", SqlDbType.DateTime), new SqlParameter("@by1", SqlDbType.VarChar, 100), new SqlParameter("@by2", SqlDbType.VarChar, 100), new SqlParameter("@by3", SqlDbType.VarChar, 100), new SqlParameter("@by4", SqlDbType.VarChar, 100), new SqlParameter("@by5", SqlDbType.VarChar, 100) }; parameters[0].Value = model.ywdh; parameters[1].Value = model.ck; parameters[2].Value = model.shw; parameters[3].Value = model.dhw; parameters[4].Value = model.czry; parameters[5].Value = model.czrq; parameters[6].Value = model.ZJBstatus; parameters[7].Value = model.ts; parameters[8].Value = model.by1; parameters[9].Value = model.by2; parameters[10].Value = model.by3; parameters[11].Value = model.by4; parameters[12].Value = model.by5; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_SeZJB_PDD_FINISHED model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SeZJB_PDD_FINISHED("); strSql.Append("ysdh,ck,pdrq,djzt,shuser,shdate,finished,ZJBstatus,ts,by1,by2,by3,by4,by5)"); strSql.Append(" values ("); strSql.Append("@ysdh,@ck,@pdrq,@djzt,@shuser,@shdate,@finished,@ZJBstatus,@ts,@by1,@by2,@by3,@by4,@by5)"); SqlParameter[] parameters = { new SqlParameter("@ysdh", SqlDbType.VarChar, 50), new SqlParameter("@ck", SqlDbType.VarChar, 20), new SqlParameter("@pdrq", SqlDbType.DateTime), new SqlParameter("@djzt", SqlDbType.VarChar, 10), new SqlParameter("@shuser", SqlDbType.VarChar, 20), new SqlParameter("@shdate", SqlDbType.DateTime), new SqlParameter("@finished", SqlDbType.Int, 4), new SqlParameter("@ZJBstatus", SqlDbType.Int, 4), new SqlParameter("@ts", SqlDbType.DateTime), new SqlParameter("@by1", SqlDbType.VarChar, 100), new SqlParameter("@by2", SqlDbType.VarChar, 100), new SqlParameter("@by3", SqlDbType.VarChar, 100), new SqlParameter("@by4", SqlDbType.VarChar, 100), new SqlParameter("@by5", SqlDbType.VarChar, 100) }; parameters[0].Value = model.ysdh; parameters[1].Value = model.ck; parameters[2].Value = model.pdrq; parameters[3].Value = model.djzt; parameters[4].Value = model.shuser; parameters[5].Value = model.shdate; parameters[6].Value = model.finished; parameters[7].Value = model.ZJBstatus; parameters[8].Value = model.ts; parameters[9].Value = model.by1; parameters[10].Value = model.by2; parameters[11].Value = model.by3; parameters[12].Value = model.by4; parameters[13].Value = model.by5; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_SeZJB_WGD_Finished model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SeZJB_WGD_Finished set "); strSql.Append("wgdh=@wgdh,"); strSql.Append("pch=@pch,"); strSql.Append("finished=@finished,"); strSql.Append("ZJBstatus=@ZJBstatus,"); strSql.Append("ts=@ts,"); strSql.Append("by1=@by1,"); strSql.Append("by2=@by2,"); strSql.Append("by3=@by3,"); strSql.Append("by4=@by4,"); strSql.Append("by5=@by5"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@wgdh", SqlDbType.VarChar, 50), new SqlParameter("@pch", SqlDbType.VarChar, 20), new SqlParameter("@finished", SqlDbType.Int, 4), new SqlParameter("@ZJBstatus", SqlDbType.Int, 4), new SqlParameter("@ts", SqlDbType.DateTime), new SqlParameter("@by1", SqlDbType.VarChar, 100), new SqlParameter("@by2", SqlDbType.VarChar, 100), new SqlParameter("@by3", SqlDbType.VarChar, 100), new SqlParameter("@by4", SqlDbType.VarChar, 100), new SqlParameter("@by5", SqlDbType.VarChar, 100) }; parameters[0].Value = model.wgdh; parameters[1].Value = model.pch; parameters[2].Value = model.finished; parameters[3].Value = model.ZJBstatus; parameters[4].Value = model.ts; parameters[5].Value = model.by1; parameters[6].Value = model.by2; parameters[7].Value = model.by3; parameters[8].Value = model.by4; parameters[9].Value = model.by5; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_SeZJB_Shift_Record model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SeZJB_Shift_Record("); strSql.Append("ywdh,ck,shw,dhw,czry,czrq,ZJBstatus,ts,by1,by2,by3,by4,by5)"); strSql.Append(" values ("); strSql.Append("@ywdh,@ck,@shw,@dhw,@czry,@czrq,@ZJBstatus,@ts,@by1,@by2,@by3,@by4,@by5)"); SqlParameter[] parameters = { new SqlParameter("@ywdh", SqlDbType.VarChar, 50), new SqlParameter("@ck", SqlDbType.VarChar, 50), new SqlParameter("@shw", SqlDbType.VarChar, 50), new SqlParameter("@dhw", SqlDbType.VarChar, 50), new SqlParameter("@czry", SqlDbType.VarChar, 50), new SqlParameter("@czrq", SqlDbType.DateTime), new SqlParameter("@ZJBstatus", SqlDbType.Int, 4), new SqlParameter("@ts", SqlDbType.DateTime), new SqlParameter("@by1", SqlDbType.VarChar, 100), new SqlParameter("@by2", SqlDbType.VarChar, 100), new SqlParameter("@by3", SqlDbType.VarChar, 100), new SqlParameter("@by4", SqlDbType.VarChar, 100), new SqlParameter("@by5", SqlDbType.VarChar, 100) }; parameters[0].Value = model.ywdh; parameters[1].Value = model.ck; parameters[2].Value = model.shw; parameters[3].Value = model.dhw; parameters[4].Value = model.czry; parameters[5].Value = model.czrq; parameters[6].Value = model.ZJBstatus; parameters[7].Value = model.ts; parameters[8].Value = model.by1; parameters[9].Value = model.by2; parameters[10].Value = model.by3; parameters[11].Value = model.by4; parameters[12].Value = model.by5; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_WMS_Bms_Tra_ZKD_Total model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update WMS_Bms_Tra_ZKD_Total set "); strSql.Append("CKNUM=:CKNUM,"); strSql.Append("RKNUM=:RKNUM,"); strSql.Append("CKOperator=:CKOperator,"); strSql.Append("CKTime=:CKTime,"); strSql.Append("YKOperator=:YKOperator,"); strSql.Append("YKTime=:YKTime"); strSql.Append(" where ZKDH=:ZKDH and PCH=:PCH and SX=:SX and CPH=:CPH "); SqlParameter[] parameters = { new SqlParameter(":CKNUM", SqlDbType.Int, 4), new SqlParameter(":RKNUM", SqlDbType.Int, 4), new SqlParameter(":CKOperator", SqlDbType.VarChar, 20), new SqlParameter(":CKTime", SqlDbType.DateTime), new SqlParameter(":YKOperator", SqlDbType.VarChar, 20), new SqlParameter(":YKTime", SqlDbType.DateTime), new SqlParameter(":ZKDH", SqlDbType.VarChar, 50), new SqlParameter(":PCH", SqlDbType.VarChar, 20), new SqlParameter(":SX", SqlDbType.VarChar, 30), new SqlParameter(":CPH", SqlDbType.VarChar, 30) }; parameters[0].Value = model.CKNUM; parameters[1].Value = model.RKNUM; parameters[2].Value = model.CKOperator; parameters[3].Value = model.CKTime; parameters[4].Value = model.YKOperator; parameters[5].Value = model.YKTime; parameters[6].Value = model.ZKDH; parameters[7].Value = model.PCH; parameters[8].Value = model.SX; parameters[9].Value = model.CPH; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 批量删除数据 /// </summary> public bool DeleteList(string Barcodelist) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from WMS_Bms_Tra_ZKD_Item "); strSql.Append(" where Barcode in (" + Barcodelist + ") "); int rows = DbHelper_SQL.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 批量删除数据 /// </summary> public bool DeleteList(string pk_ZJB_FYDlist) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from ReZJB_FYD "); strSql.Append(" where pk_ZJB_FYD in (" + pk_ZJB_FYDlist + ") "); int rows = DbHelper_SQL.ExecuteSql(strSql.ToString()); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(string Barcode, string WGDH, string CK, string HW, string PCH, string WLH, string SX, string PH, string ProduceData, string vfree1, string vfree2, string vfree3) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from WMS_Bms_Inv_Info "); strSql.Append(" where Barcode=:Barcode and WGDH=:WGDH and CK=:CK and HW=:HW and PCH=:PCH and WLH=:WLH and SX=:SX and PH=:PH and ProduceData=:ProduceData and vfree1=:vfree1 and vfree2=:vfree2 and vfree3=:vfree3 "); SqlParameter[] parameters = { new SqlParameter(":Barcode", SqlDbType.VarChar, 20), new SqlParameter(":WGDH", SqlDbType.VarChar, 50), new SqlParameter(":CK", SqlDbType.VarChar, 30), new SqlParameter(":HW", SqlDbType.VarChar, 20), new SqlParameter(":PCH", SqlDbType.VarChar, 20), new SqlParameter(":WLH", SqlDbType.VarChar, 20), new SqlParameter(":SX", SqlDbType.VarChar, 30), new SqlParameter(":PH", SqlDbType.VarChar, 30), new SqlParameter(":ProduceData", SqlDbType.VarChar, 20), new SqlParameter(":vfree1", SqlDbType.VarChar, 50), new SqlParameter(":vfree2", SqlDbType.VarChar, 50), new SqlParameter(":vfree3", SqlDbType.VarChar, 50) }; parameters[0].Value = Barcode; parameters[1].Value = WGDH; parameters[2].Value = CK; parameters[3].Value = HW; parameters[4].Value = PCH; parameters[5].Value = WLH; parameters[6].Value = SX; parameters[7].Value = PH; parameters[8].Value = ProduceData; parameters[9].Value = vfree1; parameters[10].Value = vfree2; parameters[11].Value = vfree3; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_SeZJB_WGD_Finished model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SeZJB_WGD_Finished("); strSql.Append("wgdh,pch,finished,ZJBstatus,ts,by1,by2,by3,by4,by5)"); strSql.Append(" values ("); strSql.Append("@wgdh,@pch,@finished,@ZJBstatus,@ts,@by1,@by2,@by3,@by4,@by5)"); SqlParameter[] parameters = { new SqlParameter("@wgdh", SqlDbType.VarChar, 50), new SqlParameter("@pch", SqlDbType.VarChar, 20), new SqlParameter("@finished", SqlDbType.Int, 4), new SqlParameter("@ZJBstatus", SqlDbType.Int, 4), new SqlParameter("@ts", SqlDbType.DateTime), new SqlParameter("@by1", SqlDbType.VarChar, 100), new SqlParameter("@by2", SqlDbType.VarChar, 100), new SqlParameter("@by3", SqlDbType.VarChar, 100), new SqlParameter("@by4", SqlDbType.VarChar, 100), new SqlParameter("@by5", SqlDbType.VarChar, 100) }; parameters[0].Value = model.wgdh; parameters[1].Value = model.pch; parameters[2].Value = model.finished; parameters[3].Value = model.ZJBstatus; parameters[4].Value = model.ts; parameters[5].Value = model.by1; parameters[6].Value = model.by2; parameters[7].Value = model.by3; parameters[8].Value = model.by4; parameters[9].Value = model.by5; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_WMS_Bms_Tra_ZKD_Total model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into WMS_Bms_Tra_ZKD_Total("); strSql.Append("ZKDH,PCH,SX,CPH,CKNUM,RKNUM,CKOperator,CKTime,YKOperator,YKTime)"); strSql.Append(" values ("); strSql.Append(":ZKDH,:PCH,:SX,:CPH,:CKNUM,:RKNUM,:CKOperator,:CKTime,:YKOperator,:YKTime)"); SqlParameter[] parameters = { new SqlParameter(":ZKDH", SqlDbType.VarChar, 50), new SqlParameter(":PCH", SqlDbType.VarChar, 20), new SqlParameter(":SX", SqlDbType.VarChar, 30), new SqlParameter(":CPH", SqlDbType.VarChar, 30), new SqlParameter(":CKNUM", SqlDbType.Int, 4), new SqlParameter(":RKNUM", SqlDbType.Int, 4), new SqlParameter(":CKOperator", SqlDbType.VarChar, 20), new SqlParameter(":CKTime", SqlDbType.DateTime), new SqlParameter(":YKOperator", SqlDbType.VarChar, 20), new SqlParameter(":YKTime", SqlDbType.DateTime) }; parameters[0].Value = model.ZKDH; parameters[1].Value = model.PCH; parameters[2].Value = model.SX; parameters[3].Value = model.CPH; parameters[4].Value = model.CKNUM; parameters[5].Value = model.RKNUM; parameters[6].Value = model.CKOperator; parameters[7].Value = model.CKTime; parameters[8].Value = model.YKOperator; parameters[9].Value = model.YKTime; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("delete from SeZJB_Shift_Record "); strSql.Append(" where "); SqlParameter[] parameters = { }; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_ReZJB_PDD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ReZJB_PDD set "); strSql.Append("ZJBstatus=@ZJBstatus,"); strSql.Append("CAPPK=@CAPPK,"); strSql.Append("ck=@ck,"); strSql.Append("pdrq=@pdrq,"); strSql.Append("ysdh=@ysdh"); strSql.Append(" where pk_ZJB_PDD=@pk_ZJB_PDD"); SqlParameter[] parameters = { new SqlParameter("@ZJBstatus", SqlDbType.Int, 4), new SqlParameter("@CAPPK", SqlDbType.VarChar, 50), new SqlParameter("@ck", SqlDbType.VarChar, 50), new SqlParameter("@pdrq", SqlDbType.DateTime), new SqlParameter("@ysdh", SqlDbType.VarChar, 50), new SqlParameter("@pk_ZJB_PDD", SqlDbType.Int, 4) }; parameters[0].Value = model.ZJBstatus; parameters[1].Value = model.CAPPK; parameters[2].Value = model.ck; parameters[3].Value = model.pdrq; parameters[4].Value = model.ysdh; parameters[5].Value = model.pk_ZJB_PDD; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(string Barcode) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from WMS_Bms_Tra_ZKD_Item "); strSql.Append(" where Barcode=:Barcode "); SqlParameter[] parameters = { new SqlParameter(":Barcode", SqlDbType.VarChar, 20) }; parameters[0].Value = Barcode; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int pk_ZJB_FYD) { StringBuilder strSql = new StringBuilder(); strSql.Append("delete from ReZJB_FYD "); strSql.Append(" where pk_ZJB_FYD=@pk_ZJB_FYD"); SqlParameter[] parameters = { new SqlParameter("@pk_ZJB_FYD", SqlDbType.Int, 4) }; parameters[0].Value = pk_ZJB_FYD; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_WMS_Bms_Rec_WGD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update WMS_Bms_Rec_WGD set "); strSql.Append("BB=:BB,"); strSql.Append("NCWLBMID=:NCWLBMID,"); strSql.Append("WLMC=:WLMC,"); strSql.Append("FZDW=:FZDW,"); strSql.Append("ZXBZ=:ZXBZ,"); strSql.Append("PCSX=:PCSX,"); strSql.Append("PCLX=:PCLX,"); strSql.Append("ZLDJ=:ZLDJ,"); strSql.Append("ZPGP=:ZPGP,"); strSql.Append("PCXH=:PCXH,"); strSql.Append("WCBZ=:WCBZ,"); strSql.Append("PGBZ=:PGBZ,"); strSql.Append("ZJBZ=:ZJBZ,"); strSql.Append("ZPDJBZ=:ZPDJBZ,"); strSql.Append("Rev_Time=:Rev_Time,"); strSql.Append("End_Time=:End_Time,"); strSql.Append("PEnd_Time=:PEnd_Time,"); strSql.Append("FEW_scx=:FEW_scx,"); strSql.Append("SendEnd=:SendEnd,"); strSql.Append("IsTran=:IsTran,"); strSql.Append("YWLH=:YWLH,"); strSql.Append("YWLMC=:YWLMC,"); strSql.Append("YPH=:YPH,"); strSql.Append("YGG=:YGG,"); strSql.Append("YZXBZ=:YZXBZ,"); strSql.Append("ZDR=:ZDR,"); strSql.Append("ZDDATE=:ZDDATE,"); strSql.Append("UPDATERY=:UPDATERY,"); strSql.Append("UPDATEDATE=:UPDATEDATE,"); strSql.Append("FLAG=:FLAG,"); strSql.Append("Filed1=:Filed1,"); strSql.Append("PCInfo=:PCInfo,"); strSql.Append("Filed2=:Filed2,"); strSql.Append("SendBack=:SendBack,"); strSql.Append("vfree0=:vfree0,"); strSql.Append("vfree1=:vfree1,"); strSql.Append("vfree2=:vfree2,"); strSql.Append("vfree3=:vfree3,"); strSql.Append("vfree4=:vfree4,"); strSql.Append("yvfree0=:yvfree0,"); strSql.Append("yvfree1=:yvfree1,"); strSql.Append("yvfree2=:yvfree2,"); strSql.Append("yvfree3=:yvfree3,"); strSql.Append("yvfree4=:yvfree4,"); strSql.Append("GPZL=:GPZL"); strSql.Append(" where WGDH=:WGDH and PCH=:PCH and PH=:PH and GG=:GG and SCX=:SCX and WLH=:WLH "); SqlParameter[] parameters = { new SqlParameter(":BB", SqlDbType.VarChar, 10), new SqlParameter(":NCWLBMID", SqlDbType.VarChar, 20), new SqlParameter(":WLMC", SqlDbType.VarChar, 100), new SqlParameter(":FZDW", SqlDbType.VarChar, 10), new SqlParameter(":ZXBZ", SqlDbType.VarChar, 40), new SqlParameter(":PCSX", SqlDbType.VarChar, 30), new SqlParameter(":PCLX", SqlDbType.Int, 4), new SqlParameter(":ZLDJ", SqlDbType.VarChar, 10), new SqlParameter(":ZPGP", SqlDbType.VarChar, 30), new SqlParameter(":PCXH", SqlDbType.Int, 4), new SqlParameter(":WCBZ", SqlDbType.Int, 4), new SqlParameter(":PGBZ", SqlDbType.Int, 4), new SqlParameter(":ZJBZ", SqlDbType.Int, 4), new SqlParameter(":ZPDJBZ", SqlDbType.Int, 4), new SqlParameter(":Rev_Time", SqlDbType.DateTime), new SqlParameter(":End_Time", SqlDbType.DateTime), new SqlParameter(":PEnd_Time", SqlDbType.DateTime), new SqlParameter(":FEW_scx", SqlDbType.VarChar, 10), new SqlParameter(":SendEnd", SqlDbType.Int, 4), new SqlParameter(":IsTran", SqlDbType.Int, 4), new SqlParameter(":YWLH", SqlDbType.VarChar, 50), new SqlParameter(":YWLMC", SqlDbType.VarChar, 50), new SqlParameter(":YPH", SqlDbType.VarChar, 50), new SqlParameter(":YGG", SqlDbType.VarChar, 50), new SqlParameter(":YZXBZ", SqlDbType.VarChar, 50), new SqlParameter(":ZDR", SqlDbType.VarChar, 20), new SqlParameter(":ZDDATE", SqlDbType.DateTime), new SqlParameter(":UPDATERY", SqlDbType.VarChar, 20), new SqlParameter(":UPDATEDATE", SqlDbType.DateTime), new SqlParameter(":FLAG", SqlDbType.VarChar, 10), new SqlParameter(":Filed1", SqlDbType.VarChar, 50), new SqlParameter(":PCInfo", SqlDbType.VarChar, 150), new SqlParameter(":Filed2", SqlDbType.VarChar, 50), new SqlParameter(":SendBack", SqlDbType.Bit, 1), new SqlParameter(":vfree0", SqlDbType.VarChar, 50), new SqlParameter(":vfree1", SqlDbType.VarChar, 50), new SqlParameter(":vfree2", SqlDbType.VarChar, 50), new SqlParameter(":vfree3", SqlDbType.VarChar, 50), new SqlParameter(":vfree4", SqlDbType.VarChar, 50), new SqlParameter(":yvfree0", SqlDbType.VarChar, 50), new SqlParameter(":yvfree1", SqlDbType.VarChar, 50), new SqlParameter(":yvfree2", SqlDbType.VarChar, 50), new SqlParameter(":yvfree3", SqlDbType.VarChar, 50), new SqlParameter(":yvfree4", SqlDbType.VarChar, 50), new SqlParameter(":GPZL", SqlDbType.Decimal, 9), new SqlParameter(":WGDH", SqlDbType.VarChar, 50), new SqlParameter(":PCH", SqlDbType.VarChar, 20), new SqlParameter(":PH", SqlDbType.VarChar, 30), new SqlParameter(":GG", SqlDbType.VarChar, 30), new SqlParameter(":SCX", SqlDbType.VarChar, 50), new SqlParameter(":WLH", SqlDbType.VarChar, 20) }; parameters[0].Value = model.BB; parameters[1].Value = model.NCWLBMID; parameters[2].Value = model.WLMC; parameters[3].Value = model.FZDW; parameters[4].Value = model.ZXBZ; parameters[5].Value = model.PCSX; parameters[6].Value = model.PCLX; parameters[7].Value = model.ZLDJ; parameters[8].Value = model.ZPGP; parameters[9].Value = model.PCXH; parameters[10].Value = model.WCBZ; parameters[11].Value = model.PGBZ; parameters[12].Value = model.ZJBZ; parameters[13].Value = model.ZPDJBZ; parameters[14].Value = model.Rev_Time; parameters[15].Value = model.End_Time; parameters[16].Value = model.PEnd_Time; parameters[17].Value = model.FEW_scx; parameters[18].Value = model.SendEnd; parameters[19].Value = model.IsTran; parameters[20].Value = model.YWLH; parameters[21].Value = model.YWLMC; parameters[22].Value = model.YPH; parameters[23].Value = model.YGG; parameters[24].Value = model.YZXBZ; parameters[25].Value = model.ZDR; parameters[26].Value = model.ZDDATE; parameters[27].Value = model.UPDATERY; parameters[28].Value = model.UPDATEDATE; parameters[29].Value = model.FLAG; parameters[30].Value = model.Filed1; parameters[31].Value = model.PCInfo; parameters[32].Value = model.Filed2; parameters[33].Value = model.SendBack; parameters[34].Value = model.vfree0; parameters[35].Value = model.vfree1; parameters[36].Value = model.vfree2; parameters[37].Value = model.vfree3; parameters[38].Value = model.vfree4; parameters[39].Value = model.yvfree0; parameters[40].Value = model.yvfree1; parameters[41].Value = model.yvfree2; parameters[42].Value = model.yvfree3; parameters[43].Value = model.yvfree4; parameters[44].Value = model.GPZL; parameters[45].Value = model.WGDH; parameters[46].Value = model.PCH; parameters[47].Value = model.PH; parameters[48].Value = model.GG; parameters[49].Value = model.SCX; parameters[50].Value = model.WLH; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_WMS_Bms_Rec_WGD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into WMS_Bms_Rec_WGD("); strSql.Append("WGDH,PCH,PH,GG,BB,SCX,NCWLBMID,WLH,WLMC,FZDW,ZXBZ,PCSX,PCLX,ZLDJ,ZPGP,PCXH,WCBZ,PGBZ,ZJBZ,ZPDJBZ,Rev_Time,End_Time,PEnd_Time,FEW_scx,SendEnd,IsTran,YWLH,YWLMC,YPH,YGG,YZXBZ,ZDR,ZDDATE,UPDATERY,UPDATEDATE,FLAG,Filed1,PCInfo,Filed2,SendBack,vfree0,vfree1,vfree2,vfree3,vfree4,yvfree0,yvfree1,yvfree2,yvfree3,yvfree4,GPZL)"); strSql.Append(" values ("); strSql.Append(":WGDH,:PCH,:PH,:GG,:BB,:SCX,:NCWLBMID,:WLH,:WLMC,:FZDW,:ZXBZ,:PCSX,:PCLX,:ZLDJ,:ZPGP,:PCXH,:WCBZ,:PGBZ,:ZJBZ,:ZPDJBZ,:Rev_Time,:End_Time,:PEnd_Time,:FEW_scx,:SendEnd,:IsTran,:YWLH,:YWLMC,:YPH,:YGG,:YZXBZ,:ZDR,:ZDDATE,:UPDATERY,:UPDATEDATE,:FLAG,:Filed1,:PCInfo,:Filed2,:SendBack,:vfree0,:vfree1,:vfree2,:vfree3,:vfree4,:yvfree0,:yvfree1,:yvfree2,:yvfree3,:yvfree4,:GPZL)"); SqlParameter[] parameters = { new SqlParameter(":WGDH", SqlDbType.VarChar, 50), new SqlParameter(":PCH", SqlDbType.VarChar, 20), new SqlParameter(":PH", SqlDbType.VarChar, 30), new SqlParameter(":GG", SqlDbType.VarChar, 30), new SqlParameter(":BB", SqlDbType.VarChar, 10), new SqlParameter(":SCX", SqlDbType.VarChar, 50), new SqlParameter(":NCWLBMID", SqlDbType.VarChar, 20), new SqlParameter(":WLH", SqlDbType.VarChar, 20), new SqlParameter(":WLMC", SqlDbType.VarChar, 100), new SqlParameter(":FZDW", SqlDbType.VarChar, 10), new SqlParameter(":ZXBZ", SqlDbType.VarChar, 40), new SqlParameter(":PCSX", SqlDbType.VarChar, 30), new SqlParameter(":PCLX", SqlDbType.Int, 4), new SqlParameter(":ZLDJ", SqlDbType.VarChar, 10), new SqlParameter(":ZPGP", SqlDbType.VarChar, 30), new SqlParameter(":PCXH", SqlDbType.Int, 4), new SqlParameter(":WCBZ", SqlDbType.Int, 4), new SqlParameter(":PGBZ", SqlDbType.Int, 4), new SqlParameter(":ZJBZ", SqlDbType.Int, 4), new SqlParameter(":ZPDJBZ", SqlDbType.Int, 4), new SqlParameter(":Rev_Time", SqlDbType.DateTime), new SqlParameter(":End_Time", SqlDbType.DateTime), new SqlParameter(":PEnd_Time", SqlDbType.DateTime), new SqlParameter(":FEW_scx", SqlDbType.VarChar, 10), new SqlParameter(":SendEnd", SqlDbType.Int, 4), new SqlParameter(":IsTran", SqlDbType.Int, 4), new SqlParameter(":YWLH", SqlDbType.VarChar, 50), new SqlParameter(":YWLMC", SqlDbType.VarChar, 50), new SqlParameter(":YPH", SqlDbType.VarChar, 50), new SqlParameter(":YGG", SqlDbType.VarChar, 50), new SqlParameter(":YZXBZ", SqlDbType.VarChar, 50), new SqlParameter(":ZDR", SqlDbType.VarChar, 20), new SqlParameter(":ZDDATE", SqlDbType.DateTime), new SqlParameter(":UPDATERY", SqlDbType.VarChar, 20), new SqlParameter(":UPDATEDATE", SqlDbType.DateTime), new SqlParameter(":FLAG", SqlDbType.VarChar, 10), new SqlParameter(":Filed1", SqlDbType.VarChar, 50), new SqlParameter(":PCInfo", SqlDbType.VarChar, 150), new SqlParameter(":Filed2", SqlDbType.VarChar, 50), new SqlParameter(":SendBack", SqlDbType.Bit, 1), new SqlParameter(":vfree0", SqlDbType.VarChar, 50), new SqlParameter(":vfree1", SqlDbType.VarChar, 50), new SqlParameter(":vfree2", SqlDbType.VarChar, 50), new SqlParameter(":vfree3", SqlDbType.VarChar, 50), new SqlParameter(":vfree4", SqlDbType.VarChar, 50), new SqlParameter(":yvfree0", SqlDbType.VarChar, 50), new SqlParameter(":yvfree1", SqlDbType.VarChar, 50), new SqlParameter(":yvfree2", SqlDbType.VarChar, 50), new SqlParameter(":yvfree3", SqlDbType.VarChar, 50), new SqlParameter(":yvfree4", SqlDbType.VarChar, 50), new SqlParameter(":GPZL", SqlDbType.Decimal, 9) }; parameters[0].Value = model.WGDH; parameters[1].Value = model.PCH; parameters[2].Value = model.PH; parameters[3].Value = model.GG; parameters[4].Value = model.BB; parameters[5].Value = model.SCX; parameters[6].Value = model.NCWLBMID; parameters[7].Value = model.WLH; parameters[8].Value = model.WLMC; parameters[9].Value = model.FZDW; parameters[10].Value = model.ZXBZ; parameters[11].Value = model.PCSX; parameters[12].Value = model.PCLX; parameters[13].Value = model.ZLDJ; parameters[14].Value = model.ZPGP; parameters[15].Value = model.PCXH; parameters[16].Value = model.WCBZ; parameters[17].Value = model.PGBZ; parameters[18].Value = model.ZJBZ; parameters[19].Value = model.ZPDJBZ; parameters[20].Value = model.Rev_Time; parameters[21].Value = model.End_Time; parameters[22].Value = model.PEnd_Time; parameters[23].Value = model.FEW_scx; parameters[24].Value = model.SendEnd; parameters[25].Value = model.IsTran; parameters[26].Value = model.YWLH; parameters[27].Value = model.YWLMC; parameters[28].Value = model.YPH; parameters[29].Value = model.YGG; parameters[30].Value = model.YZXBZ; parameters[31].Value = model.ZDR; parameters[32].Value = model.ZDDATE; parameters[33].Value = model.UPDATERY; parameters[34].Value = model.UPDATEDATE; parameters[35].Value = model.FLAG; parameters[36].Value = model.Filed1; parameters[37].Value = model.PCInfo; parameters[38].Value = model.Filed2; parameters[39].Value = model.SendBack; parameters[40].Value = model.vfree0; parameters[41].Value = model.vfree1; parameters[42].Value = model.vfree2; parameters[43].Value = model.vfree3; parameters[44].Value = model.vfree4; parameters[45].Value = model.yvfree0; parameters[46].Value = model.yvfree1; parameters[47].Value = model.yvfree2; parameters[48].Value = model.yvfree3; parameters[49].Value = model.yvfree4; parameters[50].Value = model.GPZL; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_ReZJB_GPD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ReZJB_GPD set "); strSql.Append("Barcode=@Barcode,"); strSql.Append("WGDH=@WGDH,"); strSql.Append("CK=@CK,"); strSql.Append("HW=@HW,"); strSql.Append("PCH=@PCH,"); strSql.Append("WLH=@WLH,"); strSql.Append("WLMC=@WLMC,"); strSql.Append("SX=@SX,"); strSql.Append("ZLDJ=@ZLDJ,"); strSql.Append("PH=@PH,"); strSql.Append("GG=@GG,"); strSql.Append("BB=@BB,"); strSql.Append("GH=@GH,"); strSql.Append("ZL=@ZL,"); strSql.Append("BZ=@BZ,"); strSql.Append("RQ=@RQ,"); strSql.Append("RKType=@RKType,"); strSql.Append("RKRY=@RKRY,"); strSql.Append("WeightRQ=@WeightRQ,"); strSql.Append("CKCXH=@CKCXH,"); strSql.Append("ProduceData=@ProduceData,"); strSql.Append("PCInfo=@PCInfo,"); strSql.Append("Filed1=@Filed1,"); strSql.Append("ErrSeason=@ErrSeason,"); strSql.Append("Filed2=@Filed2,"); strSql.Append("vfree0=@vfree0,"); strSql.Append("vfree1=@vfree1,"); strSql.Append("vfree2=@vfree2,"); strSql.Append("vfree3=@vfree3,"); strSql.Append("vfree4=@vfree4,"); strSql.Append("GPTYPE=@GPTYPE,"); strSql.Append("ZJBStatus=@ZJBStatus,"); strSql.Append("CAPPK=@CAPPK"); strSql.Append(" where pk_ZJB_GPD=@pk_ZJB_GPD"); SqlParameter[] parameters = { new SqlParameter("@Barcode", SqlDbType.VarChar, 20), new SqlParameter("@WGDH", SqlDbType.VarChar, 50), new SqlParameter("@CK", SqlDbType.VarChar, 30), new SqlParameter("@HW", SqlDbType.VarChar, 20), new SqlParameter("@PCH", SqlDbType.VarChar, 20), new SqlParameter("@WLH", SqlDbType.VarChar, 20), new SqlParameter("@WLMC", SqlDbType.VarChar, 100), new SqlParameter("@SX", SqlDbType.VarChar, 30), new SqlParameter("@ZLDJ", SqlDbType.VarChar, 10), new SqlParameter("@PH", SqlDbType.VarChar, 30), new SqlParameter("@GG", SqlDbType.VarChar, 30), new SqlParameter("@BB", SqlDbType.VarChar, 10), new SqlParameter("@GH", SqlDbType.Int, 4), new SqlParameter("@ZL", SqlDbType.Decimal, 9), new SqlParameter("@BZ", SqlDbType.VarChar, 50), new SqlParameter("@RQ", SqlDbType.DateTime), new SqlParameter("@RKType", SqlDbType.VarChar, 20), new SqlParameter("@RKRY", SqlDbType.VarChar, 20), new SqlParameter("@WeightRQ", SqlDbType.DateTime), new SqlParameter("@CKCXH", SqlDbType.Int, 4), new SqlParameter("@ProduceData", SqlDbType.VarChar, 20), new SqlParameter("@PCInfo", SqlDbType.VarChar, 150), new SqlParameter("@Filed1", SqlDbType.VarChar, 50), new SqlParameter("@ErrSeason", SqlDbType.VarChar, 50), new SqlParameter("@Filed2", SqlDbType.VarChar, 50), new SqlParameter("@vfree0", SqlDbType.VarChar, 300), new SqlParameter("@vfree1", SqlDbType.VarChar, 50), new SqlParameter("@vfree2", SqlDbType.VarChar, 50), new SqlParameter("@vfree3", SqlDbType.VarChar, 50), new SqlParameter("@vfree4", SqlDbType.VarChar, 50), new SqlParameter("@GPTYPE", SqlDbType.VarChar, 50), new SqlParameter("@ZJBStatus", SqlDbType.Int, 4), new SqlParameter("@CAPPK", SqlDbType.VarChar, 50), new SqlParameter("@pk_ZJB_GPD", SqlDbType.Int, 4) }; parameters[0].Value = model.Barcode; parameters[1].Value = model.WGDH; parameters[2].Value = model.CK; parameters[3].Value = model.HW; parameters[4].Value = model.PCH; parameters[5].Value = model.WLH; parameters[6].Value = model.WLMC; parameters[7].Value = model.SX; parameters[8].Value = model.ZLDJ; parameters[9].Value = model.PH; parameters[10].Value = model.GG; parameters[11].Value = model.BB; parameters[12].Value = model.GH; parameters[13].Value = model.ZL; parameters[14].Value = model.BZ; parameters[15].Value = model.RQ; parameters[16].Value = model.RKType; parameters[17].Value = model.RKRY; parameters[18].Value = model.WeightRQ; parameters[19].Value = model.CKCXH; parameters[20].Value = model.ProduceData; parameters[21].Value = model.PCInfo; parameters[22].Value = model.Filed1; parameters[23].Value = model.ErrSeason; parameters[24].Value = model.Filed2; parameters[25].Value = model.vfree0; parameters[26].Value = model.vfree1; parameters[27].Value = model.vfree2; parameters[28].Value = model.vfree3; parameters[29].Value = model.vfree4; parameters[30].Value = model.GPTYPE; parameters[31].Value = model.ZJBStatus; parameters[32].Value = model.CAPPK; parameters[33].Value = model.pk_ZJB_GPD; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_ReZJB_PDD_Item model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ReZJB_PDD_Item set "); strSql.Append("ysdh=@ysdh,"); strSql.Append("BARCODE=@BARCODE,"); strSql.Append("PCH=@PCH,"); strSql.Append("SX=@SX,"); strSql.Append("ZCSL=@ZCSL,"); strSql.Append("FZCZL=@FZCZL,"); strSql.Append("vfree0=@vfree0,"); strSql.Append("vfree1=@vfree1,"); strSql.Append("vfree2=@vfree2,"); strSql.Append("vfree3=@vfree3,"); strSql.Append("vfree4=@vfree4,"); strSql.Append("ZJBstatus=@ZJBstatus,"); strSql.Append("CAPPK=@CAPPK"); strSql.Append(" where pk_ZJB_PDD_Item=@pk_ZJB_PDD_Item"); SqlParameter[] parameters = { new SqlParameter("@ysdh", SqlDbType.VarChar, 50), new SqlParameter("@BARCODE", SqlDbType.VarChar, 50), new SqlParameter("@PCH", SqlDbType.VarChar, 50), new SqlParameter("@SX", SqlDbType.VarChar, 50), new SqlParameter("@ZCSL", SqlDbType.Int, 4), new SqlParameter("@FZCZL", SqlDbType.Decimal, 9), new SqlParameter("@vfree0", SqlDbType.VarChar, 150), new SqlParameter("@vfree1", SqlDbType.VarChar, 150), new SqlParameter("@vfree2", SqlDbType.VarChar, 150), new SqlParameter("@vfree3", SqlDbType.VarChar, 150), new SqlParameter("@vfree4", SqlDbType.VarChar, 150), new SqlParameter("@ZJBstatus", SqlDbType.Int, 4), new SqlParameter("@CAPPK", SqlDbType.VarChar, 50), new SqlParameter("@pk_ZJB_PDD_Item", SqlDbType.Int, 4) }; parameters[0].Value = model.ysdh; parameters[1].Value = model.BARCODE; parameters[2].Value = model.PCH; parameters[3].Value = model.SX; parameters[4].Value = model.ZCSL; parameters[5].Value = model.FZCZL; parameters[6].Value = model.vfree0; parameters[7].Value = model.vfree1; parameters[8].Value = model.vfree2; parameters[9].Value = model.vfree3; parameters[10].Value = model.vfree4; parameters[11].Value = model.ZJBstatus; parameters[12].Value = model.CAPPK; parameters[13].Value = model.pk_ZJB_PDD_Item; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_ReZJB_FYD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ReZJB_FYD set "); strSql.Append("fydh=@fydh,"); strSql.Append("ck=@ck,"); strSql.Append("khbm=@khbm,"); strSql.Append("yslb=@yslb,"); strSql.Append("cph=@cph,"); strSql.Append("wlh=@wlh,"); strSql.Append("wlmc=@wlmc,"); strSql.Append("sx=@sx,"); strSql.Append("zldj=@zldj,"); strSql.Append("jhsl=@jhsl,"); strSql.Append("jhzl=@jhzl,"); strSql.Append("zjldw=@zjldw,"); strSql.Append("fjldw=@fjldw,"); strSql.Append("varrivestation=@varrivestation,"); strSql.Append("zdr=@zdr,"); strSql.Append("zdrq=@zdrq,"); strSql.Append("PH=@PH,"); strSql.Append("GG=@GG,"); strSql.Append("PCInfo=@PCInfo,"); strSql.Append("zyx1=@zyx1,"); strSql.Append("zyx2=@zyx2,"); strSql.Append("zyx3=@zyx3,"); strSql.Append("zyx4=@zyx4,"); strSql.Append("zyx5=@zyx5,"); strSql.Append("ZJBstatus=@ZJBstatus,"); strSql.Append("CAPPK=@CAPPK,"); strSql.Append("ywbm=@ywbm,"); strSql.Append("ywry=@ywry"); strSql.Append(" where pk_ZJB_FYD=@pk_ZJB_FYD"); SqlParameter[] parameters = { new SqlParameter("@fydh", SqlDbType.VarChar, 50), new SqlParameter("@ck", SqlDbType.VarChar, 50), new SqlParameter("@khbm", SqlDbType.VarChar, 50), new SqlParameter("@yslb", SqlDbType.VarChar, 50), new SqlParameter("@cph", SqlDbType.VarChar, 50), new SqlParameter("@wlh", SqlDbType.VarChar, 50), new SqlParameter("@wlmc", SqlDbType.VarChar, 50), new SqlParameter("@sx", SqlDbType.VarChar, 50), new SqlParameter("@zldj", SqlDbType.VarChar, 50), new SqlParameter("@jhsl", SqlDbType.Decimal, 9), new SqlParameter("@jhzl", SqlDbType.Decimal, 9), new SqlParameter("@zjldw", SqlDbType.VarChar, 50), new SqlParameter("@fjldw", SqlDbType.VarChar, 50), new SqlParameter("@varrivestation", SqlDbType.VarChar, 50), new SqlParameter("@zdr", SqlDbType.VarChar, 50), new SqlParameter("@zdrq", SqlDbType.DateTime), new SqlParameter("@PH", SqlDbType.VarChar, 50), new SqlParameter("@GG", SqlDbType.VarChar, 50), new SqlParameter("@PCInfo", SqlDbType.VarChar, 50), new SqlParameter("@zyx1", SqlDbType.VarChar, 50), new SqlParameter("@zyx2", SqlDbType.VarChar, 50), new SqlParameter("@zyx3", SqlDbType.VarChar, 50), new SqlParameter("@zyx4", SqlDbType.VarChar, 50), new SqlParameter("@zyx5", SqlDbType.VarChar, 50), new SqlParameter("@ZJBstatus", SqlDbType.Int, 4), new SqlParameter("@CAPPK", SqlDbType.VarChar, 50), new SqlParameter("@ywbm", SqlDbType.VarChar, 50), new SqlParameter("@ywry", SqlDbType.VarChar, 50), new SqlParameter("@pk_ZJB_FYD", SqlDbType.Int, 4) }; parameters[0].Value = model.fydh; parameters[1].Value = model.ck; parameters[2].Value = model.khbm; parameters[3].Value = model.yslb; parameters[4].Value = model.cph; parameters[5].Value = model.wlh; parameters[6].Value = model.wlmc; parameters[7].Value = model.sx; parameters[8].Value = model.zldj; parameters[9].Value = model.jhsl; parameters[10].Value = model.jhzl; parameters[11].Value = model.zjldw; parameters[12].Value = model.fjldw; parameters[13].Value = model.varrivestation; parameters[14].Value = model.zdr; parameters[15].Value = model.zdrq; parameters[16].Value = model.PH; parameters[17].Value = model.GG; parameters[18].Value = model.PCInfo; parameters[19].Value = model.zyx1; parameters[20].Value = model.zyx2; parameters[21].Value = model.zyx3; parameters[22].Value = model.zyx4; parameters[23].Value = model.zyx5; parameters[24].Value = model.ZJBstatus; parameters[25].Value = model.CAPPK; parameters[26].Value = model.ywbm; parameters[27].Value = model.ywry; parameters[28].Value = model.pk_ZJB_FYD; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_WMS_Bms_Tra_ZKD_Detail model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into WMS_Bms_Tra_ZKD_Detail("); strSql.Append("ZKDH,CPH,Barcode,WLH,WLMC,PH,GG,PCH,SX,CK,HW,ZL,CKOperator,CKTime,YKOperator,YKTime,YRKDH,YRKTime,YRKOperator,YRKType,vfree0,vfree1,vfree2,vfree3,vfree4)"); strSql.Append(" values ("); strSql.Append(":ZKDH,:CPH,:Barcode,:WLH,:WLMC,:PH,:GG,:PCH,:SX,:CK,:HW,:ZL,:CKOperator,:CKTime,:YKOperator,:YKTime,:YRKDH,:YRKTime,:YRKOperator,:YRKType,:vfree0,:vfree1,:vfree2,:vfree3,:vfree4)"); SqlParameter[] parameters = { new SqlParameter(":ZKDH", SqlDbType.VarChar, 50), new SqlParameter(":CPH", SqlDbType.VarChar, 30), new SqlParameter(":Barcode", SqlDbType.VarChar, 20), new SqlParameter(":WLH", SqlDbType.VarChar, 30), new SqlParameter(":WLMC", SqlDbType.VarChar, 100), new SqlParameter(":PH", SqlDbType.VarChar, 30), new SqlParameter(":GG", SqlDbType.VarChar, 30), new SqlParameter(":PCH", SqlDbType.VarChar, 20), new SqlParameter(":SX", SqlDbType.VarChar, 30), new SqlParameter(":CK", SqlDbType.VarChar, 30), new SqlParameter(":HW", SqlDbType.VarChar, 20), new SqlParameter(":ZL", SqlDbType.Decimal, 9), new SqlParameter(":CKOperator", SqlDbType.VarChar, 20), new SqlParameter(":CKTime", SqlDbType.DateTime), new SqlParameter(":YKOperator", SqlDbType.VarChar, 20), new SqlParameter(":YKTime", SqlDbType.DateTime), new SqlParameter(":YRKDH", SqlDbType.VarChar, 50), new SqlParameter(":YRKTime", SqlDbType.DateTime), new SqlParameter(":YRKOperator", SqlDbType.VarChar, 20), new SqlParameter(":YRKType", SqlDbType.VarChar, 10), new SqlParameter(":vfree0", SqlDbType.VarChar, 50), new SqlParameter(":vfree1", SqlDbType.VarChar, 50), new SqlParameter(":vfree2", SqlDbType.VarChar, 50), new SqlParameter(":vfree3", SqlDbType.VarChar, 50), new SqlParameter(":vfree4", SqlDbType.VarChar, 50) }; parameters[0].Value = model.ZKDH; parameters[1].Value = model.CPH; parameters[2].Value = model.Barcode; parameters[3].Value = model.WLH; parameters[4].Value = model.WLMC; parameters[5].Value = model.PH; parameters[6].Value = model.GG; parameters[7].Value = model.PCH; parameters[8].Value = model.SX; parameters[9].Value = model.CK; parameters[10].Value = model.HW; parameters[11].Value = model.ZL; parameters[12].Value = model.CKOperator; parameters[13].Value = model.CKTime; parameters[14].Value = model.YKOperator; parameters[15].Value = model.YKTime; parameters[16].Value = model.YRKDH; parameters[17].Value = model.YRKTime; parameters[18].Value = model.YRKOperator; parameters[19].Value = model.YRKType; parameters[20].Value = model.vfree0; parameters[21].Value = model.vfree1; parameters[22].Value = model.vfree2; parameters[23].Value = model.vfree3; parameters[24].Value = model.vfree4; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_ReZJB_WGD_Item model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ReZJB_WGD_Item set "); strSql.Append("wgdh=@wgdh,"); strSql.Append("pch=@pch,"); strSql.Append("ph=@ph,"); strSql.Append("gg=@gg,"); strSql.Append("wlh=@wlh,"); strSql.Append("wlmc=@wlmc,"); strSql.Append("pcinfo=@pcinfo,"); strSql.Append("zyx1=@zyx1,"); strSql.Append("zyx2=@zyx2,"); strSql.Append("zyx3=@zyx3,"); strSql.Append("zyx4=@zyx4,"); strSql.Append("zyx5=@zyx5,"); strSql.Append("ZJBstatus=@ZJBstatus,"); strSql.Append("CAPPK=@CAPPK"); strSql.Append(" where pk_ZJB_WGD_Item=@pk_ZJB_WGD_Item"); SqlParameter[] parameters = { new SqlParameter("@wgdh", SqlDbType.VarChar, 50), new SqlParameter("@pch", SqlDbType.VarChar, 50), new SqlParameter("@ph", SqlDbType.VarChar, 50), new SqlParameter("@gg", SqlDbType.VarChar, 50), new SqlParameter("@wlh", SqlDbType.VarChar, 50), new SqlParameter("@wlmc", SqlDbType.VarChar, 50), new SqlParameter("@pcinfo", SqlDbType.VarChar, 150), new SqlParameter("@zyx1", SqlDbType.VarChar, 150), new SqlParameter("@zyx2", SqlDbType.VarChar, 150), new SqlParameter("@zyx3", SqlDbType.VarChar, 150), new SqlParameter("@zyx4", SqlDbType.VarChar, 150), new SqlParameter("@zyx5", SqlDbType.VarChar, 150), new SqlParameter("@ZJBstatus", SqlDbType.Int, 4), new SqlParameter("@CAPPK", SqlDbType.VarChar, 50), new SqlParameter("@pk_ZJB_WGD_Item", SqlDbType.Int, 4) }; parameters[0].Value = model.wgdh; parameters[1].Value = model.pch; parameters[2].Value = model.ph; parameters[3].Value = model.gg; parameters[4].Value = model.wlh; parameters[5].Value = model.wlmc; parameters[6].Value = model.pcinfo; parameters[7].Value = model.zyx1; parameters[8].Value = model.zyx2; parameters[9].Value = model.zyx3; parameters[10].Value = model.zyx4; parameters[11].Value = model.zyx5; parameters[12].Value = model.ZJBstatus; parameters[13].Value = model.CAPPK; parameters[14].Value = model.pk_ZJB_WGD_Item; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_ReZJB_ZKD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ReZJB_ZKD set "); strSql.Append("zkdh=@zkdh,"); strSql.Append("sck=@sck,"); strSql.Append("tck=@tck,"); strSql.Append("wlh=@wlh,"); strSql.Append("wlmc=@wlmc,"); strSql.Append("pch=@pch,"); strSql.Append("sx=@sx,"); strSql.Append("zldj=@zldj,"); strSql.Append("jhsl=@jhsl,"); strSql.Append("jhzl=@jhzl,"); strSql.Append("zjldw=@zjldw,"); strSql.Append("fjldw=@fjldw,"); strSql.Append("ph=@ph,"); strSql.Append("gg=@gg,"); strSql.Append("vfree0=@vfree0,"); strSql.Append("vfree1=@vfree1,"); strSql.Append("vfree2=@vfree2,"); strSql.Append("vfree3=@vfree3,"); strSql.Append("vfree4=@vfree4,"); strSql.Append("ZJBstatus=@ZJBstatus,"); strSql.Append("CAPPK=@CAPPK"); strSql.Append(" where pk_ZJB_ZKD=@pk_ZJB_ZKD"); SqlParameter[] parameters = { new SqlParameter("@zkdh", SqlDbType.VarChar, 50), new SqlParameter("@sck", SqlDbType.VarChar, 50), new SqlParameter("@tck", SqlDbType.VarChar, 50), new SqlParameter("@wlh", SqlDbType.VarChar, 50), new SqlParameter("@wlmc", SqlDbType.VarChar, 50), new SqlParameter("@pch", SqlDbType.VarChar, 50), new SqlParameter("@sx", SqlDbType.VarChar, 50), new SqlParameter("@zldj", SqlDbType.VarChar, 50), new SqlParameter("@jhsl", SqlDbType.Decimal, 9), new SqlParameter("@jhzl", SqlDbType.Decimal, 9), new SqlParameter("@zjldw", SqlDbType.VarChar, 50), new SqlParameter("@fjldw", SqlDbType.VarChar, 50), new SqlParameter("@ph", SqlDbType.VarChar, 50), new SqlParameter("@gg", SqlDbType.VarChar, 50), new SqlParameter("@vfree0", SqlDbType.VarChar, 50), new SqlParameter("@vfree1", SqlDbType.VarChar, 50), new SqlParameter("@vfree2", SqlDbType.VarChar, 50), new SqlParameter("@vfree3", SqlDbType.VarChar, 50), new SqlParameter("@vfree4", SqlDbType.VarChar, 50), new SqlParameter("@ZJBstatus", SqlDbType.Int, 4), new SqlParameter("@CAPPK", SqlDbType.VarChar, 50), new SqlParameter("@pk_ZJB_ZKD", SqlDbType.Int, 4) }; parameters[0].Value = model.zkdh; parameters[1].Value = model.sck; parameters[2].Value = model.tck; parameters[3].Value = model.wlh; parameters[4].Value = model.wlmc; parameters[5].Value = model.pch; parameters[6].Value = model.sx; parameters[7].Value = model.zldj; parameters[8].Value = model.jhsl; parameters[9].Value = model.jhzl; parameters[10].Value = model.zjldw; parameters[11].Value = model.fjldw; parameters[12].Value = model.ph; parameters[13].Value = model.gg; parameters[14].Value = model.vfree0; parameters[15].Value = model.vfree1; parameters[16].Value = model.vfree2; parameters[17].Value = model.vfree3; parameters[18].Value = model.vfree4; parameters[19].Value = model.ZJBstatus; parameters[20].Value = model.CAPPK; parameters[21].Value = model.pk_ZJB_ZKD; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_WMS_Bms_Tra_ZKD_Detail model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update WMS_Bms_Tra_ZKD_Detail set "); strSql.Append("WLH=:WLH,"); strSql.Append("WLMC=:WLMC,"); strSql.Append("PH=:PH,"); strSql.Append("GG=:GG,"); strSql.Append("CK=:CK,"); strSql.Append("HW=:HW,"); strSql.Append("ZL=:ZL,"); strSql.Append("CKOperator=:CKOperator,"); strSql.Append("CKTime=:CKTime,"); strSql.Append("YKOperator=:YKOperator,"); strSql.Append("YKTime=:YKTime,"); strSql.Append("YRKDH=:YRKDH,"); strSql.Append("YRKTime=:YRKTime,"); strSql.Append("YRKOperator=:YRKOperator,"); strSql.Append("YRKType=:YRKType,"); strSql.Append("vfree0=:vfree0,"); strSql.Append("vfree1=:vfree1,"); strSql.Append("vfree2=:vfree2,"); strSql.Append("vfree3=:vfree3,"); strSql.Append("vfree4=:vfree4"); strSql.Append(" where ZKDH=:ZKDH and CPH=:CPH and Barcode=:Barcode and PCH=:PCH and SX=:SX "); SqlParameter[] parameters = { new SqlParameter(":WLH", SqlDbType.VarChar, 30), new SqlParameter(":WLMC", SqlDbType.VarChar, 100), new SqlParameter(":PH", SqlDbType.VarChar, 30), new SqlParameter(":GG", SqlDbType.VarChar, 30), new SqlParameter(":CK", SqlDbType.VarChar, 30), new SqlParameter(":HW", SqlDbType.VarChar, 20), new SqlParameter(":ZL", SqlDbType.Decimal, 9), new SqlParameter(":CKOperator", SqlDbType.VarChar, 20), new SqlParameter(":CKTime", SqlDbType.DateTime), new SqlParameter(":YKOperator", SqlDbType.VarChar, 20), new SqlParameter(":YKTime", SqlDbType.DateTime), new SqlParameter(":YRKDH", SqlDbType.VarChar, 50), new SqlParameter(":YRKTime", SqlDbType.DateTime), new SqlParameter(":YRKOperator", SqlDbType.VarChar, 20), new SqlParameter(":YRKType", SqlDbType.VarChar, 10), new SqlParameter(":vfree0", SqlDbType.VarChar, 50), new SqlParameter(":vfree1", SqlDbType.VarChar, 50), new SqlParameter(":vfree2", SqlDbType.VarChar, 50), new SqlParameter(":vfree3", SqlDbType.VarChar, 50), new SqlParameter(":vfree4", SqlDbType.VarChar, 50), new SqlParameter(":ZKDH", SqlDbType.VarChar, 50), new SqlParameter(":CPH", SqlDbType.VarChar, 30), new SqlParameter(":Barcode", SqlDbType.VarChar, 20), new SqlParameter(":PCH", SqlDbType.VarChar, 20), new SqlParameter(":SX", SqlDbType.VarChar, 30) }; parameters[0].Value = model.WLH; parameters[1].Value = model.WLMC; parameters[2].Value = model.PH; parameters[3].Value = model.GG; parameters[4].Value = model.CK; parameters[5].Value = model.HW; parameters[6].Value = model.ZL; parameters[7].Value = model.CKOperator; parameters[8].Value = model.CKTime; parameters[9].Value = model.YKOperator; parameters[10].Value = model.YKTime; parameters[11].Value = model.YRKDH; parameters[12].Value = model.YRKTime; parameters[13].Value = model.YRKOperator; parameters[14].Value = model.YRKType; parameters[15].Value = model.vfree0; parameters[16].Value = model.vfree1; parameters[17].Value = model.vfree2; parameters[18].Value = model.vfree3; parameters[19].Value = model.vfree4; parameters[20].Value = model.ZKDH; parameters[21].Value = model.CPH; parameters[22].Value = model.Barcode; parameters[23].Value = model.PCH; parameters[24].Value = model.SX; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_ReZJB_WGD model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ReZJB_WGD set "); strSql.Append("wgdh=@wgdh,"); strSql.Append("pch=@pch,"); strSql.Append("ph=@ph,"); strSql.Append("gg=@gg,"); strSql.Append("bb=@bb,"); strSql.Append("wlh=@wlh,"); strSql.Append("wlmc=@wlmc,"); strSql.Append("fzdw=@fzdw,"); strSql.Append("zxbz=@zxbz,"); strSql.Append("zldj=@zldj,"); strSql.Append("SCX=@SCX,"); strSql.Append("pcinfo=@pcinfo,"); strSql.Append("zyx1=@zyx1,"); strSql.Append("zyx2=@zyx2,"); strSql.Append("zyx3=@zyx3,"); strSql.Append("zyx4=@zyx4,"); strSql.Append("zyx5=@zyx5,"); strSql.Append("gpmainmeasrate=@gpmainmeasrate,"); strSql.Append("ZJBstatus=@ZJBstatus,"); strSql.Append("CAPPK=@CAPPK"); strSql.Append(" where pk_ZJB_WGD=@pk_ZJB_WGD"); SqlParameter[] parameters = { new SqlParameter("@wgdh", SqlDbType.VarChar, 50), new SqlParameter("@pch", SqlDbType.VarChar, 50), new SqlParameter("@ph", SqlDbType.VarChar, 50), new SqlParameter("@gg", SqlDbType.VarChar, 50), new SqlParameter("@bb", SqlDbType.VarChar, 50), new SqlParameter("@wlh", SqlDbType.VarChar, 50), new SqlParameter("@wlmc", SqlDbType.VarChar, 50), new SqlParameter("@fzdw", SqlDbType.VarChar, 50), new SqlParameter("@zxbz", SqlDbType.VarChar, 50), new SqlParameter("@zldj", SqlDbType.VarChar, 50), new SqlParameter("@SCX", SqlDbType.VarChar, 50), new SqlParameter("@pcinfo", SqlDbType.VarChar, 150), new SqlParameter("@zyx1", SqlDbType.VarChar, 150), new SqlParameter("@zyx2", SqlDbType.VarChar, 150), new SqlParameter("@zyx3", SqlDbType.VarChar, 150), new SqlParameter("@zyx4", SqlDbType.VarChar, 150), new SqlParameter("@zyx5", SqlDbType.VarChar, 150), new SqlParameter("@gpmainmeasrate", SqlDbType.Decimal, 9), new SqlParameter("@ZJBstatus", SqlDbType.Int, 4), new SqlParameter("@CAPPK", SqlDbType.VarChar, 50), new SqlParameter("@pk_ZJB_WGD", SqlDbType.Int, 4) }; parameters[0].Value = model.wgdh; parameters[1].Value = model.pch; parameters[2].Value = model.ph; parameters[3].Value = model.gg; parameters[4].Value = model.bb; parameters[5].Value = model.wlh; parameters[6].Value = model.wlmc; parameters[7].Value = model.fzdw; parameters[8].Value = model.zxbz; parameters[9].Value = model.zldj; parameters[10].Value = model.SCX; parameters[11].Value = model.pcinfo; parameters[12].Value = model.zyx1; parameters[13].Value = model.zyx2; parameters[14].Value = model.zyx3; parameters[15].Value = model.zyx4; parameters[16].Value = model.zyx5; parameters[17].Value = model.gpmainmeasrate; parameters[18].Value = model.ZJBstatus; parameters[19].Value = model.CAPPK; parameters[20].Value = model.pk_ZJB_WGD; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_WMS_Bms_Tra_ZKD_Item model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into WMS_Bms_Tra_ZKD_Item("); strSql.Append("Barcode,WGDH,CK,HW,PCH,WLH,WLMC,SX,ZLDJ,PH,GG,BB,GH,ZL,BZ,RQ,RKType,RKRY,WeightRQ,CKCXH,ProduceData,Filed1,PCInfo,Filed2,ErrSeason,vfree0,vfree1,vfree2,vfree3,vfree4)"); strSql.Append(" values ("); strSql.Append(":Barcode,:WGDH,:CK,:HW,:PCH,:WLH,:WLMC,:SX,:ZLDJ,:PH,:GG,:BB,:GH,:ZL,:BZ,:RQ,:RKType,:RKRY,:WeightRQ,:CKCXH,:ProduceData,:Filed1,:PCInfo,:Filed2,:ErrSeason,:vfree0,:vfree1,:vfree2,:vfree3,:vfree4)"); SqlParameter[] parameters = { new SqlParameter(":Barcode", SqlDbType.VarChar, 20), new SqlParameter(":WGDH", SqlDbType.VarChar, 50), new SqlParameter(":CK", SqlDbType.VarChar, 30), new SqlParameter(":HW", SqlDbType.VarChar, 20), new SqlParameter(":PCH", SqlDbType.VarChar, 20), new SqlParameter(":WLH", SqlDbType.VarChar, 20), new SqlParameter(":WLMC", SqlDbType.VarChar, 100), new SqlParameter(":SX", SqlDbType.VarChar, 30), new SqlParameter(":ZLDJ", SqlDbType.VarChar, 10), new SqlParameter(":PH", SqlDbType.VarChar, 30), new SqlParameter(":GG", SqlDbType.VarChar, 30), new SqlParameter(":BB", SqlDbType.VarChar, 10), new SqlParameter(":GH", SqlDbType.Int, 4), new SqlParameter(":ZL", SqlDbType.Decimal, 9), new SqlParameter(":BZ", SqlDbType.VarChar, 50), new SqlParameter(":RQ", SqlDbType.DateTime), new SqlParameter(":RKType", SqlDbType.VarChar, 20), new SqlParameter(":RKRY", SqlDbType.VarChar, 20), new SqlParameter(":WeightRQ", SqlDbType.DateTime), new SqlParameter(":CKCXH", SqlDbType.Int, 4), new SqlParameter(":ProduceData", SqlDbType.VarChar, 20), new SqlParameter(":Filed1", SqlDbType.VarChar, 50), new SqlParameter(":PCInfo", SqlDbType.VarChar, 150), new SqlParameter(":Filed2", SqlDbType.VarChar, 50), new SqlParameter(":ErrSeason", SqlDbType.VarChar, 50), new SqlParameter(":vfree0", SqlDbType.VarChar, 50), new SqlParameter(":vfree1", SqlDbType.VarChar, 50), new SqlParameter(":vfree2", SqlDbType.VarChar, 50), new SqlParameter(":vfree3", SqlDbType.VarChar, 50), new SqlParameter(":vfree4", SqlDbType.VarChar, 50) }; parameters[0].Value = model.Barcode; parameters[1].Value = model.WGDH; parameters[2].Value = model.CK; parameters[3].Value = model.HW; parameters[4].Value = model.PCH; parameters[5].Value = model.WLH; parameters[6].Value = model.WLMC; parameters[7].Value = model.SX; parameters[8].Value = model.ZLDJ; parameters[9].Value = model.PH; parameters[10].Value = model.GG; parameters[11].Value = model.BB; parameters[12].Value = model.GH; parameters[13].Value = model.ZL; parameters[14].Value = model.BZ; parameters[15].Value = model.RQ; parameters[16].Value = model.RKType; parameters[17].Value = model.RKRY; parameters[18].Value = model.WeightRQ; parameters[19].Value = model.CKCXH; parameters[20].Value = model.ProduceData; parameters[21].Value = model.Filed1; parameters[22].Value = model.PCInfo; parameters[23].Value = model.Filed2; parameters[24].Value = model.ErrSeason; parameters[25].Value = model.vfree0; parameters[26].Value = model.vfree1; parameters[27].Value = model.vfree2; parameters[28].Value = model.vfree3; parameters[29].Value = model.vfree4; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_SeZJB_PDD_FINISHED model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SeZJB_PDD_FINISHED set "); strSql.Append("ysdh=@ysdh,"); strSql.Append("ck=@ck,"); strSql.Append("pdrq=@pdrq,"); strSql.Append("djzt=@djzt,"); strSql.Append("shuser=@shuser,"); strSql.Append("shdate=@shdate,"); strSql.Append("finished=@finished,"); strSql.Append("ZJBstatus=@ZJBstatus,"); strSql.Append("ts=@ts,"); strSql.Append("by1=@by1,"); strSql.Append("by2=@by2,"); strSql.Append("by3=@by3,"); strSql.Append("by4=@by4,"); strSql.Append("by5=@by5"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@ysdh", SqlDbType.VarChar, 50), new SqlParameter("@ck", SqlDbType.VarChar, 20), new SqlParameter("@pdrq", SqlDbType.DateTime), new SqlParameter("@djzt", SqlDbType.VarChar, 10), new SqlParameter("@shuser", SqlDbType.VarChar, 20), new SqlParameter("@shdate", SqlDbType.DateTime), new SqlParameter("@finished", SqlDbType.Int, 4), new SqlParameter("@ZJBstatus", SqlDbType.Int, 4), new SqlParameter("@ts", SqlDbType.DateTime), new SqlParameter("@by1", SqlDbType.VarChar, 100), new SqlParameter("@by2", SqlDbType.VarChar, 100), new SqlParameter("@by3", SqlDbType.VarChar, 100), new SqlParameter("@by4", SqlDbType.VarChar, 100), new SqlParameter("@by5", SqlDbType.VarChar, 100) }; parameters[0].Value = model.ysdh; parameters[1].Value = model.ck; parameters[2].Value = model.pdrq; parameters[3].Value = model.djzt; parameters[4].Value = model.shuser; parameters[5].Value = model.shdate; parameters[6].Value = model.finished; parameters[7].Value = model.ZJBstatus; parameters[8].Value = model.ts; parameters[9].Value = model.by1; parameters[10].Value = model.by2; parameters[11].Value = model.by3; parameters[12].Value = model.by4; parameters[13].Value = model.by5; int rows = DbHelper_SQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }