public void display_4_update(US_GD_PHU_THUOC_DETAILS ip_us) { m_us_phu_thuoc_details = ip_us; us_obj_2_form(); m_e_form_mode = DataEntryFormMode.UpdateDataState; this.ShowDialog(); }
private void m_cmd_update_Click(object sender, EventArgs e) { try { decimal v_id_gd_phu_thuoc_details = CIPConvert.ToDecimal(m_grv1.GetRowCellValue(m_grv1.FocusedRowHandle, "ID")); if (v_id_gd_phu_thuoc_details > 0) { US_GD_PHU_THUOC_DETAILS v_us = new US_GD_PHU_THUOC_DETAILS(v_id_gd_phu_thuoc_details); f313_dang_ky_giam_tru_nguoi_phu_thuoc_v2_details v_frm = new f313_dang_ky_giam_tru_nguoi_phu_thuoc_v2_details(); v_frm.display_4_update(v_us); load_data_to_grid(); focus_new_row_created(v_id_gd_phu_thuoc_details); } else { CHRM_BaseMessages.MsgBox_Error(CONST_ID_MSGBOX.ERROR_CHUA_CHON_DONG_TREN_LUOI_DE_SUA); } } catch (Exception v_e) { CSystemLog_301.ExceptionHandle(v_e); } }
private void m_cmd_delete_Click(object sender, EventArgs e) { try { string v_str_confirm = "Việc xóa sẽ làm thay đổi số lượng người phụ thuộc của nhân viên.\n Bạn có chắc chắn muốn xóa?"; DialogResult v_dialog = XtraMessageBox.Show( v_str_confirm,"Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (v_dialog == DialogResult.Yes) { var v_dr = m_grv1.GetDataRow(m_grv1.FocusedRowHandle); US_GD_PHU_THUOC_DETAILS v_us = new US_GD_PHU_THUOC_DETAILS(CIPConvert.ToDecimal(v_dr[0].ToString())); v_us.strDA_XOA = "Y"; v_us.Update(); //update_gd_phu_thuoc(CIPConvert.ToDecimal(v_dr[4].ToString())); XtraMessageBox.Show("Xóa thành công!"); load_data_to_grid(); } } catch (Exception v_e) { CSystemLog_301.ExceptionHandle(v_e); } }
private void load_data_to_grid() { if(!check_input_date()) { return; } US_GD_PHU_THUOC_DETAILS v_us_detail = new US_GD_PHU_THUOC_DETAILS(); var v_dt_source = v_us_detail.LayDanhSachGiamTruPhuThuoc(from_date(), to_date()); m_grc.DataSource = v_dt_source; m_grc.RefreshDataSource(); }
//private void load_data_to_m_sle_chon_nhan_vien() //{ // m_sle_chon_nhan_vien.Properties.DataSource = load_data_to_ds_v_dm_nv().Tables[0]; // m_sle_chon_nhan_vien.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; // m_sle_chon_nhan_vien.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFit; //} //private DataSet load_data_to_ds_v_dm_nv() //{ // US_DUNG_CHUNG v_us = new US_DUNG_CHUNG(); // DataSet v_ds = new DataSet(); // v_ds.Tables.Add(new DataTable()); // throw new Exception("Sua lai khong dung FillDataSetWithTableName nua nhe"); // //v_us.FillDatasetWithTableName(v_ds, "V_DM_NHAN_VIEN"); // return v_ds; //} //private List<decimal> gd_phu_thuoc_thay_doi_yn(List<decimal> m_lst_nv_insert_phu_thuoc) //{ // List<decimal> v_lst_nv_thay_doi = new List<decimal>(); // for (int i = 0; i < m_lst_nv_insert_phu_thuoc.Count; i++) // { // DS_GD_PHU_THUOC v_ds = new DS_GD_PHU_THUOC(); // US_GD_PHU_THUOC v_us = new US_GD_PHU_THUOC(); // v_us.FillDataset(v_ds, "where da_xoa = 'N' and id_nhan_vien=" + m_lst_nv_insert_phu_thuoc[i]); // int v_slg_phu_thuoc_details = get_so_luong_phu_thuoc_details(m_lst_nv_insert_phu_thuoc[i]); // DataTable v_dt = v_ds.Tables[0]; // if (v_dt.Rows.Count == 0 || (CIPConvert.ToDecimal(v_dt.Rows[0][2].ToString()) < v_slg_phu_thuoc_details)) // { // v_lst_nv_thay_doi.Add(m_lst_nv_insert_phu_thuoc[i]); // } // } // return v_lst_nv_thay_doi; //} //private void update_gd_phu_thuoc(decimal ip_dc_id_nv) //{ // int v_slg_phu_thuoc_details = get_so_luong_phu_thuoc_details(ip_dc_id_nv); // DS_GD_PHU_THUOC v_ds = new DS_GD_PHU_THUOC(); // US_GD_PHU_THUOC v_us = new US_GD_PHU_THUOC(); // v_us.FillDatasetPhuThuoc(v_ds, ip_dc_id_nv); // if (v_ds.Tables[0].Rows.Count == 0) // { // v_us.dcID_NHAN_VIEN = ip_dc_id_nv; // v_us.dcSO_LUONG = CIPConvert.ToDecimal(v_slg_phu_thuoc_details); // v_us.strNGUOI_LAP = CAppContext_201.getCurrentUserName(); // v_us.strDA_XOA = "N"; // v_us.Insert(); // } // else // { // US_GD_PHU_THUOC v_us_gd_phu_thuoc = new US_GD_PHU_THUOC(CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0][0])); // v_us_gd_phu_thuoc.dcSO_LUONG = CIPConvert.ToDecimal(v_slg_phu_thuoc_details); // v_us_gd_phu_thuoc.Update(); // } //} //private int get_so_luong_phu_thuoc_details(decimal ip_dc_id_nv) //{ // DS_GD_PHU_THUOC_DETAILS v_ds = new DS_GD_PHU_THUOC_DETAILS(); // US_GD_PHU_THUOC_DETAILS v_us = new US_GD_PHU_THUOC_DETAILS(); // v_us.FillDatasetSoLuongPhuThuocDetails(v_ds, ip_dc_id_nv ); // return v_ds.Tables[0].Rows.Count; //} private void insert_gd_phu_thuoc_details() { for (int i = 0; i < m_grv1.RowCount; i++) { try { US_GD_PHU_THUOC_DETAILS v_us = new US_GD_PHU_THUOC_DETAILS(); var v_dr = m_grv1.GetDataRow(i); v_us.dcID_GD_PHU_THUOC = get_id_by_ma_nhan_vien(v_dr[0].ToString()); v_us.strHO_TEN_NGUOI_PHU_THUOC = v_dr[3].ToString(); v_us.datNGAY_SINH = return_datetime_data(v_dr[4].ToString()); v_us.strMA_SO_THUE = v_dr[5].ToString(); v_us.strQUOC_TICH = v_dr[6].ToString(); v_us.strSO_CMT_HO_CHIEU = v_dr[7].ToString(); v_us.strQUAN_HE_VOI_NGUOI_NOP_THUE = v_dr[8].ToString(); v_us.strTTGKS_SO = v_dr[9].ToString(); v_us.strTTGKS_QUYEN = v_dr[10].ToString(); v_us.strTTGKS_QUOC_GIA = v_dr[11].ToString(); v_us.strTTGKS_TINH_THANH = v_dr[12].ToString(); v_us.strTTGKS_QUAN_HUYEN = v_dr[13].ToString(); v_us.strTTGKS_PHUONG_XA = v_dr[14].ToString(); v_us.datTU_NGAY = return_datetime_data(v_dr[15].ToString()); v_us.strNGUOI_LAP = CAppContext_201.getCurrentUserName(); v_us.datNGAY_LAP = DateTime.Now; v_us.strDA_XOA = "N"; v_us.Insert(); } catch (Exception v_e) { CSystemLog_301.ExceptionHandle(v_e); } } }
void m_bgw_DoWork(object sender, DoWorkEventArgs e) { BackgroundWorker worker = sender as BackgroundWorker; US_GD_PHU_THUOC_DETAILS v_us_trans = new US_GD_PHU_THUOC_DETAILS(); try { v_us_trans.BeginTransaction(); for (int i = 0; i < m_grv1.RowCount; i++) { var v_dr = m_grv1.GetDataRow(i); insert_gd_phu_thuoc_details(v_dr, v_us_trans); worker.ReportProgress((i + 1) * 100 / m_grv1.RowCount); } v_us_trans.CommitTransaction(); } catch (Exception v_e) { if(v_us_trans.is_having_transaction()) { v_us_trans.Rollback(); } CSystemLog_301.ExceptionHandle(v_e); } }
private void insert_gd_phu_thuoc_details(DataRow v_dr, US_GD_PHU_THUOC_DETAILS v_us) { //US_GD_PHU_THUOC_DETAILS v_us = new US_GD_PHU_THUOC_DETAILS(); v_us.dcID_GD_PHU_THUOC = get_id_by_ma_nhan_vien(v_dr[0].ToString()); v_us.strHO_TEN_NGUOI_PHU_THUOC = v_dr[3].ToString(); if (v_dr[4].ToString().Trim() !="") v_us.datNGAY_SINH = convert_datetime(v_dr[4].ToString()); v_us.strMA_SO_THUE = v_dr[5].ToString(); v_us.strQUOC_TICH = v_dr[6].ToString(); v_us.strSO_CMT_HO_CHIEU = v_dr[7].ToString(); v_us.strQUAN_HE_VOI_NGUOI_NOP_THUE = v_dr[8].ToString(); v_us.strTTGKS_SO = v_dr[9].ToString(); v_us.strTTGKS_QUYEN = v_dr[10].ToString(); v_us.strTTGKS_QUOC_GIA = v_dr[11].ToString(); v_us.strTTGKS_TINH_THANH = v_dr[12].ToString(); v_us.strTTGKS_QUAN_HUYEN = v_dr[13].ToString(); v_us.strTTGKS_PHUONG_XA = v_dr[14].ToString(); if (v_dr[15].ToString().Trim() != "") v_us.datTU_NGAY = convert_datetime(v_dr[15].ToString()); if (v_dr[16].ToString().Trim() != "") v_us.datDEN_NGAY = convert_datetime(v_dr[16].ToString()); v_us.strNGUOI_LAP = CAppContext_201.getCurrentUserName(); v_us.datNGAY_LAP = DateTime.Now; v_us.strDA_XOA = "N"; v_us.Insert(); v_us.ClearAllFields(); }
private void m_cmd_delete_Click(object sender, EventArgs e) { try { var v_confirm = BaseMessages.MsgBox_Confirm("Bạn có chắc chắn muốn xóa người phụ thuộc này?"); if(v_confirm) { var v_dr = m_grv.GetDataRow(m_grv.FocusedRowHandle); US_GD_PHU_THUOC_DETAILS v_us = new US_GD_PHU_THUOC_DETAILS(CIPConvert.ToDecimal(v_dr["ID"].ToString())); v_us.strDA_XOA = "Y"; v_us.Update(); US_GD_PHU_THUOC v_us_gd_phu_thuoc = new US_GD_PHU_THUOC(Convert.ToDecimal(v_dr["ID_GD_PHU_THUOC"])); v_us_gd_phu_thuoc.dcSO_LUONG--; v_us_gd_phu_thuoc.Update(); load_data_2_grid(m_slue_nhan_vien.EditValue.ToString()); BaseMessages.MsgBox_Infor("91 - Xóa người phụ thuộc thành công"); } } catch(Exception) { throw; } }