partial void DeleteKT_CTPBCP(KT_CTPBCP instance);
partial void UpdateKT_CTPBCP(KT_CTPBCP instance);
private void gridView1_ValidateRow(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e) { try { GridView view = sender as GridView; ////validation //GridColumn thangCol = view.Columns["THANG"]; //GridColumn ma_ctCol = view.Columns["MA_CT"]; //string thang = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, thangCol), ""); //string ma_ct = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, ma_ctCol), ""); //if (thang.Trim().Length == 0 || ma_ct.Trim().Length == 0) //{ // e.Valid = false; // if (thang.Trim().Length == 0) // view.SetColumnError(thangCol, "Tháng không được rổng"); // if (ma_ct.Trim().Length == 0) // view.SetColumnError(ma_ctCol, "Mã chương trình không được rổng"); // return; //} _KTCTPBCPRepo = new KTCTPBCPRepo(); //Kiểm tra đây là dòng dữ liệu mới hay cũ, nếu là mới thì mình insert if (view.IsNewItemRow(e.RowHandle)) { //e.RowHandle trả về giá trị int là thứ tự của dòng hiện tại KT_CTPBCP obj = new KT_CTPBCP(); obj.THANG = Utils.CIntDef(view.GetRowCellValue(e.RowHandle, "THANG"), 0); obj.MA_CT = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MA_CT"), ""); obj.TEN_CT = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "TEN_CT"), ""); obj.SO_HD = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "SO_HD"), ""); obj.NOI_DUNG = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "NOI_DUNG"), ""); obj.SR_HOADON = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "SR_HOADON"), ""); obj.SO_HOADON = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "SO_HOADON"), ""); DateTime? temp = null; if (Utils.CDateDef(view.GetRowCellValue(e.RowHandle, "NGAY_HOADON"), DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(view.GetRowCellValue(e.RowHandle, "NGAY_HOADON"), DateTime.MinValue); obj.NGAY_HOADON = temp; obj.SO_CT = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "SO_CT"), ""); temp = null; if (Utils.CDateDef(view.GetRowCellValue(e.RowHandle, "NGAY_CT"), DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(view.GetRowCellValue(e.RowHandle, "NGAY_CT"), DateTime.MinValue); obj.NGAY_CT = temp; obj.DIEN_GIAI = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "DIEN_GIAI"), ""); obj.TK_NO = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "TK_NO"), ""); obj.DTPN_NO = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "DTPN_NO"), ""); obj.YTCP_NO = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "YTCP_NO"), ""); obj.MA_DM_NO = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MA_DM_NO"), ""); obj.LO_NHAP = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "LO_NHAP"), ""); obj.TK_CO = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "TK_CO"), ""); obj.DTPN_CO = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "DTPN_CO"), ""); obj.YTCP_CO = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "YTCP_CO"), ""); obj.MA_HH_XUAT = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MA_HH_XUAT"), ""); obj.LO_XUAT = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "LO_XUAT"), ""); obj.TEN_DM = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "TEN_DM"), ""); obj.DON_VI = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "DON_VI"), ""); obj.SL = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "SL"), 0); obj.DON_GIA = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "DON_GIA"), 0); obj.THANH_TIEN_VND = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "THANH_TIEN_VND"), 0); obj.TY_GIA = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "TY_GIA"), 0); obj.THANH_TIEN_USD = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "THANH_TIEN_USD"), 0); obj.MA_KH = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MA_KH"), ""); obj.TEN_KH = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "TEN_KH"), ""); obj.DANH_DAU = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "DANH_DAU"), ""); obj.TRANG_THAI = Utils.CIntDef(view.GetRowCellValue(e.RowHandle, "TRANG_THAI"), 0); obj.TIEN_THUE_USD = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "TIEN_THUE_USD"), 0); obj.TIEN_THUE_VND = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "TIEN_THUE_VND"), 0); obj.THUE_NK_USD = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "THUE_NK_USD"), 0); obj.THUE_NK_VND = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "THUE_NK_VND"), 0); _KTCTPBCPRepo.Create(obj); } //Cũ thì update else { int id = Utils.CIntDef(view.GetRowCellValue(gridView1.FocusedRowHandle, "ID"), 0); KT_CTPBCP obj = _KTCTPBCPRepo.GetById(id); if (obj != null) { obj.THANG = Utils.CIntDef(view.GetRowCellValue(e.RowHandle, "THANG"), 0); obj.MA_CT = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MA_CT"), ""); obj.TEN_CT = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "TEN_CT"), ""); obj.SO_HD = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "SO_HD"), ""); obj.NOI_DUNG = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "NOI_DUNG"), ""); obj.SR_HOADON = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "SR_HOADON"), ""); obj.SO_HOADON = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "SO_HOADON"), ""); DateTime? temp = null; if (Utils.CDateDef(view.GetRowCellValue(e.RowHandle, "NGAY_HOADON"), DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(view.GetRowCellValue(e.RowHandle, "NGAY_HOADON"), DateTime.MinValue); obj.NGAY_HOADON = temp; obj.SO_CT = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "SO_CT"), ""); temp = null; if (Utils.CDateDef(view.GetRowCellValue(e.RowHandle, "NGAY_CT"), DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(view.GetRowCellValue(e.RowHandle, "NGAY_CT"), DateTime.MinValue); obj.NGAY_CT = temp; obj.DIEN_GIAI = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "DIEN_GIAI"), ""); obj.TK_NO = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "TK_NO"), ""); obj.DTPN_NO = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "DTPN_NO"), ""); obj.YTCP_NO = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "YTCP_NO"), ""); obj.MA_DM_NO = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MA_DM_NO"), ""); obj.LO_NHAP = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "LO_NHAP"), ""); obj.TK_CO = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "TK_CO"), ""); obj.DTPN_CO = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "DTPN_CO"), ""); obj.YTCP_CO = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "YTCP_CO"), ""); obj.MA_HH_XUAT = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MA_HH_XUAT"), ""); obj.LO_XUAT = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "LO_XUAT"), ""); obj.TEN_DM = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "TEN_DM"), ""); obj.DON_VI = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "DON_VI"), ""); obj.SL = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "SL"), 0); obj.DON_GIA = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "DON_GIA"), 0); obj.THANH_TIEN_VND = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "THANH_TIEN_VND"), 0); obj.TY_GIA = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "TY_GIA"), 0); obj.THANH_TIEN_USD = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "THANH_TIEN_USD"), 0); obj.MA_KH = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MA_KH"), ""); obj.TEN_KH = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "TEN_KH"), ""); obj.DANH_DAU = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "DANH_DAU"), ""); obj.TRANG_THAI = Utils.CIntDef(view.GetRowCellValue(e.RowHandle, "TRANG_THAI"), 0); obj.TIEN_THUE_USD = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "TIEN_THUE_USD"), 0); obj.TIEN_THUE_VND = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "TIEN_THUE_VND"), 0); obj.THUE_NK_USD = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "THUE_NK_USD"), 0); obj.THUE_NK_VND = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "THUE_NK_VND"), 0); _KTCTPBCPRepo.Update(obj); } } Load_Data(); } catch (Exception ex) { e.Valid = false; MessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
partial void InsertKT_CTPBCP(KT_CTPBCP instance);
private void Save_Duplicate() { try { if (MessageBox.Show("Bạn có muốn copy dòng này thành dòng mới?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { _KTCTPBCPRepo = new KTCTPBCPRepo(); KT_CTPBCP obj = new KT_CTPBCP(); obj.THANG = Utils.CIntDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "THANG"), 0); obj.MA_CT = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MA_CT"), ""); obj.TEN_CT = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "TEN_CT"), ""); obj.SO_HD = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "SO_HD"), ""); obj.NOI_DUNG = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "NOI_DUNG"), ""); obj.SR_HOADON = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "SR_HOADON"), ""); obj.SO_HOADON = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "SO_HOADON"), ""); DateTime? temp = null; if (Utils.CDateDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "NGAY_HOADON"), DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "NGAY_HOADON"), DateTime.MinValue); obj.NGAY_HOADON = temp; obj.SO_CT = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "SO_CT"), ""); temp = null; if (Utils.CDateDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "NGAY_CT"), DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "NGAY_CT"), DateTime.MinValue); obj.NGAY_CT = temp; obj.DIEN_GIAI = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "DIEN_GIAI"), ""); obj.TK_NO = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "TK_NO"), ""); obj.DTPN_NO = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "DTPN_NO"), ""); obj.YTCP_NO = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "YTCP_NO"), ""); obj.MA_DM_NO = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MA_DM_NO"), ""); obj.LO_NHAP = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "LO_NHAP"), ""); obj.TK_CO = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "TK_CO"), ""); obj.DTPN_CO = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "DTPN_CO"), ""); obj.YTCP_CO = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "YTCP_CO"), ""); obj.MA_HH_XUAT = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MA_HH_XUAT"), ""); obj.LO_XUAT = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "LO_XUAT"), ""); obj.TEN_DM = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "TEN_DM"), ""); obj.DON_VI = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "DON_VI"), ""); obj.SL = Utils.CDblDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "SL"), 0); obj.DON_GIA = Utils.CDblDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "DON_GIA"), 0); obj.THANH_TIEN_VND = Utils.CDblDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "THANH_TIEN_VND"), 0); obj.TY_GIA = Utils.CDblDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "TY_GIA"), 0); obj.THANH_TIEN_USD = Utils.CDblDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "THANH_TIEN_USD"), 0); obj.MA_KH = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MA_KH"), ""); obj.TEN_KH = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "TEN_KH"), ""); obj.DANH_DAU = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "DANH_DAU"), ""); obj.TRANG_THAI = Utils.CIntDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "TRANG_THAI"), 0); obj.TIEN_THUE_USD = Utils.CDblDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "TIEN_THUE_USD"), 0); obj.TIEN_THUE_VND = Utils.CDblDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "TIEN_THUE_VND"), 0); obj.THUE_NK_USD = Utils.CDblDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "THUE_NK_USD"), 0); obj.THUE_NK_VND = Utils.CDblDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "THUE_NK_VND"), 0); _KTCTPBCPRepo.Create(obj); MessageBox.Show("Đã copy dòng này vào cuối bảng!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }