public DataTable GetnumChuyenTo(int idDepart, int idItem)
{
DataTable dt = null;
try
{
string sql = string.Format("select sum( Num) as Num from dbo.viNumDepartmentTo where Department_To_Pk={0} and Item_Pk={1}", idDepart, idItem);
COREBASE.COMMAND.SQL.AccessSQL _sql = new COREBASE.COMMAND.SQL.AccessSQL(confItem);
dt = _sql.GetDataBySQL(sql);
}
catch (Exception ex)
{
throw ex;
}
return(dt);
}