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;
}
}
