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