private void Load_Data() { try { _KTDMTSCDRepo = new KTDMTSCDRepo(); var list = _KTDMTSCDRepo.GetAll(); int id = Utils.CIntDef(cboMaTS.SelectedValue, 0); if (id > 0) list = _KTDMTSCDRepo.GetAll(id); gridControl1.DataSource = list; } catch (Exception) { } }
private void Load_Data() { try { _KTDMTSCDRepo = new KTDMTSCDRepo(); gridData.DataSource = _KTDMTSCDRepo.GetAll(); //_db = new dbVstoreAppDataContext(Const.builder.ConnectionString); //gridData.DataSource = null; //gridData.DataSource = _db.KT_DMHHs; //gridData.RefreshDataSource(); //gridView1.RefreshData(); } catch (Exception) { } }
private void LoadDMTSCD() { _KTDMTSCDRepo = new KTDMTSCDRepo(); var list = _KTDMTSCDRepo.GetAll(); cboMaTS.DataSource = list; cboMaTS.DisplayMember = "MA_TS"; cboMaTS.ValueMember = "ID"; cboMaTS.DropDownColumns = "MA_TS,TEN_TS"; cboMaTS.SelectedIndex = -1; _KTDMTSCDRepo = new KTDMTSCDRepo(); var list2 = _KTDMTSCDRepo.GetAll(); cboMaTSMe.DataSource = list2; cboMaTSMe.DisplayMember = "MA_TS"; cboMaTSMe.ValueMember = "ID"; cboMaTSMe.DropDownColumns = "MA_TS,TEN_TS"; cboMaTSMe.SelectedIndex = -1; }
private void cboMaTSMe_SelectedIndexChanged(object sender, EventArgs e) { _KTDMTSCDRepo = new KTDMTSCDRepo(); var item = _KTDMTSCDRepo.GetById(Utils.CIntDef(cboMaTSMe.SelectedValue, 0)); if (item != null) txtTenTSMe.Text = item.TEN_TS; }
private void cboMaTS_SelectedIndexChanged(object sender, EventArgs e) { Load_Data(); _KTDMTSCDRepo = new KTDMTSCDRepo(); var item = _KTDMTSCDRepo.GetById(Utils.CIntDef(cboMaTS.SelectedValue, 0)); if (item != null) { txtTenTS.Text = item.TEN_TS; txtSoluong.Text = Utils.CStrDef(item.SO_LUONG, ""); txtDVT.Text = item.DVT; //txtDongiaVND.Text = item.d //txtThanhtienVND.Text = item. txtTygia.Text = Utils.CStrDef(item.TY_GIA, ""); //txtDongiaUSD.Text = item //txtThanhtienUSD.Text = item cboCokhauhao.Text = item.CO_KH; dtpNgaymua.Value = new DateTime(0); if (Utils.CDateDef(item.NGAY_MUA, DateTime.MinValue) != DateTime.MinValue) dtpNgaymua.Value = Utils.CDateDef(item.NGAY_MUA, DateTime.MinValue); dtpNgaytrichKH.Value = new DateTime(0); if (Utils.CDateDef(item.NGAY_TRICH_KH, DateTime.MinValue) != DateTime.MinValue) dtpNgaytrichKH.Value = Utils.CDateDef(item.NGAY_TRICH_KH, DateTime.MinValue); cboTKtaisan.Text = item.TK_TS; cboTKchiphi.Text = item.TK_CP; cboTKhaomon.Text = item.TK_HM; txtDoituongsudung.Text = item.DT_SUDUNG; txtNguyengiaVND.Text = Utils.CStrDef(item.NGUYEN_GIA, ""); //txtNguyengiaUSD.Text = Utils.CStrDef(item.NGUYEN_GIA, ""); txtThoigianKH.Text = Utils.CStrDef(item.THOI_GIAN_KH, ""); txtKH1thangVND.Text = Utils.CStrDef(item.KH_1_THANG, ""); //txtKH1thangUSD.Text = Utils.CStrDef(item.KH_1_THANG, ""); txtLuykeKHDaunamVND.Text = Utils.CStrDef(item.LK_KH_DAUNAM, ""); //txtLuykeKHDaunamUSD.Text = Utils.CStrDef(item.LK_KH_DAUNAM, ""); txtGiatriCLDaunamVND.Text = Utils.CStrDef(item.GT_CL_DAUNAM, ""); cboDTPNNo.Text = item.MA_DTPN_NO; cboDTPNNo_SelectedIndexChanged(null, null); cboDTPNCo.Text = item.MA_DTPN_CO; cboDTPNCo_SelectedIndexChanged(null, null); cboYTCPNo.Text = item.MA_YTCP_NO; cboYTCPNo_SelectedIndexChanged(null, null); cboCongtrinh.Text = item.MA_CT; cboCongtrinh_SelectedIndexChanged(null, null); //thông tin khác txtkyhieu.Text = item.KY_HIEU; txtModel.Text = item.MODEL; txtNuocsanxuat.Text = item.NUOC_SX; txtNamsanxuat.Text = Utils.CStrDef(item.NAM_SX, ""); txtQuycach.Text = item.QUY_CACH; cboManhom.Text = item.MA_NHOM; txtTenNhom.Text = item.TEN_NHOM; } }
private void btnCapnhat_Click(object sender, EventArgs e) { if (cboMaTS.Text.Trim().Length == 0) { MessageBox.Show("Mã TS không được rỗng!","Thông báo"); return; } _KTDMTSCDRepo = new KTDMTSCDRepo(); var item = _KTDMTSCDRepo.GetById(Utils.CIntDef(cboMaTS.SelectedValue, 0)); if (item != null) { #region item.TEN_TS = txtTenTS.Text; item.SO_LUONG = Utils.CDblDef(txtSoluong.Text, 0); item.DVT = txtDVT.Text; //txtDongiaVND.Text = item.d //txtThanhtienVND.Text = item. item.TY_GIA = Utils.CDblDef(txtTygia.Text, 0); //txtDongiaUSD.Text = item //txtThanhtienUSD.Text = item cboCokhauhao.Text = item.CO_KH; DateTime? temp = null; if (Utils.CDateDef(dtpNgaymua.Value, DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(dtpNgaymua.Value, DateTime.MinValue); item.NGAY_MUA = temp; temp = null; if (Utils.CDateDef(dtpNgaytrichKH.Value, DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(dtpNgaytrichKH.Value, DateTime.MinValue); item.NGAY_TRICH_KH = temp; item.TK_TS = cboTKtaisan.Text; item.TK_CP = cboTKchiphi.Text; item.TK_HM = cboTKhaomon.Text; item.DT_SUDUNG = txtDoituongsudung.Text; item.NGUYEN_GIA = Utils.CDblDef(txtNguyengiaVND.Text, 0); //txtNguyengiaUSD.Text = Utils.CStrDef(item.NGUYEN_GIA, ""); item.THOI_GIAN_KH = Utils.CDblDef(txtThoigianKH.Text, 0); item.KH_1_THANG = Utils.CDblDef(txtKH1thangVND.Text, 0); //txtKH1thangUSD.Text = Utils.CStrDef(item.KH_1_THANG, ""); item.LK_KH_DAUNAM = Utils.CDblDef(txtLuykeKHDaunamVND.Text, 0); //txtLuykeKHDaunamUSD.Text = Utils.CStrDef(item.LK_KH_DAUNAM, ""); item.GT_CL_DAUNAM = Utils.CDblDef(txtGiatriCLDaunamVND.Text, 0); item.MA_DTPN_NO = cboDTPNNo.Text; item.MA_DTPN_CO = cboDTPNCo.Text; item.MA_YTCP_NO = cboYTCPNo.Text; item.MA_CT = cboCongtrinh.Text; //thông tin khác item.KY_HIEU = txtkyhieu.Text; item.MODEL = txtModel.Text; item.NUOC_SX = txtNuocsanxuat.Text; item.NAM_SX = Utils.CDblDef(txtNamsanxuat.Text, 0); item.QUY_CACH = txtQuycach.Text; item.MA_NHOM = cboManhom.Text; item.TEN_NHOM = txtTenNhom.Text; _KTDMTSCDRepo.Update(item); #endregion } else { #region item = new KT_DMTSCD(); item.MA_TS = cboMaTS.Text; item.TEN_TS = txtTenTS.Text; item.SO_LUONG = Utils.CDblDef(txtSoluong.Text, 0); item.DVT = txtDVT.Text; //txtDongiaVND.Text = item.d //txtThanhtienVND.Text = item. item.TY_GIA = Utils.CDblDef(txtTygia.Text, 0); //txtDongiaUSD.Text = item //txtThanhtienUSD.Text = item cboCokhauhao.Text = item.CO_KH; DateTime? temp = null; if (Utils.CDateDef(dtpNgaymua.Value, DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(dtpNgaymua.Value, DateTime.MinValue); item.NGAY_MUA = temp; temp = null; if (Utils.CDateDef(dtpNgaytrichKH.Value, DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(dtpNgaytrichKH.Value, DateTime.MinValue); item.NGAY_TRICH_KH = temp; item.TK_TS = cboTKtaisan.Text; item.TK_CP = cboTKchiphi.Text; item.TK_HM = cboTKhaomon.Text; item.DT_SUDUNG = txtDoituongsudung.Text; item.NGUYEN_GIA = Utils.CDblDef(txtNguyengiaVND.Text, 0); //txtNguyengiaUSD.Text = Utils.CStrDef(item.NGUYEN_GIA, ""); item.THOI_GIAN_KH = Utils.CDblDef(txtThoigianKH.Text, 0); item.KH_1_THANG = Utils.CDblDef(txtKH1thangVND.Text, 0); //txtKH1thangUSD.Text = Utils.CStrDef(item.KH_1_THANG, ""); item.LK_KH_DAUNAM = Utils.CDblDef(txtLuykeKHDaunamVND.Text, 0); //txtLuykeKHDaunamUSD.Text = Utils.CStrDef(item.LK_KH_DAUNAM, ""); item.GT_CL_DAUNAM = Utils.CDblDef(txtGiatriCLDaunamVND.Text, 0); item.MA_DTPN_NO = cboDTPNNo.Text; item.MA_DTPN_CO = cboDTPNCo.Text; item.MA_YTCP_NO = cboYTCPNo.Text; item.MA_CT = cboCongtrinh.Text; //thông tin khác item.KY_HIEU = txtkyhieu.Text; item.MODEL = txtModel.Text; item.NUOC_SX = txtNuocsanxuat.Text; item.NAM_SX = Utils.CDblDef(txtNamsanxuat.Text, 0); item.QUY_CACH = txtQuycach.Text; item.MA_NHOM = cboManhom.Text; item.TEN_NHOM = txtTenNhom.Text; _KTDMTSCDRepo.Create(item); LoadDMTSCD(); cboMaTS.SelectedValue = item.ID; cboMaTS_SelectedIndexChanged(null, null); LoadMaTSCuoi(); #endregion } MessageBox.Show("Cập nhật thành công!", "Thông báo"); }
private void Save_Data(bool msg) { try { _KTDMTSCDRepo = new KTDMTSCDRepo(); int i = 0; foreach (int pos in _listUpdate) { int id = Utils.CIntDef(gridView1.GetRowCellValue(pos, "ID"), 0); KT_DMTSCD obj = _KTDMTSCDRepo.GetById(id); if (obj != null) { obj.MA_TS = Utils.CStrDef(gridView1.GetRowCellValue(pos, "MA_TS"), ""); obj.TEN_TS = Utils.CStrDef(gridView1.GetRowCellValue(pos, "TEN_TS"), ""); obj.SO_LUONG = Utils.CDblDef(gridView1.GetRowCellValue(pos, "SO_LUONG"), 0); obj.DVT = Utils.CStrDef(gridView1.GetRowCellValue(pos, "DVT"), ""); obj.CO_KH = Utils.CStrDef(gridView1.GetRowCellValue(pos, "CO_KH"), ""); obj.TK_TS = Utils.CStrDef(gridView1.GetRowCellValue(pos, "TK_TS"), ""); obj.TK_CP = Utils.CStrDef(gridView1.GetRowCellValue(pos, "TK_CP"), ""); obj.TK_HM = Utils.CStrDef(gridView1.GetRowCellValue(pos, "TK_HM"), ""); obj.DT_SUDUNG = Utils.CStrDef(gridView1.GetRowCellValue(pos, "DT_SUDUNG"), ""); obj.NGUYEN_GIA = Utils.CDblDef(gridView1.GetRowCellValue(pos, "NGUYEN_GIA"), 0); DateTime? temp = null; if (Utils.CDateDef(gridView1.GetRowCellValue(pos, "NGAY_MUA"), DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(gridView1.GetRowCellValue(pos, "NGAY_MUA"), DateTime.MinValue); obj.NGAY_MUA = temp; temp = null; if (Utils.CDateDef(gridView1.GetRowCellValue(pos, "NGAY_BAN"), DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(gridView1.GetRowCellValue(pos, "NGAY_BAN"), DateTime.MinValue); obj.NGAY_BAN = temp; temp = null; if (Utils.CDateDef(gridView1.GetRowCellValue(pos, "NGAY_TRICH_KH"), DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(gridView1.GetRowCellValue(pos, "NGAY_TRICH_KH"), DateTime.MinValue); obj.NGAY_TRICH_KH = temp; obj.THOI_GIAN_KH = Utils.CDblDef(gridView1.GetRowCellValue(pos, "THOI_GIAN_KH"), 0); obj.KH_1_THANG = Utils.CDblDef(gridView1.GetRowCellValue(pos, "KH_1_THANG"), 0); obj.LK_KH_DAUNAM = Utils.CDblDef(gridView1.GetRowCellValue(pos, "LK_KH_DAUNAM"), 0); obj.GT_CL_DAUNAM = Utils.CDblDef(gridView1.GetRowCellValue(pos, "GT_CL_DAUNAM"), 0); obj.MA_DTPN_NO = Utils.CStrDef(gridView1.GetRowCellValue(pos, "MA_DTPN_NO"), ""); obj.MA_DTPN_CO = Utils.CStrDef(gridView1.GetRowCellValue(pos, "MA_DTPN_CO"), ""); obj.MA_CT = Utils.CStrDef(gridView1.GetRowCellValue(pos, "MA_CT"), ""); obj.MA_YTCP_NO = Utils.CStrDef(gridView1.GetRowCellValue(pos, "MA_YTCP_NO"), ""); obj.MA_NHOM = Utils.CStrDef(gridView1.GetRowCellValue(pos, "MA_NHOM"), ""); obj.TEN_NHOM = Utils.CStrDef(gridView1.GetRowCellValue(pos, "TEN_NHOM"), ""); obj.KY_HIEU = Utils.CStrDef(gridView1.GetRowCellValue(pos, "KY_HIEU"), ""); obj.NAM_SX = Utils.CDblDef(gridView1.GetRowCellValue(pos, "NAM_SX"), 0); obj.MODEL = Utils.CStrDef(gridView1.GetRowCellValue(pos, "MODEL"), ""); obj.QUY_CACH = Utils.CStrDef(gridView1.GetRowCellValue(pos, "QUY_CACH"), ""); obj.NUOC_SX = Utils.CStrDef(gridView1.GetRowCellValue(pos, "NUOC_SX"), ""); obj.NGUON_VON = Utils.CStrDef(gridView1.GetRowCellValue(pos, "NGUON_VON"), ""); obj.DANH_DAU = Utils.CStrDef(gridView1.GetRowCellValue(pos, "DANH_DAU"), ""); obj.TRANG_THAI = Utils.CIntDef(gridView1.GetRowCellValue(pos, "TRANG_THAI"), 0); _KTDMTSCDRepo.Update(obj); i++; } } _listUpdate = new List<int>(); //if (i > 0 && msg) //{ // MessageBox.Show("Lưu thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); //} } catch (Exception ex) { MessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void gridView1_ValidateRow(object sender, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e) { try { GridView view = sender as GridView; //validation GridColumn ma_tsCol = view.Columns["MA_TS"]; //GridColumn ma_ctCol = view.Columns["MA_CT"]; string ma_ts = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, ma_tsCol), ""); //string ma_ct = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, ma_ctCol), ""); if (ma_ts.Trim().Length == 0) { e.Valid = false; if (ma_ts.Trim().Length == 0) view.SetColumnError(ma_tsCol, "Mã tài sản 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; } _KTDMTSCDRepo = new KTDMTSCDRepo(); //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_DMTSCD obj = new KT_DMTSCD(); obj.MA_TS = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MA_TS"), ""); obj.TEN_TS = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "TEN_TS"), ""); obj.SO_LUONG = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "SO_LUONG"), 0); obj.DVT = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "DVT"), ""); obj.CO_KH = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "CO_KH"), ""); obj.TK_TS = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "TK_TS"), ""); obj.TK_CP = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "TK_CP"), ""); obj.TK_HM = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "TK_HM"), ""); obj.DT_SUDUNG = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "DT_SUDUNG"), ""); obj.NGUYEN_GIA = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "NGUYEN_GIA"), 0); DateTime? temp = null; if (Utils.CDateDef(view.GetRowCellValue(e.RowHandle, "NGAY_MUA"), DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(view.GetRowCellValue(e.RowHandle, "NGAY_MUA"), DateTime.MinValue); obj.NGAY_MUA = temp; temp = null; if (Utils.CDateDef(view.GetRowCellValue(e.RowHandle, "NGAY_BAN"), DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(view.GetRowCellValue(e.RowHandle, "NGAY_BAN"), DateTime.MinValue); obj.NGAY_BAN = temp; temp = null; if (Utils.CDateDef(view.GetRowCellValue(e.RowHandle, "NGAY_TRICH_KH"), DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(view.GetRowCellValue(e.RowHandle, "NGAY_TRICH_KH"), DateTime.MinValue); obj.NGAY_TRICH_KH = temp; obj.THOI_GIAN_KH = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "THOI_GIAN_KH"), 0); obj.KH_1_THANG = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "KH_1_THANG"), 0); obj.LK_KH_DAUNAM = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "LK_KH_DAUNAM"), 0); obj.GT_CL_DAUNAM = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "GT_CL_DAUNAM"), 0); obj.MA_DTPN_NO = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MA_DTPN_NO"), ""); obj.MA_DTPN_CO = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MA_DTPN_CO"), ""); obj.MA_CT = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MA_CT"), ""); obj.MA_YTCP_NO = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MA_YTCP_NO"), ""); obj.MA_NHOM = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MA_NHOM"), ""); obj.TEN_NHOM = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "TEN_NHOM"), ""); obj.KY_HIEU = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "KY_HIEU"), ""); obj.NAM_SX = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "NAM_SX"), 0); obj.MODEL = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MODEL"), ""); obj.QUY_CACH = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "QUY_CACH"), ""); obj.NUOC_SX = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "NUOC_SX"), ""); obj.NGUON_VON = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "NGUON_VON"), ""); obj.DANH_DAU = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "DANH_DAU"), ""); obj.TRANG_THAI = Utils.CIntDef(view.GetRowCellValue(e.RowHandle, "TRANG_THAI"), 0); _KTDMTSCDRepo.Create(obj); } //Cũ thì update else { int id = Utils.CIntDef(view.GetRowCellValue(gridView1.FocusedRowHandle, "ID"), 0); KT_DMTSCD obj = _KTDMTSCDRepo.GetById(id); if (obj != null) { obj.MA_TS = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MA_TS"), ""); obj.TEN_TS = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "TEN_TS"), ""); obj.SO_LUONG = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "SO_LUONG"), 0); obj.DVT = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "DVT"), ""); obj.CO_KH = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "CO_KH"), ""); obj.TK_TS = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "TK_TS"), ""); obj.TK_CP = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "TK_CP"), ""); obj.TK_HM = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "TK_HM"), ""); obj.DT_SUDUNG = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "DT_SUDUNG"), ""); obj.NGUYEN_GIA = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "NGUYEN_GIA"), 0); DateTime? temp = null; if (Utils.CDateDef(view.GetRowCellValue(e.RowHandle, "NGAY_MUA"), DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(view.GetRowCellValue(e.RowHandle, "NGAY_MUA"), DateTime.MinValue); obj.NGAY_MUA = temp; temp = null; if (Utils.CDateDef(view.GetRowCellValue(e.RowHandle, "NGAY_BAN"), DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(view.GetRowCellValue(e.RowHandle, "NGAY_BAN"), DateTime.MinValue); obj.NGAY_BAN = temp; temp = null; if (Utils.CDateDef(view.GetRowCellValue(e.RowHandle, "NGAY_TRICH_KH"), DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(view.GetRowCellValue(e.RowHandle, "NGAY_TRICH_KH"), DateTime.MinValue); obj.NGAY_TRICH_KH = temp; obj.THOI_GIAN_KH = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "THOI_GIAN_KH"), 0); obj.KH_1_THANG = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "KH_1_THANG"), 0); obj.LK_KH_DAUNAM = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "LK_KH_DAUNAM"), 0); obj.GT_CL_DAUNAM = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "GT_CL_DAUNAM"), 0); obj.MA_DTPN_NO = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MA_DTPN_NO"), ""); obj.MA_DTPN_CO = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MA_DTPN_CO"), ""); obj.MA_CT = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MA_CT"), ""); obj.MA_YTCP_NO = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MA_YTCP_NO"), ""); obj.MA_NHOM = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MA_NHOM"), ""); obj.TEN_NHOM = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "TEN_NHOM"), ""); obj.KY_HIEU = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "KY_HIEU"), ""); obj.NAM_SX = Utils.CDblDef(view.GetRowCellValue(e.RowHandle, "NAM_SX"), 0); obj.MODEL = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "MODEL"), ""); obj.QUY_CACH = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "QUY_CACH"), ""); obj.NUOC_SX = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "NUOC_SX"), ""); obj.NGUON_VON = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "NGUON_VON"), ""); obj.DANH_DAU = Utils.CStrDef(view.GetRowCellValue(e.RowHandle, "DANH_DAU"), ""); obj.TRANG_THAI = Utils.CIntDef(view.GetRowCellValue(e.RowHandle, "TRANG_THAI"), 0); _KTDMTSCDRepo.Update(obj); } } Load_Data(); } catch (Exception ex) { e.Valid = false; MessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Remove_Data() { try { //if (_listUpdate.Count > 0) //{ // MessageBox.Show("Hãy thực hiện lưu trước khi xóa!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); // return; //} Save_Data(false); int id = Utils.CIntDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "ID"), 0); _KTDMTSCDRepo = new KTDMTSCDRepo(); _KTDMTSCDRepo.Remove(id); //MessageBox.Show("Xóa dòng ID:" + Id + " thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); Load_Data(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
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) { _KTDMTSCDRepo = new KTDMTSCDRepo(); KT_DMTSCD obj = new KT_DMTSCD(); obj.MA_TS = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MA_TS"), ""); obj.TEN_TS = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "TEN_TS"), ""); obj.SO_LUONG = Utils.CDblDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "SO_LUONG"), 0); obj.DVT = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "DVT"), ""); obj.CO_KH = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "CO_KH"), ""); obj.TK_TS = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "TK_TS"), ""); obj.TK_CP = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "TK_CP"), ""); obj.TK_HM = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "TK_HM"), ""); obj.DT_SUDUNG = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "DT_SUDUNG"), ""); obj.NGUYEN_GIA = Utils.CDblDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "NGUYEN_GIA"), 0); DateTime? temp = null; if (Utils.CDateDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "NGAY_MUA"), DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "NGAY_MUA"), DateTime.MinValue); obj.NGAY_MUA = temp; temp = null; if (Utils.CDateDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "NGAY_BAN"), DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "NGAY_BAN"), DateTime.MinValue); obj.NGAY_BAN = temp; temp = null; if (Utils.CDateDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "NGAY_TRICH_KH"), DateTime.MinValue) != DateTime.MinValue) temp = Utils.CDateDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "NGAY_TRICH_KH"), DateTime.MinValue); obj.NGAY_TRICH_KH = temp; obj.THOI_GIAN_KH = Utils.CDblDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "THOI_GIAN_KH"), 0); obj.KH_1_THANG = Utils.CDblDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "KH_1_THANG"), 0); obj.LK_KH_DAUNAM = Utils.CDblDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "LK_KH_DAUNAM"), 0); obj.GT_CL_DAUNAM = Utils.CDblDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "GT_CL_DAUNAM"), 0); obj.MA_DTPN_NO = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MA_DTPN_NO"), ""); obj.MA_DTPN_CO = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MA_DTPN_CO"), ""); obj.MA_CT = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MA_CT"), ""); obj.MA_YTCP_NO = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MA_YTCP_NO"), ""); obj.MA_NHOM = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MA_NHOM"), ""); obj.TEN_NHOM = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "TEN_NHOM"), ""); obj.KY_HIEU = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "KY_HIEU"), ""); obj.NAM_SX = Utils.CDblDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "NAM_SX"), 0); obj.MODEL = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MODEL"), ""); obj.QUY_CACH = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "QUY_CACH"), ""); obj.NUOC_SX = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "NUOC_SX"), ""); obj.NGUON_VON = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "NGUON_VON"), ""); obj.DANH_DAU = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "DANH_DAU"), ""); obj.TRANG_THAI = Utils.CIntDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "TRANG_THAI"), 0); _KTDMTSCDRepo.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); } }
private void Save_Tick() { try { _KTDMTSCDRepo = new KTDMTSCDRepo(); int id = Utils.CIntDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "ID").ToString(), 0); KT_DMTSCD obj = _KTDMTSCDRepo.GetById(id); if (obj != null) { obj.DANH_DAU = Utils.CStrDef(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "DANH_DAU"), "").Trim() == "T" ? "" : "T"; _KTDMTSCDRepo.Update(obj); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }