public DataTable LoadKhoHang()
{
try
{
return(SelectTable.SelectProcedure("STOCK_GetList"));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LoadNV()
{
try
{
return(SelectTable.SelectProcedure("EMPLOYEE_GetList"));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LoadKH()
{
try
{
return(SelectTable.SelectProcedure("CUSTOMER_GetList"));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LoadDVT()
{
try
{
return(SelectTable.SelectProcedure("UNIT_GetList"));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LoadHHLookupEdit()
{
try
{
return(SelectTable.SelectProcedure("PRODUCT_GetLookupByStock"));
}
catch (SqlException ex)
{
throw ex;
}
}
//Nhóm Hàng
public DataTable LoadNhomHang()
{
try
{
return(SelectTable.SelectProcedure("PRODUCT_GROUP_GetList"));
}
catch (SqlException ex)
{
throw ex;
}
}
//Bộ Phận
public DataTable LoadBoPhan()
{
try
{
return(SelectTable.SelectProcedure("DEPARTMENT_GetList"));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LoadCNChiTraNgay()
{
try
{
string sql = "KSP_CNPCTraNgay_Load";
return(SelectTable.SelectProcedure(sql));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LoadPhieuChi()
{
try
{
string sql = "KSP_PhieuChi_Load";
return(SelectTable.SelectProcedure(sql));
}
catch (SqlException ex)
{
throw ex;
}
}
//Tồn kho
public DataTable LayTonKhoLookUp()
{
try
{
string sql = "INVENTORY_DETAIL_GetList";
return(SelectTable.SelectProcedure(sql));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LoadTiGia()
{
try
{
string sql = "CURRENCY_GetList";
return(SelectTable.SelectProcedure(sql));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LayChungTuMH()
{
try
{
string sql = "STOCK_INWARD_GetList";
return(SelectTable.SelectProcedure(sql));
}
catch (SqlException ex)
{
throw ex;
}
}
//Bán Hàng
public DataTable ChitietChungTuBH()
{
try
{
string sql = "STOCK_OUTWARD_DETAIL_GetList";
return(SelectTable.SelectProcedure(sql));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable GetDV(string MaDV)
{
try
{
string sql = "UNIT_Get";
return(SelectTable.SelectProcedure(sql, new SqlParameter {
ParameterName = "@Unit_ID", Value = MaDV
}));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable GetTienTe(string maTienTe)
{
try
{
string sql = "CURRENCY_Get";
return(SelectTable.SelectProcedure(sql, new SqlParameter {
ParameterName = "@Currency_ID", Value = maTienTe
}));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable GetChitietChungTuMH(string MaMH)
{
try
{
string sql = "KSP_BuyProduct_Get";
return(SelectTable.SelectProcedure(sql, new SqlParameter {
ParameterName = "@MaMH", Value = MaMH
}));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable GetKho(string MaKho)
{
try
{
string sql = "STOCK_Get";
return(SelectTable.SelectProcedure(sql, new SqlParameter {
ParameterName = "@Stock_ID", Value = MaKho
}));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable GetBP(string MaBP)
{
try
{
string sql = "DEPARTMENT_Get";
return(SelectTable.SelectProcedure(sql, new SqlParameter {
ParameterName = "@Department_ID", Value = MaBP
}));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable GetHH(string MaHH)
{
try
{
string sql = "PRODUCT_Get";
return(SelectTable.SelectProcedure(sql, new SqlParameter {
ParameterName = "@Product_ID", Value = MaHH
}));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable GetNCC(string MaNCC)
{
try
{
string sql = "PROVIDER_Get";
return(SelectTable.SelectProcedure(sql, new SqlParameter {
ParameterName = "@Customer_ID", Value = MaNCC
}));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable GetNV(string MaNV)
{
try
{
string sql = "EMPLOYEE_Get";
return(SelectTable.SelectProcedure(sql, new SqlParameter {
ParameterName = "@Employee_ID", Value = MaNV
}));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LoadNhatKy()
{
try
{
string sql = "SYS_LOG_GetList_ByDate";
var shortDate = DateTime.Now.Date.AddHours(23).AddMinutes(59).AddSeconds(59);
return(SelectTable.SelectProcedure(sql,
new SqlParameter {
ParameterName = "@From", Value = DateTime.Now.Date
},
new SqlParameter {
ParameterName = "@To", Value = shortDate
}
));
}
catch (SqlException ex)
{
throw ex;
}
}
