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; } }