public override bool Exists(string dbCode, int lgIndex, string vCode) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from B_Material_LensClass_Usage with (nolock)"); strSql.Append(" where KeyCode=@KeyCode "); SqlParameter[] parameters = { new SqlParameter("@KeyCode", SqlDbType.VarChar, 25) }; parameters[0].Value = vCode; DALUtility du = new DALUtility(); return(du.Exists(dbCode, strSql.ToString(), parameters)); }
public override bool Exists(string dbCode, int lgIndex, string vCode) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from Sale_PriceContract_Lens_ProCost with (nolock)"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 25) }; parameters[0].Value = vCode; DALUtility du = new DALUtility(); return(du.Exists(dbCode, strSql.ToString(), parameters)); }
public override bool Exists(string dbCode, int lgIndex, string vCode) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from B_Customer_Main with (nolock)"); strSql.Append(" where MainCusCode=@MainCusCode "); SqlParameter[] parameters = { new SqlParameter("@MainCusCode", SqlDbType.NVarChar, 50) }; parameters[0].Value = vCode; DALUtility du = new DALUtility(); return(du.Exists(dbCode, strSql.ToString(), parameters)); }
public bool Exists(string dbCode, int lgIndex, string table, string vCode) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from " + table + " with (nolock)"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 25) }; parameters[0].Value = vCode; DALUtility du = new DALUtility(); return(du.Exists(dbCode, strSql.ToString(), parameters)); }
public override bool Exists(string dbCode, int lgIndex, string vCode) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from Pur_PriceContract_SpGroup with (nolock)"); strSql.Append(" where GpCode=@GpCode "); SqlParameter[] parameters = { new SqlParameter("@GpCode", SqlDbType.VarChar, 10) }; parameters[0].Value = vCode; DALUtility du = new DALUtility(); return(du.Exists(dbCode, strSql.ToString(), parameters)); }
public override bool Exists(string dbCode, int lgIndex, string vCode) { StringBuilder strSql = new StringBuilder(); strSql.Append("select count(1) from Ware_Stocks_Base_Lens A1 with (nolock)"); strSql.Append(" where A1.WhCode+A1.LensCode+A1.F_LR=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 25) }; parameters[0].Value = vCode; DALUtility du = new DALUtility(); return(du.Exists(dbCode, strSql.ToString(), parameters)); }