Beispiel #1
0
 public static int ThemBanAn(BanAn_DTO BanAn, string maNH)
 {
     Provider provider = new Provider();
     string sql = string.Format("insert into BanAn values ({0},'{1}','{2}',{3})", BanAn.MaKhuVuc, BanAn.LoaiBan, maNH, BanAn.TrangThai);
     SqlCommand cm = provider.CreateCommandStringSql(sql);
     return provider.ExecuteInsertUpdateDelete(cm);
 }
Beispiel #2
0
 public static int CapNhatBanAn(BanAn_DTO BanAn)
 {
     Provider provider = new Provider();
     string sql = string.Format("update BanAn set TrangThai={0} where MaBan={1}", BanAn.TrangThai, BanAn.MaBan);
     SqlCommand cm = provider.CreateCommandStringSql(sql);
     return provider.ExecuteInsertUpdateDelete(cm);
 }
Beispiel #3
0
 private List<BanAn_DTO> ConvertToList(DataTable dt)
 {
     List<BanAn_DTO> ls = new List<BanAn_DTO>();
     foreach (DataRow row in dt.Rows)
     {
         BanAn_DTO banan = new BanAn_DTO();
         banan.MaBan = (int)row.ItemArray[0];
         banan.MaKhuVuc = (int)row.ItemArray[1];
         banan.LoaiBan = (String)row.ItemArray[2];
         banan.MaNH = (String)row.ItemArray[3];
         banan.TrangThai = (int)row.ItemArray[4];
         ls.Add(banan);
     }
     return ls;
 }
Beispiel #4
0
 public static int ThemBanAn(BanAn_DTO BanAn, string maNH)
 {
     return BanAn_DAO.ThemBanAn(BanAn, maNH);
 }
Beispiel #5
0
 public static int CapNhatBanAn(BanAn_DTO BanAn)
 {
     return BanAn_DAO.CapNhatBanAn(BanAn);
 }