private void kiem_tra_va_thuc_hien_nhap_du_lieu(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_THU_NHAP_KHAC v_us_gd_thu_nhap_khac = new US_GD_THU_NHAP_KHAC();
var v_data_row = m_grv_quan_ly_thu_nhap_khac.GetDataRow(m_grv_quan_ly_thu_nhap_khac.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;
}
form_2_us_gd_thu_nhap_khac(v_us_gd_thu_nhap_khac, v_id_nv, v_data_row);
try
{
delete_gd_da_co_trong_thang_cua_nhan_vien(v_us_dc, v_data_row, v_id_nv);
v_us_gd_thu_nhap_khac.BeginTransaction();
v_us_gd_thu_nhap_khac.Insert();
v_us_gd_thu_nhap_khac.CommitTransaction();
v_count++;
}
catch (Exception)
{
CHRM_BaseMessages.MsgBox_Error(CONST_ID_MSGBOX.ERROR_DA_CO_LOI_XAY_RA);
v_int_khong_nhap_duoc++;
}
}
}
}
private void save_data(ref decimal v_id_gd_thu_nhap_khac)
{
US_GD_THU_NHAP_KHAC v_us_gd_thu_nhap_khac = new US_GD_THU_NHAP_KHAC();
form_2_us_obj(v_us_gd_thu_nhap_khac);
try
{
switch (m_e_form_mode)
{
case DataEntryFormMode.InsertDataState:
v_us_gd_thu_nhap_khac.BeginTransaction();
v_us_gd_thu_nhap_khac.Insert();
v_us_gd_thu_nhap_khac.CommitTransaction();
v_id_gd_thu_nhap_khac = v_us_gd_thu_nhap_khac.dcID;
CHRM_BaseMessages.MsgBox_Infor(CONST_ID_MSGBOX.INFOR_LUU_DU_LIEU_THANH_CONG);
break;
case DataEntryFormMode.UpdateDataState:
v_us_gd_thu_nhap_khac.BeginTransaction();
v_us_gd_thu_nhap_khac.dcID = CIPConvert.ToDecimal(m_grv_quan_ly_thu_nhap_khac.GetRowCellValue(m_grv_quan_ly_thu_nhap_khac.FocusedRowHandle, "ID").ToString());
v_us_gd_thu_nhap_khac.Update();
v_us_gd_thu_nhap_khac.CommitTransaction();
CHRM_BaseMessages.MsgBox_Infor(CONST_ID_MSGBOX.INFOR_DU_LIEU_DA_DUOC_CAP_NHAT);
break;
default:
break;
}
}
catch (Exception v_e)
{
throw v_e;
}
}
private void save_data()
{
try
{
var rowCount = m_grv_main.RowCount;
US_GD_THU_NHAP_KHAC v_us_gd_thu_nhap_khac = new US_GD_THU_NHAP_KHAC();
splashScreenManager1.ShowWaitForm();
for(int i = 0; i < rowCount; i++)
{
var dr = m_grv_main.GetDataRow(i);
var is_exist = v_us_gd_thu_nhap_khac.KiemTraXemDaInsertThuong2014Chua(Convert.ToDecimal(m_sle_quy_tien_thuong.EditValue), Convert.ToDecimal(dr["ID"]));
if(is_exist)
{
continue;
}
if(dr["HS_THUONG"].ToString() == "")
{
continue;
}
data_row_2_us(dr, ref v_us_gd_thu_nhap_khac);
v_us_gd_thu_nhap_khac.Insert();
}
//
}
catch(Exception)
{
throw;
}
finally
{
splashScreenManager1.CloseWaitForm();
}
}
private void save_data()
{
for (int i = 0; i < m_grv.RowCount; i++)
{
var v_dr = m_grv.GetDataRow(i);
US_GD_THU_NHAP_KHAC v_us = new US_GD_THU_NHAP_KHAC();
v_us.dcID_NHAN_VIEN = get_id_nhan_vien_by_ma_nv(v_dr[1].ToString());
v_us.dcTHANG = m_dat_thang.DateTime.Month;
v_us.dcNAM = m_dat_thang.DateTime.Year;
v_us.dcHE_SO = 0;
v_us.dcSO_TIEN = return_so_tien(v_dr[4].ToString());
v_us.dcSO_TIEN_NOP_THUE = return_so_tien(v_dr[5].ToString());
v_us.dcSO_TIEN_THUC_LINH = return_so_tien(v_dr[6].ToString());
v_us.dcID_LOAI_THU_NHAP_KHAC = 756;
v_us.dcID_QUY_THU_NHAP_KHAC = decimal.Parse(m_sle_quy_tien.EditValue.ToString());
if (i == 0)
v_us.BeginTransaction();
else
{
v_us.UseTransOfUSObject(m_us);
}
m_us = v_us;
v_us.Insert();
}
m_us.CommitTransaction();
}
private void save_data_tien_thuong_nhan_vien()
{
//B1: Lấy danh sách nhân viên chưa tính tiền thưởng
var v_ds_nhan_vien_canh_tinh = lay_danh_sach_nhan_vien_chua_tinh_thuong();
//B1.1: Luu thang da giam tru
//luu_thang_da_giam_tru();
var rowLimit = v_ds_nhan_vien_canh_tinh.DM_NHAN_VIEN.Count;
for(int rowToComput = 0; rowToComput < rowLimit; rowToComput++)
{
var v_id_nv = (decimal)v_ds_nhan_vien_canh_tinh.DM_NHAN_VIEN.Rows[rowToComput][DM_NHAN_VIEN.ID];
//B2: Tinh thu nhap khac cho nhan vien nay
DataRow v_dr_du_lieu_1_nv = null;
if(m_us_v_gd_quy_tien_thuong.dcID_LOAI_QUY_TIEN == CONST_ID_TIEN_THUONG.THUONG_ATHK)
{
v_dr_du_lieu_1_nv = lay_du_lieu_tien_thuong_athk_1_nhan_vien(v_id_nv);
}
else if(m_us_v_gd_quy_tien_thuong.dcID_LOAI_QUY_TIEN == CONST_ID_TIEN_THUONG.THUONG_HS_BS)
{
v_dr_du_lieu_1_nv = lay_du_lieu_tien_thuong_hsbs_1_nhan_vien(v_id_nv);
}
//B3: Chuyen doi du lieu tu DataRow sang US de insert
US_GD_THU_NHAP_KHAC v_us_gd_thu_nhap_khac = new US_GD_THU_NHAP_KHAC();
data_row_2_us(v_dr_du_lieu_1_nv, ref v_us_gd_thu_nhap_khac);
v_us_gd_thu_nhap_khac.Insert();
m_bgwk.ReportProgress((rowToComput + 1) * 100 / rowLimit);
}
mark_complete_tinh_thuong();
}
//GD_THU_NHAP_KHAC
private void luu_so_tien_vao_gd_thu_nhap_khac(DataSet ip_ds)
{
for (int i = 0; i < ip_ds.Tables[0].Rows.Count; i++)
{
US_GD_THU_NHAP_KHAC v_us_thu_khac = new US_GD_THU_NHAP_KHAC();
v_us_thu_khac.dcID_NHAN_VIEN = CIPConvert.ToDecimal(ip_ds.Tables[0].Rows[i]["ID_NHAN_VIEN"]);
v_us_thu_khac.dcSO_TIEN = CIPConvert.ToDecimal(ip_ds.Tables[0].Rows[i]["SO_TIEN"]);
v_us_thu_khac.dcTHANG = CIPConvert.ToDecimal(DateTime.Now.Month.ToString());
v_us_thu_khac.dcNAM = CIPConvert.ToDecimal(ip_ds.Tables[0].Rows[i]["NAM"]);
v_us_thu_khac.strLY_DO = ip_ds.Tables[0].Rows[i]["LY_DO"].ToString();
if (int.Parse(ip_ds.Tables[0].Rows[i]["ID_TRANG_THAI_LAO_DONG"].ToString()) == CONST_ID_TRANG_THAI_LAO_DONG.NGHI_HUU)
{
v_us_thu_khac.dcID_CACH_TINH_THUE = CONST_ID_LOAI_CACH_TINH_THUE.THUE_10PT;
}
else
{
v_us_thu_khac.dcID_CACH_TINH_THUE = CONST_ID_LOAI_CACH_TINH_THUE.THUE_THANG;
}
v_us_thu_khac.dcID_LOAI_THU_NHAP_KHAC = CIPConvert.ToDecimal(ip_ds.Tables[0].Rows[i]["ID_LOAI_THU_NHAP_KHAC"]);
v_us_thu_khac.dcID_QUY_TIEN_THUONG = CONST_ID_TIEN_THUONG.THUONG_HS_BS;
v_us_thu_khac.dcSO_TIEN_GIAM_TRU = CIPConvert.ToDecimal(ip_ds.Tables[0].Rows[i]["SO_TIEN_GIAM_TRU"]);
v_us_thu_khac.dcSO_TIEN_NOP_THE = CIPConvert.ToDecimal(ip_ds.Tables[0].Rows[i]["SO_TIEN_NOP_THUE"]);
v_us_thu_khac.dcSO_TIEN_THUC_LINH = CIPConvert.ToDecimal(ip_ds.Tables[0].Rows[i]["SO_TIEN_SAU_TINH_THUE"]);
v_us_thu_khac.Insert();
}
}
