public DataTable LoadKhuVuc()
{
try
{
return(SelectTable.SelectQuery("select CUSTOMER_GROUP_ID , CUSTOMER_GROUP_Name , Description , Active from CUSTOMER_GROUP"));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LoadUser()
{
try
{
return(SelectTable.SelectQuery("select UserName from SYS_USER where Active = 1"));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LoadDVTDonGian()
{
try
{
return(SelectTable.SelectQuery("select UNIT_ID,UNIT_Name from UNIT where Active = 1"));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LoadKhoHangDonGian()
{
try
{
return(SelectTable.SelectQuery("select STOCK_ID,STOCK_Name from STOCK where Active = 1"));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LoadNhaCC()
{
try
{
return(SelectTable.SelectQuery("PROVIDER_GetList"));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LoadKHDonGian()
{
try
{
return(SelectTable.SelectQuery("select Customer_ID,CustomerName from CUSTOMER where Active = 1"));
}
catch (SqlException ex)
{
throw ex;
}
}
public DataTable LoadNVDonGian()
{
try
{
return(SelectTable.SelectQuery("select EMPLOYEE_ID,EMPLOYEE_Name from EMPLOYEE where Active = 1"));
}
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 LoadUser()
{
try
{
string sql = "select * from SYS_USER";
return(SelectTable.SelectQuery(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;
}
}
//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 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 GetHanhDong()
{
try
{
string sql = "select * from INVENTORY_ACTION";
return(SelectTable.SelectQuery(sql));
}
catch (SqlException ex)
{
throw ex;
}
}
