private void delete_gd_da_co_trong_thang_cua_nhan_vien(US_DUNG_CHUNG v_us_dc, DataRow v_data_row, decimal ip_dc_id_nv)
{
decimal v_id_gd_thu_nhap_khac = 0;
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us_dc.FillDatasetWithQuery(v_ds, "SELECT * FROM GD_THU_NHAP_KHAC WHERE ID_NHAN_VIEN =" + ip_dc_id_nv + " AND THANG = " + CIPConvert.ToDecimal(m_txt_chon_thang.Text.Trim()) + " AND NAM = " + CIPConvert.ToDecimal(m_txt_chon_nam.Text.Trim()));
if (v_ds.Tables[0].Rows.Count > 0)
{
v_id_gd_thu_nhap_khac = CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0]["ID"].ToString());
US_GD_HE_SO_CHAT_LUONG v_us_gd_hs_cl = new US_GD_HE_SO_CHAT_LUONG(v_id_gd_thu_nhap_khac);
v_us_gd_hs_cl.BeginTransaction();
v_us_gd_hs_cl.Delete();
v_us_gd_hs_cl.CommitTransaction();
}
else
{
return;
}
}
private void save_data()
{
US_GD_HE_SO_CHAT_LUONG v_us_gd_hs_cl = new US_GD_HE_SO_CHAT_LUONG();
form_2_us_gd_hs_cl(v_us_gd_hs_cl);
try
{
if (v_us_gd_hs_cl.dcID > 0)
{
US_GD_HE_SO_CHAT_LUONG v_us = new US_GD_HE_SO_CHAT_LUONG(v_us_gd_hs_cl.dcID);
v_us.dcHE_SO_K = CIPConvert.ToDecimal(m_txt_hs.Text.Trim());
v_us.datNGAY_SUA = DateTime.Now.Date;
//nguoi sua
v_us.BeginTransaction();
v_us.Update();
v_us.CommitTransaction();
}
else
{
v_us_gd_hs_cl.BeginTransaction();
v_us_gd_hs_cl.Insert();
v_us_gd_hs_cl.CommitTransaction();
}
}
catch (Exception v_e)
{
throw v_e;
}
}
private void kiem_tra_va_thuc_hien_nhap_hs(ref decimal v_count, ref int v_int_khong_nhap_duoc, decimal v_selectedRowCount)
{
if (CHRMCommon.thang_da_chot_bang_luong(CIPConvert.ToDecimal(m_txt_chon_thang.Text.Trim()), CIPConvert.ToDecimal(m_txt_chon_nam.Text.Trim())))
{
CHRM_BaseMessages.MsgBox_Error(CONST_ID_MSGBOX.ERROR_THANG_DA_CHOT_BANG_LUONG);
return;
}
else
{
for (int i = 0; i < v_selectedRowCount; i++)
{
decimal v_id_nv = 0;
US_DUNG_CHUNG v_us_dc = new US_DUNG_CHUNG();
US_GD_HE_SO_CHAT_LUONG v_us_hs_cl = new US_GD_HE_SO_CHAT_LUONG();
var v_data_row = m_grv_them_hs.GetDataRow(m_grv_them_hs.GetSelectedRows()[i]);
try
{
get_id_nhan_vien_tu_data_row(v_us_dc, v_data_row, ref v_id_nv);
}
catch (Exception)
{
CHRM_BaseMessages.MsgBox_Error("Mã nhân viên " + v_data_row[1].ToString() + " không tồn tại trong hệ thống. Vui lòng kiểm tra lại thông tin!");
v_int_khong_nhap_duoc++;
continue;
}
v_us_hs_cl.dcID_NHAN_VIEN = v_id_nv;
v_us_hs_cl.dcHE_SO_K = Convert.ToDecimal(v_data_row["HSK"]);
v_us_hs_cl.dcTHANG = CIPConvert.ToDecimal(m_txt_chon_thang.Text.Trim());
v_us_hs_cl.dcNAM = CIPConvert.ToDecimal(m_txt_chon_nam.Text.Trim());
v_us_hs_cl.datNGAY_LAP = DateTime.Now.Date;
v_us_hs_cl.strNGUOI_LAP = CAppContext_201.getCurrentUserName();
v_us_hs_cl.strDA_XOA = "N";
try
{
delete_gd_da_co_trong_thang_cua_nhan_vien(v_us_dc, v_data_row, v_id_nv);
v_us_hs_cl.BeginTransaction();
v_us_hs_cl.Insert();
v_us_hs_cl.CommitTransaction();
v_count++;
}
catch (Exception)
{
CHRM_BaseMessages.MsgBox_Error(CONST_ID_MSGBOX.ERROR_DA_CO_LOI_XAY_RA);
v_int_khong_nhap_duoc++;
}
}
}
}