public void Delete(string dbCode, int lgIndex, string vCode, string userCode, string userName)
{
string _SPDel = this.PrepareSPDel();
DALUtility du = new DALUtility(dbCode, lgIndex, _SPDel, vCode, userCode, userName);
du.Delete();
}
public void UnCheck(string dbCode, int lgIndex, string vCode, string userCode, string userName)
{
string _SPUnCheck = this.PrepareSPUnCheck();
DALUtility du = new DALUtility(dbCode, lgIndex, _SPUnCheck, vCode, userCode, userName);
du.UnCheck();
}
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));
}
