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