public string XuLyMaSP()
        {
            string MaSPGoc   = Sanpham_DAO.MaSPTutang();
            string kyTuDau   = MaSPGoc.Substring(0, 2);
            int    soCanTang = Convert.ToInt32(MaSPGoc.Substring(2)) + 1;

            string MaSP = "";

            if (soCanTang >= 0 && soCanTang < 10)
            {
                MaSP = kyTuDau + "00" + soCanTang;
            }
            if (soCanTang >= 10 && soCanTang < 100)
            {
                MaSP = kyTuDau + "0" + soCanTang;
            }
            if (soCanTang >= 100 && soCanTang < 1000)
            {
                MaSP = kyTuDau + soCanTang;
            }
            return(MaSP);
        }
 public static List <Sanpham_DTO> Locsptt(string Tukhoa)
 {
     return(Sanpham_DAO.LocSPTT(Tukhoa));
 }
 public static bool Checkxoasp(string kytu)
 {
     return(Sanpham_DAO.CheckXoaSP(kytu));
 }
        //public static List<Sanpham_DTO> Timkiemsp(string Tukhoa)
        //{
        //    return Sanpham_DAO.TimkiemSP(Tukhoa);
        //}

        public static DataTable Timkiemsp(string kytu)
        {
            return(Sanpham_DAO.TimkiemSP(kytu));
        }
 public static bool Xoasp(Sanpham_DTO XoaSP)
 {
     return(Sanpham_DAO.XoaSP(XoaSP));
 }
 public static bool Suasp(Sanpham_DTO SuaSP)
 {
     return(Sanpham_DAO.SuaSP(SuaSP));
 }
 public static bool Themsp(Sanpham_DTO ThemSP)
 {
     return(Sanpham_DAO.ThemSP(ThemSP));
 }
 public static DataTable GetNCC()
 {
     return(Sanpham_DAO.GetNCC());
 }
 /*public static List<Loaisp_DTO> LoadLSP()
  * {
  *  return Sanpham_DAO.LoadLoaiSanPham();
  * }*/
 public static DataTable GetTableLSP()
 {
     return(Sanpham_DAO.GetTableLSP());
 }
 //load nhan vien
 public static List <Sanpham_DTO> LoadSanpham()
 {
     return(Sanpham_DAO.LoadSanPham());
 }