/// <summary> /// 是否存在该记录 /// </summary> public bool Exists(string Barcode, string FYDH, int CKDH, string PCH, string WLH, DateTime WeightRQ, string ProduceData) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) 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; return(DbHelper_SQL.Exists(strSql.ToString(), parameters)); }
/// <summary> /// 是否存在该记录 /// </summary> public bool Exists(int pk_ZJB_FYD) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) 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; return(DbHelper_SQL.Exists(strSql.ToString(), parameters)); }
/// <summary> /// 是否存在该记录 /// </summary> public bool Exists(string Barcode) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from WMS_Bms_Tra_ZKD_Item"); strSql.Append(" where Barcode=:Barcode "); SqlParameter[] parameters = { new SqlParameter(":Barcode", SqlDbType.VarChar, 20) }; parameters[0].Value = Barcode; return(DbHelper_SQL.Exists(strSql.ToString(), parameters)); }
/// <summary> /// 是否存在该记录 /// </summary> public bool Exists(string ZKDH, string PCH, string SX, string CPH) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from WMS_Bms_Tra_ZKD_Total"); strSql.Append(" where ZKDH=:ZKDH and PCH=:PCH and SX=:SX and CPH=:CPH "); 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) }; parameters[0].Value = ZKDH; parameters[1].Value = PCH; parameters[2].Value = SX; parameters[3].Value = CPH; return(DbHelper_SQL.Exists(strSql.ToString(), parameters)); }
/// <summary> /// 是否存在该记录 /// </summary> public bool Exists(string ZKDH, string SCK, string TCK, string WLH) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) 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; return(DbHelper_SQL.Exists(strSql.ToString(), parameters)); }
/// <summary> /// 是否存在该记录 /// </summary> public bool Exists(string WGDH, string PCH, string PH, string GG, string SCX, string WLH) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) 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; return(DbHelper_SQL.Exists(strSql.ToString(), parameters)); }
/// <summary> /// 是否存在该记录 /// </summary> public bool Exists(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("select count(1) 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; return(DbHelper_SQL.Exists(strSql.ToString(), parameters)); }