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; } }
private void luu_gd_phu_thuoc() { try { US_GD_PHU_THUOC v_us = new US_GD_PHU_THUOC(); v_us.dcID_NHAN_VIEN = CIPConvert.ToDecimal(m_dc_id_nhan_vien.ToString()); v_us.dcSO_LUONG = CIPConvert.ToDecimal(m_txt_so_luong_phu_thuoc.Text); v_us.datNGAY_SUA = m_dat_ngay_ap_dung.Value; v_us.strNGUOI_LAP = "admin"; v_us.strNGUOI_SUA = "admin"; v_us.datNGAY_SUA = DateTime.Now.Date; v_us.strDA_XOA = "N"; switch (m_e_form_mode) { case DataEntryFormMode.UpdateDataState: break; case DataEntryFormMode.InsertDataState: v_us.Insert(); break; default: break; } } catch (Exception) { MessageBox.Show("Lỗi người phụ thuộc"); } }
private void m_cmd_insert_Click(object sender, EventArgs e) { US_DUNG_CHUNG v_us = new US_DUNG_CHUNG(); DataSet v_ds = new DataSet(); DataTable v_dt = new DataTable(); v_ds.Tables.Add(v_dt); v_us.FillDatasetWithQuery(v_ds, "select * from gd_phu_thuoc where ID_NHAN_VIEN = " + m_slue_nhan_vien.EditValue.ToString() + " and DA_XOA = 'N'"); US_GD_PHU_THUOC v_us_pt; if (v_ds.Tables[0].Rows.Count > 0) { v_us_pt = new US_GD_PHU_THUOC(CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0]["ID"].ToString())); v_us_pt.dcSO_LUONG = v_us_pt.dcSO_LUONG + 1; v_us_pt.Update(); } else { v_us_pt = new US_GD_PHU_THUOC(); v_us_pt.dcID_NHAN_VIEN = CIPConvert.ToDecimal(m_slue_nhan_vien.EditValue.ToString()); v_us_pt.dcSO_LUONG = 1; v_us_pt.strDA_XOA = "N"; v_us_pt.Insert(); } //US_GD_PHU_THUOC_DETAILS v_us_2 = new US_GD_PHU_THUOC_DETAILS(); //v_us_2.strDIA_CHI_NGUOI_PHU_THUOC = m_txt_dia_chi_thuong_tru.Text; //v_us_2.strGIAY_TO_DI_KEM = m_txt_giay_to.Text; //v_us_2.strMA_SO_THUE_NGUOI_PHU_THUOC = m_txt_mst_ng_pt.Text; //v_us_2.strQUAN_HE_VOI_NGUOI_NOP_THUE = m_txt_quan_he.Text; //v_us_2.strSO_CMT_NGUOI_PHU_THUOC = m_txt_cmt_nguoi_pt.Text; //v_us_2.strTEN_NGUOI_PHU_THUOC = m_txt_ho_ten.Text; //v_us_2.datNGAY_SINH_NGUOI_PHU_THUOC = dateTimePicker2.Value; //v_us_2.dcID_GD_PHU_THUOC = v_us_pt.dcID; //v_us_2.strDA_XOA = "N"; //v_us_2.Insert(); //BaseMessages.MsgBox_Infor("90 - Thêm người phụ thuộc thành công"); //load_data_2_grid(m_slue_nhan_vien.EditValue.ToString()); }
private void load_gd_phu_thuoc(int id_nhan_vien) { US_GD_PHU_THUOC v_us = new US_GD_PHU_THUOC(); m_txt_so_luong_phu_thuoc.Text = v_us.dcSO_LUONG.ToString(); m_dat_ngay_ap_dung.Value = v_us.datNGAY_SUA; }