//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);
}
}
}
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();
}