public DAEABCClass()
{
//
// TODO: 在此处添加构造函数逻辑
//
pDataAcess = Common.GetProjectDataAcess.GetDataAcess();
}
public DAECheckStockReport()
{
//
// TODO: 在此处添加构造函数逻辑
//
_da = Common.GetProjectDataAcess.GetDataAcess();
}
public DataTable GetMaterialInfos(string sItemCode)
{
string strSql = @"select MaterialName , UOMID from Material
where ItemCode = '" + sItemCode + "'";
Cnwit.Utility.DataAcess da = Common.GetProjectDataAcess.GetDataAcess();
return(da.GetDataTable(strSql));
}
public int ExistsItemCode(string sItemCode, string sWHID)
{
string strSql = @"select ItemCode from MaxMinMaterial
where ItemCode = '" + sItemCode + "' and WHID='" + sWHID + "'";
Cnwit.Utility.DataAcess da = Common.GetProjectDataAcess.GetDataAcess();
DataTable dt = da.GetDataTable(strSql);
return(dt.Rows.Count);
}
public DAEReturnEdit()
{
_da = Common.GetProjectDataAcess.GetDataAcess();
}
public DAEAdjustInEdit()
{
_da = Common.GetProjectDataAcess.GetDataAcess();
}
public DAETCStrategy_Edit()
{
_da = Common.GetProjectDataAcess.GetDataAcess();
strSql = string.Empty;
}