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 decimal find_hs_chat_luong_by_nv_thang_nam(decimal ip_dc_id_nv, decimal ip_dc_thang, decimal ip_dc_nam)
{
US_GD_HE_SO_CHAT_LUONG v_us = new US_GD_HE_SO_CHAT_LUONG();
DS_GD_HE_SO_CHAT_LUONG v_ds = new DS_GD_HE_SO_CHAT_LUONG();
v_us.FillDataset(v_ds);
string v_str_filter = "ID_NHAN_VIEN = " + ip_dc_id_nv + " AND THANG = " + ip_dc_thang + " AND NAM = " + ip_dc_nam;
DataRow[] v_dr = v_ds.GD_HE_SO_CHAT_LUONG.Select(v_str_filter);
if (v_dr.Count() == 0)
{
return 0;
}
else
{
return CIPConvert.ToDecimal(v_dr.First()["HE_SO_K"].ToString());
}
}
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 load_data_2_grid(decimal ip_dc_id_nv, decimal ip_dc_thang, decimal ip_dc_nam)
{
CHRMCommon.make_stt(m_grv_hs_chat_luong);
US_GD_HE_SO_CHAT_LUONG v_us = new US_GD_HE_SO_CHAT_LUONG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetHeSoCL(v_ds, ip_dc_id_nv, ip_dc_thang, ip_dc_nam);
//v_us.FillDatasetWithQuery(v_ds,"SELECT * FROM V_GD_HE_SO_CHAT_LUONG WHERE ID_NHAN_VIEN = " + ip_dc_id_nv + " AND THANG = " + ip_dc_thang + " AND NAM = " + ip_dc_nam);
m_grc_hs_chat_luong.DataSource = v_ds.Tables[0];
}
private void form_2_us_gd_hs_cl(US_GD_HE_SO_CHAT_LUONG ip_us)
{
decimal v_id_gd_hs_cl = 0;
v_id_gd_hs_cl = find_id_gd_hs_chat_luong(CIPConvert.ToDecimal(m_sle_chon_nhan_vien.EditValue), m_txt_thang, m_txt_nam);
ip_us.dcID_NHAN_VIEN = CIPConvert.ToDecimal(m_sle_chon_nhan_vien.EditValue);
ip_us.dcTHANG = m_txt_thang;
ip_us.dcNAM = m_txt_nam;
ip_us.dcHE_SO_K = CIPConvert.ToDecimal(m_txt_hs.Text.Trim());
if (v_id_gd_hs_cl > 0)
{
ip_us.dcID = v_id_gd_hs_cl;
ip_us.datNGAY_SUA = DateTime.Now.Date;
//nguoi sua
ip_us.strNGUOI_SUA = CAppContext_201.getCurrentUserName();
}
else
{
ip_us.datNGAY_LAP = DateTime.Now.Date;
//nguoi lap
ip_us.strNGUOI_LAP = CAppContext_201.getCurrentUserName();
ip_us.strDA_XOA = "N";
}
}
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++;
}
}
}
}
