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