void m_cmd_delete_Click(object sender, EventArgs e)
{
try
{
decimal v_id_gd_chot_bang_luong = CIPConvert.ToDecimal(m_grv_bc_cac_thang_da_chot_bang_luong.GetRowCellValue(m_grv_bc_cac_thang_da_chot_bang_luong.FocusedRowHandle, "ID"));
decimal v_thang_chot_bang_luong = CIPConvert.ToDecimal(m_grv_bc_cac_thang_da_chot_bang_luong.GetRowCellValue(m_grv_bc_cac_thang_da_chot_bang_luong.FocusedRowHandle, "THANG"));
decimal v_nam_chot_bang_luong = CIPConvert.ToDecimal(m_grv_bc_cac_thang_da_chot_bang_luong.GetRowCellValue(m_grv_bc_cac_thang_da_chot_bang_luong.FocusedRowHandle, "NAM"));
if (CHRM_BaseMessages.MsgBox_Confirm("Bạn có chắc chắn muốn bỏ chốt của bảng lương tháng " + v_thang_chot_bang_luong.ToString() + " năm " + v_nam_chot_bang_luong.ToString() + " không?") == true)
{
US_GD_CHOT_BANG_LUONG v_us = new US_GD_CHOT_BANG_LUONG(v_id_gd_chot_bang_luong);
try
{
v_us.BeginTransaction();
v_us.Delete();
v_us.CommitTransaction();
}
catch (Exception v_e)
{
throw v_e;
}
CHRM_BaseMessages.MsgBox_Infor(CONST_ID_MSGBOX.INFOR_DU_LIEU_DA_DUOC_CAP_NHAT);
load_data_2_grid();
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
private void load_data_2_grid()
{
CHRMCommon.make_stt(m_grv_bc_cac_thang_da_chot_bang_luong);
//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, "GD_CHOT_BANG_LUONG");
US_GD_CHOT_BANG_LUONG v_us = new US_GD_CHOT_BANG_LUONG();
DS_GD_CHOT_BANG_LUONG v_ds = new DS_GD_CHOT_BANG_LUONG();
v_us.FillDataset(v_ds);
m_grc_bc_cac_thang_da_chot_bang_luong.DataSource = v_ds.Tables[0];
}
private bool is_da_chot_bang_luong()
{
US_GD_CHOT_BANG_LUONG v_us_dung_chung = new US_GD_CHOT_BANG_LUONG();
return v_us_dung_chung.IsDaChotBangLuongThang(
CIPConvert.ToDecimal(m_txt_thang.EditValue)
, CIPConvert.ToDecimal(m_txt_nam.EditValue));
}
private void insert_gd_bang_luong(US_GD_CHOT_BANG_LUONG ip_us_gd_chot_bang_luong)
{
ip_us_gd_chot_bang_luong.dcTHANG = CIPConvert.ToDecimal(m_txt_thang.Text.Trim());
ip_us_gd_chot_bang_luong.dcNAM = CIPConvert.ToDecimal(m_txt_nam.Text.Trim());
ip_us_gd_chot_bang_luong.strNGUOI_CHOT = CAppContext_201.getCurrentUserName();
ip_us_gd_chot_bang_luong.datNGAY_CHOT = DateTime.Now.Date;
ip_us_gd_chot_bang_luong.Insert();
}
private void chot_bang_luong()
{
if(!is_da_tinh_het_luong_nhan_vien())
{
CHRM_BaseMessages.MsgBox_Infor("Chưa tính toán xong dữ liệu nhân viên");
return;
}
if(m_e_bang_luong_status == e_bang_luong_status.CHUA_TINH)
{
CHRM_BaseMessages.MsgBox_Error(CONST_ID_MSGBOX.ERROR_CHUA_CO_DU_LIEU_DE_THUC_HIEN_THAO_TAC);
return;
}
if(CHRM_BaseMessages.MsgBox_Confirm(
"Bạn có chắc chắn muốn chốt bảng lương tháng "
+ m_txt_thang.Text.Trim()
+ " năm "
+ m_txt_nam.Text.Trim()) == false)
return;
if(!check_gd_chot_bang_luong_is_exist())
{
US_GD_CHOT_BANG_LUONG v_us_gd_chot_bang_luong = new US_GD_CHOT_BANG_LUONG();
insert_gd_bang_luong(v_us_gd_chot_bang_luong);
//them dl vao bang hs bo sung, hs an toan hk
//insert_hs_hs_bs_hs_anhk(CIPConvert.ToDecimal(m_txt_thang.Text.Trim()), CIPConvert.ToDecimal(m_txt_nam.Text.Trim()));
}
insert_hs_hs_bs_hs_anhk(CIPConvert.ToDecimal(m_txt_thang.Text.Trim()), CIPConvert.ToDecimal(m_txt_nam.Text.Trim()));
//else
//{
// DevExpress.XtraEditors.XtraMessageBox.Show("Bảng lương tháng " + m_txt_thang.Text.Trim() + " năm " + m_txt_nam.Text.Trim() + " đã được chốt rồi", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// return;
//}
}
//private void insertLuongNV2RPT(DataRow v_dr_luong_1_nv)
//{
// US_RPT_LUONG v_us = new US_RPT_LUONG();
// DataRow2US(v_dr_luong_1_nv, v_us);
// v_us.Insert();
//}
//private void DataRow2US(DataRow v_dr_luong_1_nv, US_RPT_LUONG v_us)
//{
// v_us.strMA_NV = v_dr_luong_1_nv[RPT_LUONG.MA_NV].ToString();
// v_us.dcAN_CA = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.AN_CA].ToString());
// v_us.dcBHTN = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.BHTN].ToString());
// v_us.dcBHXH = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.BHXH].ToString());
// v_us.dcBHYT = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.BHYT].ToString());
// v_us.dcDOAN_PHI_CD = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.DOAN_PHI_CD].ToString());
// v_us.dcID_NHAN_VIEN = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.ID_NHAN_VIEN].ToString());
// v_us.dcLAM_THEM = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.LAM_THEM].ToString());
// v_us.dcLAM_THEM_LE_TET = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.LAM_THEM_LE_TET].ToString());
// v_us.dcLUONG_CD = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.LUONG_CD].ToString());
// v_us.dcLUONG_KHAC_THUE_10 = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.LUONG_KHAC_THUE_10].ToString());
// v_us.dcLUONG_KHAC_THUE_5 = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.LUONG_KHAC_THUE_5].ToString());
// v_us.dcLUONG_KHAC_THUE_TINH_THEO_LUONG = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.LUONG_KHAC_THUE_TINH_THEO_LUONG].ToString());
// v_us.dcLUONG_NS = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.LUONG_NS].ToString());
// v_us.dcNAM = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.NAM].ToString());
// v_us.dcPHAI_NOP = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.PHAI_NOP].ToString());
// v_us.dcPHU_CAP_TN = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.PHU_CAP_TN].ToString());
// v_us.dcTHANG = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.THANG].ToString());
// v_us.dcTHU_NHAP = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.THU_NHAP].ToString());
// v_us.dcTHUC_LINH = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.THUC_LINH].ToString());
// v_us.dcTHUC_LINH_CUOI_CUNG = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.THUC_LINH_CUOI_CUNG].ToString());
// v_us.dcTHUE = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.THUE].ToString());
// v_us.dcTHUE_TU_LUONG_KHAC_10 = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.THUE_TU_LUONG_KHAC_10].ToString());
// v_us.dcTHUE_TU_LUONG_KHAC_5 = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.THUE_TU_LUONG_KHAC_5].ToString());
// v_us.dcTRUY_LINH = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.TRUY_LINH].ToString());
// v_us.dcTRUY_THU = CIPConvert.ToDecimal(v_dr_luong_1_nv[RPT_LUONG.TRUY_THU].ToString());
//}
//private DataRow get_dr(DataRow ip_dr_luong_nv, DataRow ip_dr_luong, decimal ip_id_nv, int ip_index, int ip_thang, int ip_nam)
//{
// ip_dr_luong_nv[RPT_LUONG.ID] = ip_index;
// ip_dr_luong_nv[RPT_LUONG.ID_NHAN_VIEN] = ip_id_nv;
// ip_dr_luong_nv[RPT_LUONG.THANG] = ip_thang;
// ip_dr_luong_nv[RPT_LUONG.NAM] = ip_nam;
// ip_dr_luong_nv[RPT_LUONG.MA_NV] = ip_dr_luong[RPT_LUONG.MA_NV];
// ip_dr_luong_nv[RPT_LUONG.LUONG_NS] = ip_dr_luong[RPT_LUONG.LUONG_NS];
// ip_dr_luong_nv[RPT_LUONG.LUONG_CD] = ip_dr_luong[RPT_LUONG.LUONG_CD];
// ip_dr_luong_nv[RPT_LUONG.PHU_CAP_TN] = ip_dr_luong[RPT_LUONG.PHU_CAP_TN];
// ip_dr_luong_nv[RPT_LUONG.AN_CA] = ip_dr_luong[RPT_LUONG.AN_CA];
// ip_dr_luong_nv[RPT_LUONG.LAM_THEM] = ip_dr_luong[RPT_LUONG.LAM_THEM];
// ip_dr_luong_nv[RPT_LUONG.LAM_THEM_LE_TET] = ip_dr_luong[RPT_LUONG.LAM_THEM_LE_TET];
// ip_dr_luong_nv[RPT_LUONG.LUONG_KHAC_THUE_5] = ip_dr_luong[RPT_LUONG.LUONG_KHAC_THUE_5];
// ip_dr_luong_nv[RPT_LUONG.LUONG_KHAC_THUE_10] = ip_dr_luong[RPT_LUONG.LUONG_KHAC_THUE_10];
// ip_dr_luong_nv[RPT_LUONG.LUONG_KHAC_THUE_TINH_THEO_LUONG] = ip_dr_luong[RPT_LUONG.LUONG_KHAC_THUE_TINH_THEO_LUONG];
// ip_dr_luong_nv[RPT_LUONG.THU_NHAP] = ip_dr_luong[RPT_LUONG.THU_NHAP];
// ip_dr_luong_nv[RPT_LUONG.BHXH] = ip_dr_luong[RPT_LUONG.BHXH];
// ip_dr_luong_nv[RPT_LUONG.BHYT] = ip_dr_luong[RPT_LUONG.BHYT];
// ip_dr_luong_nv[RPT_LUONG.BHTN] = ip_dr_luong[RPT_LUONG.BHTN];
// ip_dr_luong_nv[RPT_LUONG.DOAN_PHI_CD] = ip_dr_luong[RPT_LUONG.DOAN_PHI_CD];
// ip_dr_luong_nv[RPT_LUONG.THUE] = ip_dr_luong[RPT_LUONG.THUE];
// ip_dr_luong_nv[RPT_LUONG.THUE_TU_LUONG_KHAC_5] = ip_dr_luong[RPT_LUONG.THUE_TU_LUONG_KHAC_5];
// ip_dr_luong_nv[RPT_LUONG.THUE_TU_LUONG_KHAC_10] = ip_dr_luong[RPT_LUONG.THUE_TU_LUONG_KHAC_10];
// ip_dr_luong_nv[RPT_LUONG.PHAI_NOP] = ip_dr_luong[RPT_LUONG.PHAI_NOP];
// ip_dr_luong_nv[RPT_LUONG.THUC_LINH] = ip_dr_luong[RPT_LUONG.THUC_LINH];
// ip_dr_luong_nv[RPT_LUONG.TRUY_LINH] = ip_dr_luong[RPT_LUONG.TRUY_LINH];
// ip_dr_luong_nv[RPT_LUONG.TRUY_THU] = ip_dr_luong[RPT_LUONG.TRUY_THU];
// ip_dr_luong_nv[RPT_LUONG.THUC_LINH_CUOI_CUNG] = ip_dr_luong[RPT_LUONG.THUC_LINH_CUOI_CUNG];
// return ip_dr_luong_nv;
//}
//private DataRow get_luong_1_nhan_vien(decimal ip_dc_id_nhan_vien, int ip_int_thang, int ip_int_nam)
//{
// US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
// DataSet v_ds = new DataSet();
// v_ds.Tables.Add(new DataTable());
// v_us.FillBangLuong(v_ds, ip_dc_id_nhan_vien, ip_int_thang, ip_int_nam);
// DataRow v_dr = v_ds.Tables[0].Rows[0];
// return v_dr;
//}
private bool check_gd_chot_bang_luong_is_exist()
{
try
{
DS_GD_CHOT_BANG_LUONG v_ds = new DS_GD_CHOT_BANG_LUONG();
US_GD_CHOT_BANG_LUONG v_us = new US_GD_CHOT_BANG_LUONG();
v_us.FillDataset(v_ds);
string v_str_filter = "THANG = " + CIPConvert.ToDecimal(m_txt_thang.Text.Trim()) + " AND NAM = " + CIPConvert.ToDecimal(m_txt_nam.Text.Trim());
DataRow[] v_dr = v_ds.GD_CHOT_BANG_LUONG.Select(v_str_filter);
if(v_dr.Count() == 0)
{
return false;
}
else
{
return true;
}
}
catch(Exception v_e)
{
throw v_e;
}
}
public static bool thang_da_chot_bang_luong(decimal ip_dc_thang, decimal ip_dc_nam)
{
DS_GD_CHOT_BANG_LUONG v_ds = new DS_GD_CHOT_BANG_LUONG();
US_GD_CHOT_BANG_LUONG v_us = new US_GD_CHOT_BANG_LUONG();
v_us.FillDataset(v_ds);
string v_str_filter = "THANG = " + ip_dc_thang + " AND NAM = " + ip_dc_nam;
DataRow[] v_dr = v_ds.GD_CHOT_BANG_LUONG.Select(v_str_filter);
if(v_dr.Count() == 0)
{
return false;
}
else
{
return true;
}
}
public static bool thang_da_chot_bang_luong(DateTime ip_dat)
{
DS_GD_CHOT_BANG_LUONG v_ds = new DS_GD_CHOT_BANG_LUONG();
US_GD_CHOT_BANG_LUONG v_us = new US_GD_CHOT_BANG_LUONG();
v_us.FillDataset(v_ds);
string v_str_filter = "THANG = " + ip_dat.Month + " AND NAM = " + ip_dat.Year;
DataRow[] v_dr = v_ds.GD_CHOT_BANG_LUONG.Select(v_str_filter);
if(v_dr.Count() == 0)
{
return false;
}
else
{
return true;
}
}
