public DataTable LoadNVDonGian()
{
try
{
return(SelectTable.SelectQuery("select EMPLOYEE_ID,EMPLOYEE_Name from EMPLOYEE where Active = 1"));
}
catch (SqlException ex)
{
throw ex;
}
}
//Bộ Phận
public DataTable LoadBoPhan()
{
try
{
return(SelectTable.SelectProcedure("DEPARTMENT_GetList"));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LoadNV()
{
try
{
return(SelectTable.SelectProcedure("EMPLOYEE_GetList"));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LoadPermision()
{
try
{
string sql = "select * from K_Permision";
return(SelectTable.SelectQuery(sql));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LoadPhieuChi()
{
try
{
string sql = "KSP_PhieuChi_Load";
return(SelectTable.SelectProcedure(sql));
}
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 LoadUser()
{
try
{
string sql = "select * from SYS_USER";
return(SelectTable.SelectQuery(sql));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable GetHanhDong()
{
try
{
string sql = "select * from INVENTORY_ACTION";
return(SelectTable.SelectQuery(sql));
}
catch (SqlException ex)
{
throw ex;
}
}
//public static StringBuilder encrypt(String str)
//{
// StringBuilder sb = new StringBuilder();
// MD5 md5 = MD5.Create();
// byte[] inputBytes = System.Text.Encoding.UTF8.GetBytes(str);
// byte[] hash = md5.ComputeHash(inputBytes);
// for (int i = 0; i < hash.Length; i++)
// {
// sb.Append(hash[i].ToString("x"));
// }
// return sb;
//}
public DataTable GetUser(string UserName, string Password)
{
try
{
string sql = "select * from SYS_USER where username = N'" + UserName + "' and password = '******'";
return(SelectTable.SelectQuery(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 GetKV(string MaKV)
{
try
{
string sql = "select * from CUSTOMER_GROUP where CUSTOMER_GROUP_ID = '" + MaKV + "'";
return(SelectTable.SelectQuery(sql));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LayChungTuMH()
{
try
{
string sql = "STOCK_INWARD_GetList";
return(SelectTable.SelectProcedure(sql));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LoadPhanQuyen(string vaitro)
{
try
{
string sql = string.Format("select * from K_Permision_Detail where PER_ID ='{0}'", vaitro);
return(SelectTable.SelectQuery(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;
}
}
//Tồn kho
public DataTable LayTonKhoLookUp()
{
try
{
string sql = "INVENTORY_DETAIL_GetList";
return(SelectTable.SelectProcedure(sql));
}
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 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 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 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 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 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 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 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;
}
}
