public static int CapNhatLoaiNhanVien(LoaiNhanVien_DTO loaiNV) { Provider provider = new Provider(); string sql = string.Format("update LoaiNV set TenLoai=N'{0}' where MaLoai='{1}'", loaiNV.TenLoaiNV, loaiNV.MaLoaiNV); SqlCommand cm = provider.CreateCommandStringSql(sql); return(provider.ExecuteInsertUpdateDelete(cm)); }
public static int ThemLoaiNV(LoaiNhanVien_DTO loaiNV) { Provider provider = new Provider(); string sql = string.Format("insert into LoaiNV(MaLoai,TenLoai,Luong) values ('{0}','{1}',{2})", loaiNV.MaLoaiNV, loaiNV.TenLoaiNV, loaiNV.Luong); SqlCommand cm = provider.CreateCommandStringSql(sql); return(provider.ExecuteInsertUpdateDelete(cm)); }
public void CapNhatLoaiNhanVien() { int flag = 0; int[] index = gridView_LoaiNV.GetSelectedRows(); if (index.Length > 0) { string tenloai = gridView_LoaiNV.GetRowCellValue(index[0], "TenLoai").ToString(); string maloai = gridView_LoaiNV.GetRowCellValue(index[0], "MaLoai").ToString(); if (maloai != null) { DTO.LoaiNhanVien_DTO loaiNV = new LoaiNhanVien_DTO(); loaiNV.MaLoaiNV = maloai; loaiNV.TenLoaiNV = tenloai; flag = LoaiNhanVien_BUS.CapNhatLoaiNhanVien(loaiNV); } } if (flag != 0) { DevExpress.XtraEditors.XtraMessageBox.Show("Cập nhật thành công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public static int CapNhatLoaiNhanVien(LoaiNhanVien_DTO loaiNV) { return(LoaiNhanVien_DAO.CapNhatLoaiNhanVien(loaiNV)); }
public static int ThemLoaiNV(LoaiNhanVien_DTO loaiNV) { return(LoaiNhanVien_DAO.ThemLoaiNV(loaiNV)); }