internal void display_for_update(US_GD_THU_NHAP_KHAC v_us)
{
m_e_form_mode = DataEntryFormMode.UpdateDataState;
set_init_form_load();
m_us_gd_tnk = v_us;
us_2_form(v_us);
this.ShowDialog();
}
private void load_data_to_grid()
{
CHRMCommon.make_stt(m_grv);
DataSet v_ds = new DataSet();
US_GD_THU_NHAP_KHAC v_us = new US_GD_THU_NHAP_KHAC();
v_ds.Tables.Add(new DataTable());
v_us.filldatasetTNKNgoaiBangLuong(v_ds, m_txt_thang.ToString(), m_txt_nam.ToString());
m_grc.DataSource = v_ds.Tables[0];
}
private bool check_quy_tien_dang_su_dung_yn(decimal id_quy_tnk)
{
US_GD_THU_NHAP_KHAC v_us_gd_tnk = new US_GD_THU_NHAP_KHAC();
DS_GD_THU_NHAP_KHAC v_ds_gd_tnk = new DS_GD_THU_NHAP_KHAC();
v_us_gd_tnk.LayDuLieuThuNhapKhacTheoIDQuy(v_ds_gd_tnk, id_quy_tnk);
if (v_ds_gd_tnk.Tables[0].Rows.Count != 0)
return true;
else return false;
}
private void load_data_to_grid()
{
CHRMCommon.make_stt(m_grv_hs_bs_hs_athk);
DataSet v_ds = new DataSet();
US_GD_THU_NHAP_KHAC v_us = new US_GD_THU_NHAP_KHAC();
v_ds.Tables.Add(new DataTable());
v_us.filldatasetBaoCaoThuNhapLDNgoaiBangLuong(v_ds, m_txt_chon_thang.ToString(), m_txt_chon_nam.ToString(), m_sle_nhom_ld.EditValue.ToString());
m_grc_bc_thu_lao.DataSource = v_ds.Tables[0];
this.Load += F481_bao_cao_thu_lao_hdqt_Load;
m_dat_thang.DateTimeChanged += M_dat_thang_DateTimeChanged;
}
private void delete_gd_thu_nhap_khac(US_GD_QUY_THU_NHAP_KHAC v_us_gd_quy_tnk)
{
US_GD_THU_NHAP_KHAC v_us = new US_GD_THU_NHAP_KHAC();
DS_GD_THU_NHAP_KHAC v_ds = new DS_GD_THU_NHAP_KHAC();
v_us.XoaTNKTheoIDQuy(v_us_gd_quy_tnk.dcID);
//for (int i = 0; i < m_dt_thu_nhap_khac.Rows.Count; i++)
//{
// US_GD_THU_NHAP_KHAC v_us = new US_GD_THU_NHAP_KHAC(decimal.Parse(m_dt_thu_nhap_khac.Rows[i][0].ToString()));
// v_us.Delete();
//}
}
public void Display_for_insert(decimal ip_dc_id_quy_thu_nhap_khac)
{
US_GD_QUY_THU_NHAP_KHAC v_us_quy = new US_GD_QUY_THU_NHAP_KHAC(ip_dc_id_quy_thu_nhap_khac);
m_us_gd_tnk = new US_GD_THU_NHAP_KHAC();
m_us_gd_tnk.dcID_QUY_THU_NHAP_KHAC = v_us_quy.dcID;
m_us_gd_tnk.dcID_LOAI_THU_NHAP_KHAC = v_us_quy.dcID_LOAI_QUY_THU_NHAP_KHAC;
m_us_gd_tnk.dcNAM = Convert.ToDecimal(v_us_quy.strNAM);
m_us_gd_tnk.dcTHANG = Convert.ToDecimal(v_us_quy.strTHANG);
m_e_form_mode = DataEntryFormMode.InsertDataState;
ShowDialog();
}
void m_cmd_delete_Click(object sender, EventArgs e)
{
string v_str_confirm = "Bạn có chắc chắn muốn xóa khoản thu nhập này";
if (CHRM_BaseMessages.MsgBox_Confirm (v_str_confirm))
{
var v_dr = m_grv.GetDataRow(m_grv.FocusedRowHandle);
US_GD_THU_NHAP_KHAC v_us = new US_GD_THU_NHAP_KHAC(CIPConvert.ToDecimal(v_dr[2].ToString()));
v_us.Delete();
XtraMessageBox.Show("Xóa thành công!");
load_data_to_grid();
}
}
private bool check_quy_tien_dang_su_dung_yn(US_GD_QUY_THU_NHAP_KHAC v_us)
{
m_dt_thu_nhap_khac.Clear();
US_GD_THU_NHAP_KHAC v_us_gd_tnk = new US_GD_THU_NHAP_KHAC();
DS_GD_THU_NHAP_KHAC v_ds_gd_tnk = new DS_GD_THU_NHAP_KHAC();
v_us_gd_tnk.LayDuLieuThuNhapKhacTheoIDQuy(v_ds_gd_tnk, v_us.dcID);
if (v_ds_gd_tnk.Tables[0].Rows.Count != 0)
{
m_dt_thu_nhap_khac = v_ds_gd_tnk.Tables[0];
return true;
}
else return false;
}
public void Display_for_update(decimal ip_dc_id_thu_nhap_khac)
{
m_e_form_mode = DataEntryFormMode.UpdateDataState;
m_us_gd_tnk = new US_GD_THU_NHAP_KHAC(ip_dc_id_thu_nhap_khac);
m_sle_chon_nhan_vien.EditValue = m_us_gd_tnk.dcID_NHAN_VIEN;
m_sle_chon_nhan_vien.ReadOnly = true;
m_txt_he_so.EditValue = m_us_gd_tnk.dcHE_SO;
m_txt_so_tien.EditValue = m_us_gd_tnk.dcSO_TIEN;
m_txt_so_tien_nop_thue.EditValue = m_us_gd_tnk.dcSO_TIEN_NOP_THUE;
m_txt_so_tien_thuc_linh.EditValue = m_us_gd_tnk.dcSO_TIEN_THUC_LINH;
ShowDialog();
}
private void data_row_2_us(DataRow ip_dr_du_lieu_1_nv, ref US_GD_THU_NHAP_KHAC ref_us)
{
ref_us.dcID_NHAN_VIEN = (decimal)ip_dr_du_lieu_1_nv["ID_NHAN_VIEN"];
ref_us.dcSO_TIEN = Convert.ToDecimal(ip_dr_du_lieu_1_nv["SO_TIEN_THUONG_NV"]);
ref_us.dcTHANG = Convert.ToDecimal(m_us_v_gd_quy_tien_thuong.strTHANG);
ref_us.dcNAM = Convert.ToDecimal(m_us_v_gd_quy_tien_thuong.strNAM);
ref_us.dcID_CACH_TINH_THUE = m_us_v_gd_quy_tien_thuong.dcID_CACH_TINH_THUE;
ref_us.dcID_LOAI_THU_NHAP_KHAC = CONST_ID_LOAI_THU_NHAP_KHAC.LINH_CO_THUE;
ref_us.dcID_QUY_TIEN_THUONG = m_us_v_gd_quy_tien_thuong.dcID;
ref_us.dcSO_TIEN_GIAM_TRU = Convert.ToDecimal(ip_dr_du_lieu_1_nv["SO_TIEN_GIAM_TRU"]);
ref_us.dcSO_TIEN_NOP_THE = Convert.ToDecimal(ip_dr_du_lieu_1_nv["SO_THUE_PHAI_NOP"]);
ref_us.dcSO_TIEN_THUC_LINH = Convert.ToDecimal(ip_dr_du_lieu_1_nv["THUC_LINH"]);
ref_us.dcTONG_HS_ATHK = Convert.ToDecimal(ip_dr_du_lieu_1_nv["TONG_HS_ATHK"]);
ref_us.dcTRUY_LINH = 0;
ref_us.dcTRUY_THU = 0;
ref_us.dcTHUC_LINH_CUOI_CUNG = ref_us.dcSO_TIEN - ref_us.dcSO_TIEN_NOP_THE;
}
private void delete_tnk()
{
if(m_grv_main.FocusedRowHandle < 0)
{
XtraMessageBox.Show("Bạn chưa chọn dòng dữ liệu nào để xóa!", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var dlg = XtraMessageBox.Show("Bạn có chắc chắn muốn xóa dữ liệu? Dữ liệu đã xóa không thể khôi phục được!", "THÔNG BÁO", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if(dlg == System.Windows.Forms.DialogResult.Yes)
{
var v_dc_id_gd_thu_nhap_khac = Convert.ToDecimal(m_grv_main.GetFocusedDataRow()[GD_THU_NHAP_KHAC.ID]);
US_GD_THU_NHAP_KHAC v_us_gd_tnk = new US_GD_THU_NHAP_KHAC();
v_us_gd_tnk.DeleteByID(v_dc_id_gd_thu_nhap_khac);
load_data_to_grid();
}
else
{
return;
}
}
private void data_row_2_us(DataRow ip_dr_du_lieu_1_nv, ref US_GD_THU_NHAP_KHAC ref_us)
{
var v_dr = (DataRow)m_sle_quy_tien_thuong.Properties.View.GetFocusedDataRow();
ref_us.dcID_NHAN_VIEN = Convert.ToDecimal(ip_dr_du_lieu_1_nv["ID"]);
ref_us.dcSO_TIEN = Convert.ToDecimal(ip_dr_du_lieu_1_nv["THANH_TIEN"]);
ref_us.dcTHANG = Convert.ToDecimal(v_dr["THANG"]);
ref_us.dcNAM = Convert.ToDecimal(v_dr["NAM"]);
ref_us.dcID_CACH_TINH_THUE = (decimal)m_cach_tinh_thue;
ref_us.dcID_LOAI_THU_NHAP_KHAC = CONST_ID_LOAI_THU_NHAP_KHAC.LINH_CO_THUE;
ref_us.dcID_QUY_TIEN_THUONG = Convert.ToDecimal(m_sle_quy_tien_thuong.EditValue);
// ref_us.dcSO_TIEN_GIAM_TRU =
ref_us.dcSO_TIEN_NOP_THE = Convert.ToDecimal(ip_dr_du_lieu_1_nv["THUE"]);
ref_us.dcSO_TIEN_THUC_LINH = Convert.ToDecimal(ip_dr_du_lieu_1_nv["THUC_LINH"]);
ref_us.dcTRUY_LINH = Convert.ToDecimal(ip_dr_du_lieu_1_nv["TRUY_LINH"]);
ref_us.dcTRUY_THU = Convert.ToDecimal(ip_dr_du_lieu_1_nv["TRUY_THU"]);
ref_us.dcTHUC_LINH_CUOI_CUNG = ref_us.dcSO_TIEN_THUC_LINH + ref_us.dcTRUY_LINH - ref_us.dcTRUY_THU;
// ref_us.dcTONG_HS_ATHK = Convert.ToDecimal(ip_dr_du_lieu_1_nv["TONG_HS_ATHK"]);
}
public void display_athk(decimal ip_dc_id_quy_tien)
{
fill_data_quy_tien_thuong();
US_GD_THU_NHAP_KHAC v_us = new US_GD_THU_NHAP_KHAC();
DataSet v_ds = new DataSet();
v_ds.Tables.Add();
v_us.LayDuLieuThuNhapKhac(v_ds, ip_dc_id_quy_tien);
m_grc_luong_thuong.DataSource = v_ds.Tables[0];
//US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
//DataSet v_ds = new DataSet();
//v_ds.Tables.Add();
//v_us.FillDatasetWithQuery(v_ds, "select * from V_GD_THU_NHAP_KHAC_2 where id_quy_tien_thuong = " + ip_dc_id_quy_tien);
//m_grc_luong_thuong.DataSource = v_ds.Tables[0];
CHRMCommon.make_stt_indicator(m_grv_luong_thuong);
m_sle_quy_thuong.EditValue = ip_dc_id_quy_tien;
m_grv_luong_thuong.Columns["TRUY_LINH"].Visible = false;
m_grv_luong_thuong.Columns["TRUY_THU"].Visible = false;
m_grv_luong_thuong.Columns["THUC_LINH_CUOI_CUNG"].Visible = false;
ShowDialog();
}
private void us_2_form(US_GD_THU_NHAP_KHAC v_us)
{
m_sle_chon_nhan_vien.EditValue = v_us.dcID_NHAN_VIEN;
m_sle_quy_tien.EditValue = v_us.dcID_QUY_THU_NHAP_KHAC;
m_txt_so_tien.Text = v_us.dcSO_TIEN.ToString();
m_txt_ly_do.Text = v_us.strLY_DO;
//m_txt_thang.Text = v_us.dcTHANG.ToString();
//m_txt_nam.Text = v_us.dcNAM.ToString();
// m_sle_loai_thue.EditValue = v_us.dcID_CACH_TINH_THUE;
m_txt_so_tien_thue.Text = v_us.dcSO_TIEN_NOP_THUE.ToString();
m_txt_thuc_linh.Text = v_us.dcSO_TIEN_THUC_LINH.ToString();
}
private void us_obj_2_form(decimal ip_dc_id_gd_thu_nhap_khac)
{
US_GD_THU_NHAP_KHAC v_us = new US_GD_THU_NHAP_KHAC(ip_dc_id_gd_thu_nhap_khac);
m_sle_chon_nhan_vien.EditValue = v_us.dcID_NHAN_VIEN;
m_txt_chon_thang.Text = v_us.dcTHANG.ToString();
m_txt_chon_nam.Text = v_us.dcNAM.ToString();
m_sle_loai_thu_nhap.EditValue = v_us.dcID_LOAI_THU_NHAP_KHAC;
m_sle_cach_tinh_thue.EditValue = v_us.dcID_CACH_TINH_THUE;
m_txt_so_tien.Text = v_us.dcSO_TIEN.ToString();
CHRMCommon.format_text_2_money(m_txt_so_tien);
m_txt_ly_do.Text = v_us.strLY_DO;
}
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;
}
}
void m_cmd_delete_Click(object sender, EventArgs e)
{
try
{
if (m_grv_quan_ly_thu_nhap_khac.RowCount != 0)
{
decimal v_id_gd_thu_nhap_khac = CIPConvert.ToDecimal(m_grv_quan_ly_thu_nhap_khac.GetRowCellValue(m_grv_quan_ly_thu_nhap_khac.FocusedRowHandle, "ID").ToString());
US_GD_THU_NHAP_KHAC v_us_gd_thu_nhap_khac = new US_GD_THU_NHAP_KHAC(v_id_gd_thu_nhap_khac);
v_us_gd_thu_nhap_khac.Delete();
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
//save data
private void form_2_us_obj(US_GD_THU_NHAP_KHAC ip_us)
{
ip_us.dcID_NHAN_VIEN = CIPConvert.ToDecimal(m_sle_chon_nhan_vien.EditValue);
ip_us.dcSO_TIEN = CIPConvert.ToDecimal(m_txt_so_tien.Text.Trim());
ip_us.dcTHANG = CIPConvert.ToDecimal(m_txt_chon_thang.Text.Trim());
ip_us.dcNAM = CIPConvert.ToDecimal(m_txt_chon_nam.Text.Trim());
ip_us.dcID_LOAI_THU_NHAP_KHAC = CIPConvert.ToDecimal(m_sle_loai_thu_nhap.EditValue);
if (m_sle_cach_tinh_thue.EditValue != null && m_sle_cach_tinh_thue.EditValue != "")
{
ip_us.dcID_CACH_TINH_THUE = CIPConvert.ToDecimal(m_sle_cach_tinh_thue.EditValue);
}
ip_us.strLY_DO = m_txt_ly_do.Text.Trim();
}
private void focus_new_row_created(decimal v_id_gd_thu_nhap_khac)
{
int v_row_index = 0;
decimal v_id_gd_moi_lap = 0;
US_GD_THU_NHAP_KHAC v_us = new US_GD_THU_NHAP_KHAC();
DS_GD_THU_NHAP_KHAC v_ds = new DS_GD_THU_NHAP_KHAC();
v_id_gd_moi_lap = v_id_gd_thu_nhap_khac;
v_us.FillDataset(v_ds);
for (v_row_index = 0; v_row_index < v_ds.Tables[0].Rows.Count; v_row_index++)
{
var v_id_gd_qd = CIPConvert.ToDecimal(m_grv_quan_ly_thu_nhap_khac.GetDataRow(v_row_index)["ID"].ToString());
if (v_id_gd_qd == v_id_gd_moi_lap)
{
break;
}
}
m_grv_quan_ly_thu_nhap_khac.FocusedRowHandle = v_row_index;
}
//private void luu_thang_da_giam_tru()
//{
// US_GD_THANG_DA_GIAM_TRU v_us_thang_da_giam_tru = new US_GD_THANG_DA_GIAM_TRU();
// decimal op_dc_thang_da_giam_tru = 0;
// v_us_thang_da_giam_tru.kiem_tra_thang_da_giam_tru_chua(m_dat_thang_thuong.DateTime.Month
// , m_dat_thang_thuong.DateTime.Year
// , ref op_dc_thang_da_giam_tru);
// if(op_dc_thang_da_giam_tru == 1)
// {
// return;
// }
// v_us_thang_da_giam_tru.strTHANG = m_dat_thang_thuong.DateTime.Month.ToString();
// v_us_thang_da_giam_tru.strNAM = m_dat_thang_thuong.DateTime.Year.ToString();
// v_us_thang_da_giam_tru.strGIAM_TRU_YN = "Y";
// v_us_thang_da_giam_tru.strNGUOI_LAP = CAppContext_201.getCurrentUserName();
// v_us_thang_da_giam_tru.datNGAY_LAP = DateTime.Now.Date;
// v_us_thang_da_giam_tru.strDA_XOA = "N";
// v_us_thang_da_giam_tru.Insert();
//}
private DS_DM_NHAN_VIEN lay_danh_sach_nhan_vien_chua_tinh_thuong()
{
US_GD_THU_NHAP_KHAC v_us_gd_thu_nhap_khac = new US_GD_THU_NHAP_KHAC();
DS_DM_NHAN_VIEN op_ds;
v_us_gd_thu_nhap_khac.Get_tat_ca_nhan_vien_can_tinh_thuong(out op_ds, m_us_v_gd_quy_tien_thuong.dcID);
return op_ds;
}
void m_cmd_update_Click(object sender, EventArgs e)
{
var v_dr = m_grv.GetDataRow(m_grv.FocusedRowHandle);
US_GD_THU_NHAP_KHAC v_us = new US_GD_THU_NHAP_KHAC(CIPConvert.ToDecimal(v_dr[2].ToString()));
f304_tnk_ngoai_bang_luong_detail v_f = new f304_tnk_ngoai_bang_luong_detail();
v_f.display_for_update(v_us);
load_data_to_grid();
}
private void form_2_us_gd_thu_nhap_khac(US_GD_THU_NHAP_KHAC ip_us, decimal ip_dc_id_nv, DataRow v_data_row)
{
ip_us.dcID_NHAN_VIEN = ip_dc_id_nv;
ip_us.dcSO_TIEN = CIPConvert.ToDecimal(v_data_row[4].ToString());
ip_us.dcTHANG = CIPConvert.ToDecimal(m_txt_chon_thang.Text.Trim());
ip_us.dcNAM = CIPConvert.ToDecimal(m_txt_chon_nam.Text.Trim());
ip_us.dcID_LOAI_THU_NHAP_KHAC = find_id_loai_thu_nhap_khac(v_data_row[2].ToString());
ip_us.dcID_CACH_TINH_THUE = find_id_cach_tinh_thue(v_data_row[3].ToString());
ip_us.strLY_DO = v_data_row[5].ToString();
}
private DataRow lay_du_lieu_tien_thuong_hsbs_1_nhan_vien(decimal ip_dc_id_nhan_vien)
{
US_GD_THU_NHAP_KHAC v_us_gd_thu_nhap_khac = new US_GD_THU_NHAP_KHAC();
DataSet v_ds_du_lieu_thu_nhap_khac = new DataSet();
v_ds_du_lieu_thu_nhap_khac.Tables.Add();
v_us_gd_thu_nhap_khac.load_du_lieu_bang_luong_1nv_theo_hs_bs(v_ds_du_lieu_thu_nhap_khac
, m_us_v_gd_quy_tien_thuong.datTU_NGAY_XET_THUONG
, m_us_v_gd_quy_tien_thuong.datDEN_NGAY_XET_THUONG
, m_us_v_gd_quy_tien_thuong.dcSO_TIEN
, m_us_v_gd_quy_tien_thuong.strGIAM_TRU_YN
, Convert.ToInt32(m_us_v_gd_quy_tien_thuong.strTHANG)
, Convert.ToInt32(m_us_v_gd_quy_tien_thuong.strNAM)
, ip_dc_id_nhan_vien
, m_us_v_gd_quy_tien_thuong.dcID_CACH_TINH_THUE);
return v_ds_du_lieu_thu_nhap_khac.Tables[0].Rows[0];
}
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();
}
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()
{
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 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++;
}
}
}
}
//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();
}
}