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