public static int CapNhatLoaiMonAn(LoaiMonAn_DTO loaiMonAn) { Provider provider = new Provider(); string sql = string.Format("update LoaiMonAn set TenLoai=N'{0}' where MaLoai='{1}'", loaiMonAn.Tenloai, loaiMonAn.Maloai); SqlCommand cm = provider.CreateCommandStringSql(sql); return provider.ExecuteInsertUpdateDelete(cm); }
public static int ThemLoaiMonAn_XungDot(LoaiMonAn_DTO loaiMonAn) { Provider provider = new Provider(); string sql = string.Format("begin tran insert into LoaiMonAn values('{0}',N'{1}') ", loaiMonAn.Maloai, loaiMonAn.Tenloai); sql += " waitfor delay '0:0:20' Rollback Commit tran"; SqlCommand cm = provider.CreateCommandStringSql(sql); return provider.ExecuteInsertUpdateDelete(cm); }
public static int ThemLoaiMonAn_XD(LoaiMonAn_DTO loaiMonAn) { return LoaiMonAn_DAO.ThemLoaiMonAn_XungDot(loaiMonAn); }
public static int ThemLoaiMonAn(LoaiMonAn_DTO loaiMonAn) { return LoaiMonAn_DAO.ThemLoaiMonAn(loaiMonAn); }
public static int CapNhatLoaiMonAn(LoaiMonAn_DTO loaiMonAn) { return LoaiMonAn_DAO.CapNhatLoaiMonAn(loaiMonAn); }
private void CapNhatLoaiMonAn() { int flag = 0; int[] index= gridView_LoaiMonAn.GetSelectedRows(); if (index.Length > 0) { string tenloai = gridView_LoaiMonAn.GetRowCellValue(index[0], "TenLoai").ToString(); string maloai = gridView_LoaiMonAn.GetRowCellValue(index[0], "MaLoai").ToString(); if (maloai != null) { DTO.LoaiMonAn_DTO loaiMonAn = new LoaiMonAn_DTO(); loaiMonAn.Maloai = maloai; loaiMonAn.Tenloai = tenloai; flag= LoaiMonAn_BUS.CapNhatLoaiMonAn(loaiMonAn); } } if(flag!=0) DevExpress.XtraEditors.XtraMessageBox.Show("Cập nhật thành công","Thông Báo",MessageBoxButtons.OK,MessageBoxIcon.Information); }