private void load_data_to_grid()
{
US_GD_HE_SO_LNS v_us = new US_GD_HE_SO_LNS();
DataTable v_dt = v_us.FillDatasetBCBienDong(m_dat_tu_ngay.DateTime, m_dat_den_ngay.DateTime);
m_grc.DataSource = v_dt;
CHRMCommon.make_stt(m_grv);
}
public void display_4_update(US_GD_HE_SO_LNS ip_us)
{
m_us = ip_us;
m_e_form_mode = DataEntryFormMode.UpdateDataState;
us_2_form();
Text = "SỬA HỆ SỐ LNS";
ShowDialog();
}
private bool check_lns_dang_su_dung(decimal ip_id_lns)
{
US_GD_HE_SO_LNS v_us = new US_GD_HE_SO_LNS();
DS_GD_HE_SO_LNS v_ds = new DS_GD_HE_SO_LNS();
v_us.FillDataset(v_ds, "where id_he_so_lns =" + ip_id_lns);
if (v_ds.Tables[0].Rows.Count == 0)
return false;
return true;
}
private void delete_gd_he_so_lns(decimal v_id_hop_dong)
{
US_GD_HE_SO_LNS v_us = new US_GD_HE_SO_LNS();
DS_GD_HE_SO_LNS v_ds = new DS_GD_HE_SO_LNS();
v_us.FillDataset(v_ds, "where id_hop_dong = " + v_id_hop_dong);
for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
{
decimal v_id_gd_lns = Convert.ToDecimal(v_ds.Tables[0].Rows[i]["ID"]);
v_us = new US_GD_HE_SO_LNS(v_id_gd_lns);
v_us.Delete();
}
}
private DataTable get_lns_het_han()
{
US_GD_HE_SO_LNS v_us_gd_he_so_lns = new US_GD_HE_SO_LNS();
DataSet v_ds = v_us_gd_he_so_lns.LayDanhSachHetHanLNSTrongThang();
return v_ds.Tables[0];
}
private void form_2_us_gd_hs_lns(US_GD_HE_SO_LNS ip_us)
{
//US_V_GD_QUYET_DINH v_us = new US_V_GD_QUYET_DINH(CIPConvert.ToDecimal(m_sle_chon_quyet_dinh.EditValue));
//ip_us.dcID_HOP_DONG = m_id_gd_hd;
ip_us.dcHE_SO = CIPConvert.ToDecimal(find_hs_lns(CIPConvert.ToDecimal(m_sle_chuc_danh_lns.EditValue), CIPConvert.ToDecimal(m_sle_muc_lns.EditValue)));
//ip_us.dcID_LY_DO_CHINH_SUA =
//so sanh gia tri ngay bat dau, ngay ket thuc vs ngay co hieu luc, ngay het hieu luc cua quyet dinh
if (!m_dat_ngay_ket_thuc_lns.Checked)
{
ip_us.datNGAY_KET_THUC = m_dat_ngay_bat_dau_lns.Value.AddYears(45);
}
else
{
ip_us.datNGAY_KET_THUC = m_dat_ngay_ket_thuc_lns.Value;
}
ip_us.datNGAY_BAT_DAU = m_dat_ngay_bat_dau_lns.Value;
if (m_e_form_mode == DataEntryFormMode.InsertDataState)
{
ip_us.datNGAY_LAP = DateTime.Now.Date;
//Nguoi lap
ip_us.strNGUOI_LAP = CAppContext_201.getCurrentUserName();
}
if (m_e_form_mode == DataEntryFormMode.UpdateDataState)
{
ip_us.datNGAY_SUA = DateTime.Now.Date;
//nguoi sua
ip_us.strNGUOI_SUA = CAppContext_201.getCurrentUserName();
}
}
private void save_data()
{
US_GD_HS_LNS_LCD v_us_gd_hs_lns_lcd = new US_GD_HS_LNS_LCD();
US_GD_HE_SO_LNS v_us_gd_hs_lns = new US_GD_HE_SO_LNS();
US_GD_LUONG_CHE_DO v_us_gd_lcd = new US_GD_LUONG_CHE_DO();
form_2_us_gd_hs_lns_lcd(v_us_gd_hs_lns_lcd);
form_2_us_gd_hs_lns(v_us_gd_hs_lns);
form_2_us_gd_lcd(v_us_gd_lcd);
try
{
switch (m_e_form_mode)
{
case DataEntryFormMode.InsertDataState:
//Cho gd_hs_lns_lcd da xoa = Y
cho_gd_hs_lns_lcd_da_co_da_xoa_Y();
//insert gd_hs_lns_lcd
v_us_gd_hs_lns_lcd.BeginTransaction();
v_us_gd_hs_lns_lcd.Insert();
v_us_gd_hs_lns_lcd.CommitTransaction();
//insert gd_hs_lns
cho_gd_hs_lns_da_co_da_xoa_Y();
v_us_gd_hs_lns.BeginTransaction();
v_us_gd_hs_lns.Insert();
v_us_gd_hs_lns.CommitTransaction();
//insert gd_lcd
cho_gd_lcd_da_co_da_xoa_Y();
v_us_gd_lcd.BeginTransaction();
v_us_gd_lcd.Insert();
v_us_gd_lcd.CommitTransaction();
break;
case DataEntryFormMode.UpdateDataState:
break;
default:
break;
}
}
catch (Exception v_e)
{
v_us_gd_hs_lns.Rollback();
v_us_gd_lcd.Rollback();
v_us_gd_hs_lns_lcd.Rollback();
CSystemLog_301.ExceptionHandle(v_e);
}
}
//Load data
private void load_data_2_grid_lns()
{
US_GD_HE_SO_LNS v_us = new US_GD_HE_SO_LNS();
m_grc.DataSource = v_us.LayDanhSachHeSoLNS(get_option_filter(), get_thang(), get_nam());
}
private decimal find_id_gd_hs_lns(decimal ip_dc_id_gd_hd)
{
try
{
US_GD_HE_SO_LNS v_us = new US_GD_HE_SO_LNS();
DS_GD_HE_SO_LNS v_ds = new DS_GD_HE_SO_LNS();
v_us.FillDataset(v_ds);
string v_str_filter = "ID_HOP_DONG = " + ip_dc_id_gd_hd + " AND DA_XOA = 'N'";
DataRow[] v_dr = v_ds.GD_HE_SO_LNS.Select(v_str_filter);
if (v_dr.Count() == 0)
{
return -1;
}
else
{
return CIPConvert.ToDecimal(v_dr.First()["ID"].ToString());
}
}
catch (Exception v_e)
{
throw v_e;
}
}
private void grid_to_us_gd_cong_tac(US_GD_HE_SO_LNS v_us_gd_ct, DataRow data)
{
v_us_gd_ct.dcID_NHAN_VIEN = find_id_nv_by_ma_nv(data[ExcelLNS.MA_NHAN_VIEN].ToString());
v_us_gd_ct.dcID_HE_SO_LNS = find_id_hs_lns_by_ma_muc(data[ExcelLNS.MA_LNS].ToString(), data[ExcelLNS.MUC_LNS].ToString());
v_us_gd_ct.dcHE_SO = find_he_so_lns_by_id(v_us_gd_ct.dcID_HE_SO_LNS);
v_us_gd_ct.strNGUOI_LAP = CAppContext_201.getCurrentUserName();
v_us_gd_ct.datNGAY_BAT_DAU = WinFormControls.FormatPostingDate(data[ExcelLNS.NGAY_BAT_DAU].ToString());
if(String.IsNullOrEmpty(data[ExcelLNS.NGAY_KET_THUC].ToString()))
{
v_us_gd_ct.SetNGAY_KET_THUCNull();
}
else
{
v_us_gd_ct.datNGAY_KET_THUC = WinFormControls.FormatPostingDate(data[ExcelLNS.NGAY_KET_THUC].ToString());
}
v_us_gd_ct.datNGAY_LAP = DateTime.Now.Date;
}
private void load_data_2_grv_k_hs_lns()
{
US_GD_HE_SO_LNS v_us = new US_GD_HE_SO_LNS();
m_grc_khs.DataSource = v_us.LayDanhSachNhanVienChuaCoLNS();
}
//Save
private void save_insert_lns()
{
try
{
m_us_save = new US_GD_HE_SO_LNS();
// m_us_save.dcID_LY_DO_CHINH_SUA = Convert.ToDecimal(m_le_ly_do_chinh_sua.EditValue);
m_us_save.datNGAY_BAT_DAU = m_dat_tu_ngay.DateTime.Date;
m_us_save.datNGAY_KET_THUC = m_dat_den_ngay.DateTime.Date;
m_us_save.datNGAY_LAP = DateTime.Now.Date;
//m_us_save.dcID_HS_LNS_LCD = ExecuteFuntion.GetID_GD_HS_LNS_LCDByID_HOP_DONG(Convert.ToDecimal(m_sle_hop_dong.EditValue));
m_us_save.dcHE_SO = Convert.ToDecimal(m_txt_gia_tri_thay_doi.EditValue);
//m_us_save.strDA_XOA = "N";
m_us_save.strGHI_CHU = m_txt_ghi_chu.Text;
m_us_save.strNGUOI_LAP = CAppContext_201.getCurrentUserName();
m_us_save.BeginTransaction();
//m_us_save.SetHetHieuLucTruocKhiThemMoi(m_us_save.dcID_HS_LNS_LCD, m_dat_tu_ngay.DateTime.AddDays(-1).Date);
m_us_save.Insert();
m_us_save.CommitTransaction();
XtraMessageBox.Show("Thêm mới dữ liệu thành công!", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Information);
Close();
}
catch(Exception)
{
if(m_us_save.is_having_transaction())
{
m_us_save.Rollback();
}
throw;
}
}
private bool check_thoi_gian_he_so_lns_Insert(DataRow ip_dr)
{
//Hợp đồng hợp lệ khi trong một khoảng thời gian chỉ có một hợp đồng
US_GD_HE_SO_LNS v_us = new US_GD_HE_SO_LNS();
var v_dc_id_nhan_vien = ExecuteFuntion.LayNhanVienID(ip_dr[ExcelLNS.MA_NHAN_VIEN].ToString());
var v_dat_ngay_bat_dau = Convert.ToDateTime(ip_dr[ExcelLNS.NGAY_BAT_DAU]).Date;
var v_dat_ngay_ket_thuc = ip_dr[ExcelLNS.NGAY_KET_THUC] == DBNull.Value ? new DateTime(2100, 01, 01).Date : Convert.ToDateTime(ip_dr[ExcelLNS.NGAY_KET_THUC]);
var v_bool_hop_le = v_us.KiemTraThoiGianHeSoLNSHopLeForInsert(v_dc_id_nhan_vien, v_dat_ngay_bat_dau, v_dat_ngay_ket_thuc);
if(!v_bool_hop_le)
{
XtraMessageBox.Show("Thời gian hiệu lực hệ số LNS của nhân viên " + ip_dr[ExcelLNS.MA_NHAN_VIEN].ToString() + " không hợp lệ " +
"do đã có hiệu lực hệ số LNS khác tồn tại trong khoảng thời gian này!", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
return v_bool_hop_le;
}
private void form_2_us_gd_hs_lns(US_GD_HE_SO_LNS ip_us)
{
try
{
//ip_us.dcID_HOP_DONG = find_id_gd_hd(CIPConvert.ToDecimal(m_sle_chon_nhan_vien.EditValue));
ip_us.dcHE_SO = CIPConvert.ToDecimal(find_hs_lns(CIPConvert.ToDecimal(m_sle_chuc_danh_lns.EditValue), CIPConvert.ToDecimal(m_sle_muc_lns.EditValue)));
//ip_us.dcID_LY_DO_CHINH_SUA =
ip_us.datNGAY_BAT_DAU = m_dat_ngay_bat_dau.Value.Date;
if (m_dat_ngay_ket_thuc.Checked == true)
{
ip_us.datNGAY_KET_THUC = m_dat_ngay_ket_thuc.Value.Date;
}
if (m_e_form_mode == DataEntryFormMode.InsertDataState)
{
ip_us.datNGAY_LAP = DateTime.Now.Date;
//Nguoi lap
ip_us.strNGUOI_LAP = CAppContext_201.getCurrentUserName();
}
if (m_e_form_mode == DataEntryFormMode.UpdateDataState)
{
ip_us.datNGAY_SUA = DateTime.Now.Date;
//nguoi sua
ip_us.strNGUOI_SUA = CAppContext_201.getCurrentUserName();
}
}
catch (Exception v_e)
{
throw v_e;
}
}
private void grid_to_us_gd_lns(US_GD_HE_SO_LNS v_us_gd_hs_lns, DataRow data)
{
v_us_gd_hs_lns.dcID_NHAN_VIEN = find_id_nv_by_ma_nv(data["MA_NHAN_VIEN"].ToString());
if (!String.IsNullOrEmpty(data["MA_CHUC_DANH_LNS"].ToString()) & !String.IsNullOrEmpty(data["MA_MUC_LUONG_NS"].ToString()))
{
v_us_gd_hs_lns.dcID_HE_SO_LNS = find_id_hs_lns_by_ma_muc(data["MA_CHUC_DANH_LNS"].ToString(), data["MA_MUC_LUONG_NS"].ToString());
v_us_gd_hs_lns.dcHE_SO = find_he_so_lns_by_id(v_us_gd_hs_lns.dcID_HE_SO_LNS);
}
v_us_gd_hs_lns.strNGUOI_LAP = CAppContext_201.getCurrentUserName();
v_us_gd_hs_lns.datNGAY_BAT_DAU = WinFormControls.FormatPostingDate(data["NGAY_BAT_DAU"].ToString());
if (String.IsNullOrEmpty(data["NGAY_KET_THUC"].ToString()))
{
v_us_gd_hs_lns.datNGAY_KET_THUC = v_us_gd_hs_lns.datNGAY_BAT_DAU.AddYears(45);
}
else
{
v_us_gd_hs_lns.datNGAY_KET_THUC = WinFormControls.FormatPostingDate(data["NGAY_KET_THUC"].ToString());
}
v_us_gd_hs_lns.datNGAY_LAP = DateTime.Now.Date;
}
private void cho_gd_hs_lns_da_xoa_Y()
{
decimal v_id_gd_hs_lns = 0;
v_id_gd_hs_lns = find_id_gd_hs_lns(m_id_gd_hd);
US_GD_HE_SO_LNS v_us = new US_GD_HE_SO_LNS(v_id_gd_hs_lns);
v_us.datNGAY_SUA = DateTime.Now.Date;
//nguoi sua
v_us.BeginTransaction();
v_us.Update();
v_us.CommitTransaction();
}
private void save_data()
{
US_GD_HS_LNS_LCD v_us_gd_hs_lns_lcd = new US_GD_HS_LNS_LCD();
US_GD_HE_SO_LNS v_us_gd_hs_lns = new US_GD_HE_SO_LNS();
US_GD_LUONG_CHE_DO v_us_gd_lcd = new US_GD_LUONG_CHE_DO();
US_GD_TRANG_THAI_LAO_DONG v_us_gd_trang_thai_lao_dong = new US_GD_TRANG_THAI_LAO_DONG();
US_GD_HOP_DONG v_us_gd_hd = new US_GD_HOP_DONG();
form_2_us_gd_hop_dong(v_us_gd_hd);
US_GD_HOP_DONG v_us = new US_GD_HOP_DONG();
switch (m_e_form_mode)
{
case DataEntryFormMode.UpdateDataState:
v_us_gd_hd.BeginTransaction();
v_us_gd_hd.dcID = CIPConvert.ToDecimal(m_grv_lap_hd.GetRowCellValue(m_grv_lap_hd.FocusedRowHandle, "ID"));
v_us_gd_hd.Update();
v_us_gd_hd.CommitTransaction();
//
form_2_us_gd_hs_lns_lcd(v_us_gd_hs_lns_lcd);
v_us_gd_hs_lns_lcd.BeginTransaction();
v_us_gd_hs_lns_lcd.dcID = find_id_gd_lns_lcd(CIPConvert.ToDecimal(m_grv_lap_hd.GetRowCellValue(m_grv_lap_hd.FocusedRowHandle, "ID")));
v_us_gd_hs_lns_lcd.Update();
v_us_gd_hs_lns_lcd.CommitTransaction();
break;
case DataEntryFormMode.InsertDataState:
v_us.lap_hop_dong_moi_cho_nhan_vien(CIPConvert.ToDecimal(m_sle_chon_nhan_vien.EditValue)
, CIPConvert.ToDecimal(m_sle_loai_hop_dong.EditValue)
, m_txt_ma_hd.Text.Trim()
, m_dat_ngay_bat_dau.Value.Date
, m_dat_ngay_ket_thuc.Value.Date
, m_dat_ngay_ky.Value.Date
, DateTime.Now.Date
, CAppContext_201.getCurrentUserName()
, "N"
, CIPConvert.ToDecimal(m_sle_chuc_danh_lcd.EditValue)
, CIPConvert.ToDecimal(m_sle_muc_lcd.EditValue)
, CIPConvert.ToDecimal(m_sle_chuc_danh_lns.EditValue)
, CIPConvert.ToDecimal(m_sle_muc_lns.EditValue)
, ref op_str_mess);
break;
case DataEntryFormMode.ViewDataState:
break;
case DataEntryFormMode.SelectDataState:
break;
default:
break;
}
//US_GD_HS_LNS_LCD v_us_gd_hs_lns_lcd = new US_GD_HS_LNS_LCD();
//US_GD_HE_SO_LNS v_us_gd_hs_lns = new US_GD_HE_SO_LNS();
//US_GD_LUONG_CHE_DO v_us_gd_lcd = new US_GD_LUONG_CHE_DO();
//US_GD_TRANG_THAI_LAO_DONG v_us_gd_trang_thai_lao_dong = new US_GD_TRANG_THAI_LAO_DONG();
//US_GD_HOP_DONG v_us_gd_hd = new US_GD_HOP_DONG();
//form_2_us_gd_hop_dong(v_us_gd_hd);
//try
//{
// switch (m_e_form_mode)
// {
// case DataEntryFormMode.InsertDataState:
// if (m_id_gd_hd != -1)
// {
// cho_hop_dong_da_co_ve_trang_thai_delete_Y();
// cho_gd_hs_lns_lcd_da_xoa_Y();
// cho_gd_hs_lns_da_xoa_Y();
// cho_gd_lcd_da_xoa_Y();
// }
// //lap hop dong moi
// v_us_gd_hd.BeginTransaction();
// v_us_gd_hd.Insert();
// v_us_gd_hd.CommitTransaction();
// //insert gd_hs_lns_lcd
// form_2_us_gd_hs_lns_lcd(v_us_gd_hs_lns_lcd);
// v_us_gd_hs_lns_lcd.BeginTransaction();
// v_us_gd_hs_lns_lcd.Insert();
// v_us_gd_hs_lns_lcd.CommitTransaction();
// //insert gd_hs_lns
// form_2_us_gd_hs_lns(v_us_gd_hs_lns);
// v_us_gd_hs_lns.BeginTransaction();
// v_us_gd_hs_lns.Insert();
// v_us_gd_hs_lns.CommitTransaction();
// //insert gd_lcd
// form_2_us_gd_lcd(v_us_gd_lcd);
// v_us_gd_lcd.BeginTransaction();
// v_us_gd_lcd.Insert();
// v_us_gd_lcd.CommitTransaction();
// //insert gd_trang_thai_ld
// decimal v_id_gd_trang_thai_lao_dong_da_co = 0;
// v_id_gd_trang_thai_lao_dong_da_co = find_id_trang_thai_lao_dong_da_co(decimal.Parse(m_sle_chon_nhan_vien.EditValue.ToString())); //sai o day
// if (v_id_gd_trang_thai_lao_dong_da_co == -1)
// {
// form_2_us_gd_trang_thai_lao_dong(v_us_gd_trang_thai_lao_dong);
// v_us_gd_trang_thai_lao_dong.BeginTransaction();
// v_us_gd_trang_thai_lao_dong.Insert();
// v_us_gd_trang_thai_lao_dong.CommitTransaction();
// }
// break;
// case DataEntryFormMode.UpdateDataState:
// v_us_gd_hd.BeginTransaction();
// v_us_gd_hd.dcID = CIPConvert.ToDecimal(m_grv_lap_hd.GetRowCellValue(m_grv_lap_hd.FocusedRowHandle, "ID"));
// v_us_gd_hd.Update();
// v_us_gd_hd.CommitTransaction();
// //
// form_2_us_gd_hs_lns_lcd(v_us_gd_hs_lns_lcd);
// v_us_gd_hs_lns_lcd.BeginTransaction();
// v_us_gd_hs_lns_lcd.dcID = find_id_gd_lns_lcd(CIPConvert.ToDecimal(m_grv_lap_hd.GetRowCellValue(m_grv_lap_hd.FocusedRowHandle, "ID")));
// v_us_gd_hs_lns_lcd.Update();
// v_us_gd_hs_lns_lcd.CommitTransaction();
// break;
// default:
// break;
// }
//}
//catch (Exception v_e)
//{
// throw v_e;
//}
}
private void gan_du_lieu_cho_us_gd_lns(DataRow dataRow)
{
US_GD_HE_SO_LNS v_us = new US_GD_HE_SO_LNS();
//v_us.dcID_HOP_DONG = m_dc_id_hop_dong_moi_tao;
if (dataRow["NGAY_BAT_DAU"].ToString() != "")
if ((dataRow["NGAY_BAT_DAU"].ToString() != ""))
v_us.datNGAY_BAT_DAU = DateTime.FromOADate(Convert.ToDouble(dataRow["NGAY_BAT_DAU"]));
if (dataRow["NGAY_KET_THUC"].ToString() != "")
if ((dataRow["NGAY_KET_THUC"].ToString() != ""))
v_us.datNGAY_KET_THUC = DateTime.FromOADate(Convert.ToDouble(dataRow["NGAY_KET_THUC"]));
v_us.dcHE_SO = find_lns(CIPConvert.ToDecimal(dataRow["CHUC_DANH_LNS"].ToString()), CIPConvert.ToDecimal(dataRow["MUC_LUONG_NS"].ToString()));
v_us.datNGAY_LAP = DateTime.Now.Date;
v_us.strNGUOI_LAP = CAppContext_201.getCurrentUserName();
v_us.Insert();
}
private void M_cmd_delete_Click(object sender, EventArgs e)
{
try
{
if(m_grv.FocusedRowHandle < 0)
{
XtraMessageBox.Show("Bạn cần chọn dòng dữ liệu để xóa!", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
DialogResult v_confirm = default(DialogResult);
v_confirm = XtraMessageBox.Show("BẠN CÓ THỰC SỰ MUỐN XÓA LƯƠNG NĂNG SUẤT CỦA NHÂN VIÊN NÀY ?", "XÁC NHẬN LẠI", MessageBoxButtons.YesNo, MessageBoxIcon.Error);
if(v_confirm == DialogResult.Yes)
{
DataRow v_dr = m_grv.GetDataRow(m_grv.FocusedRowHandle);
US_GD_HE_SO_LNS v_us = new US_GD_HE_SO_LNS(Convert.ToDecimal(v_dr["ID"].ToString()));
v_us.Delete();
load_data_2_grid_lns();
XtraMessageBox.Show("Đã xóa thành công", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch(Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
private void update_click()
{
if(m_grv.FocusedRowHandle < 0)
{
XtraMessageBox.Show("Bạn cần chọn dòng dữ liệu để sửa!", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
DataRow v_dr = m_grv.GetDataRow(m_grv.FocusedRowHandle);
US_GD_HE_SO_LNS v_us = new US_GD_HE_SO_LNS(Convert.ToDecimal(v_dr["ID"].ToString()));
f299_chinh_lns_nhan_vien_de v_frm = new f299_chinh_lns_nhan_vien_de();
v_frm.display_4_update(v_us);
load_data_2_grid_lns();
focus_row(v_us.dcID_NHAN_VIEN);
}
private void save_data()
{
US_GD_HOP_DONG v_us_gd_hd = new US_GD_HOP_DONG();
US_GD_CONG_TAC v_us_gd_cong_tac = new US_GD_CONG_TAC();
US_GD_HE_SO_LNS v_us_gd_hs_lns = new US_GD_HE_SO_LNS();
try
{
for (int i = 0; i < m_grv_hop_dong.RowCount; i++)
{
var data = m_grv_hop_dong.GetDataRow(i);
//
grid_to_us_gd_hop_dong(v_us_gd_hd, data);
grid_to_us_gd_cong_tac(v_us_gd_cong_tac, data);
grid_to_us_gd_lns(v_us_gd_hs_lns, data);
//decimal v_id_hop_dong = get_id_hop_dong_hien_tai(v_us_gd_hd.dcID_NHAN_VIEN.ToString());
//
v_us_gd_hd.BeginTransaction();
//if (v_id_hop_dong != 0)
//{
// ket_thuc_hop_dong_cu(v_id_hop_dong, v_us_gd_hd.datNGAY_BAT_DAU);
//}
v_us_gd_cong_tac.UseTransOfUSObject(v_us_gd_hd);
//v_us_gd_cong_tac.CapNhatHetHieuLucCongTac(v_us_gd_hd.dcID_NHAN_VIEN, v_us_gd_hd.datNGAY_BAT_DAU);
v_us_gd_hs_lns.UseTransOfUSObject(v_us_gd_hd);
//v_us_gd_hs_lns.KetThucLuongNangSuatNhanVien(v_us_gd_hd.dcID_NHAN_VIEN, v_us_gd_hd.datNGAY_BAT_DAU);
v_us_gd_hs_lns.Insert();
v_us_gd_hd.Insert();
v_us_gd_cong_tac.Insert();
v_us_gd_hd.CommitTransaction();
}
CHRM_BaseMessages.MsgBox_Infor("Đã lưu dữu liệu thành công");
}
catch (Exception)
{
if (v_us_gd_hd.is_having_transaction())
{
v_us_gd_hd.Rollback();
}
throw;
}
}
private void save_data_hs_lns()
{
US_GD_HE_SO_LNS v_us_hs_lns = new US_GD_HE_SO_LNS();
form_2_us_gd_hs_lns(v_us_hs_lns);
switch (m_e_form_mode)
{
case DataEntryFormMode.InsertDataState:
//delete us_gd_hs_lns
cho_us_gd_hs_lns_da_xoa_Y();
//insert us_gd_hs_lns
v_us_hs_lns.BeginTransaction();
v_us_hs_lns.Insert();
v_us_hs_lns.CommitTransaction();
break;
case DataEntryFormMode.UpdateDataState:
break;
default:
break;
}
}
private void setup_for_update_lns(decimal ip_dc_id_gd_he_so_lns)
{
m_e_loai_form = e_loai_form.UPDATE_LNS;
US_GD_HE_SO_LNS v_us_hs_lns = new US_GD_HE_SO_LNS(ip_dc_id_gd_he_so_lns);
US_GD_HS_LNS_LCD v_us_hs_lns_lcd = new US_GD_HS_LNS_LCD();//new US_GD_HS_LNS_LCD(v_us_hs_lns.dcID_HS_LNS_LCD);
m_us_save.dcID = ip_dc_id_gd_he_so_lns;
m_sle_hop_dong.EditValue = v_us_hs_lns_lcd.dcID_HOP_DONG;
m_txt_gia_tri_thay_doi.EditValue = v_us_hs_lns.dcHE_SO;
m_dat_tu_ngay.DateTime = v_us_hs_lns.datNGAY_BAT_DAU;
m_dat_den_ngay.DateTime = v_us_hs_lns.datNGAY_KET_THUC;
//m_le_ly_do_chinh_sua.EditValue = v_us_hs_lns.dcID_LY_DO_CHINH_SUA;
m_txt_ghi_chu.Text = v_us_hs_lns.strGHI_CHU;
Text = "F391 - Cập nhật chỉnh sửa hệ số LNS";
US_GD_HOP_DONG v_us_hd = new US_GD_HOP_DONG();
decimal op_he_so = 0;
string op_ma = "";
string op_muc = "";
v_us_hd.LayMaMucLNSCuaHopDong(Convert.ToDecimal(m_sle_hop_dong.EditValue), out op_he_so, out op_ma, out op_muc);
m_txt_ma.Text = op_ma;
m_txt_muc.Text = op_muc;
m_txt_gia_tri_ma_muc.EditValue = op_he_so;
m_sle_hop_dong.ReadOnly = true;
}
private void cho_us_gd_hs_lns_da_xoa_Y()
{
US_GD_HE_SO_LNS v_us = new US_GD_HE_SO_LNS(m_id_gd_hs_lns_hien_tai);
DateTime v_dat_ngay_ket_thuc_hs_lns_hien_tai = m_dat_ngay_bat_dau_lns.Value.AddDays(-1);
v_us.dcID = m_id_gd_hs_lns_hien_tai;
v_us.datNGAY_KET_THUC = v_dat_ngay_ket_thuc_hs_lns_hien_tai.Date;
v_us.datNGAY_SUA = DateTime.Now.Date;
v_us.BeginTransaction();
v_us.Update();
v_us.CommitTransaction();
}
private bool check_thoi_gian_voi_luong_cung_Insert(DataRow ip_dr)
{
US_GD_HE_SO_LNS v_us_check = new US_GD_HE_SO_LNS();
decimal v_dc_id_nhan_vien = find_id_nv_by_ma_nv(ip_dr[ExcelLNS.MA_NHAN_VIEN].ToString());
var v_dat_ngay_bat_dau = Convert.ToDateTime(ip_dr[ExcelLNS.NGAY_BAT_DAU]).Date;
var v_dat_ngay_ket_thuc = ip_dr[ExcelLNS.NGAY_KET_THUC] == DBNull.Value ? new DateTime(2100, 01, 01).Date : Convert.ToDateTime(ip_dr[ExcelLNS.NGAY_KET_THUC]);
if(!v_us_check.KiemTraThoiGianVoiLuongCungHopLeForInsert(v_dc_id_nhan_vien, v_dat_ngay_bat_dau, v_dat_ngay_ket_thuc))
{
string v_str_error = "Trong hệ thống, đã tồn tại bản ghi LƯƠNG CỨNG của nhân viên "+ip_dr[ExcelLNS.MA_NHAN_VIEN].ToString()+" có hiệu lực trong khoảng thời gian này rồi!!";
XtraMessageBox.Show(v_str_error, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
return false;
}
return true;
}
private void form_2_us_gd_hs_lns(US_GD_HE_SO_LNS ip_us)
{
//ip_us.dcID_HOP_DONG = m_id_gd_hd;
ip_us.dcHE_SO = CIPConvert.ToDecimal(m_txt_hs_lns.Text.Trim()); ;
//ip_us.dcID_LY_DO_CHINH_SUA = CIPConvert.ToDecimal(m_sle_chon_ly_do_chinh_sua_hs_lns.EditValue);
ip_us.datNGAY_BAT_DAU = m_dat_ngay_bat_dau_lns.Value.Date;
if (m_dat_ngay_ket_thuc_lns.Checked == false)
{
ip_us.datNGAY_KET_THUC = m_dat_ngay_bat_dau_lns.Value.AddYears(45);
}
else
{
ip_us.datNGAY_KET_THUC = m_dat_ngay_ket_thuc_lns.Value.Date;
}
ip_us.strGHI_CHU = m_txt_ghi_chu_hs_lns.Text;
if (m_e_form_mode == DataEntryFormMode.InsertDataState)
{
ip_us.datNGAY_LAP = DateTime.Now.Date;
//Nguoi lap
ip_us.strNGUOI_LAP = CAppContext_201.getCurrentUserName();
}
if (m_e_form_mode == DataEntryFormMode.UpdateDataState)
{
ip_us.datNGAY_SUA = DateTime.Now.Date;
//nguoi sua
ip_us.strNGUOI_SUA = CAppContext_201.getCurrentUserName();
}
}
private void save_data()
{
if(m_grv_cong_tac.RowCount < 1)
{
XtraMessageBox.Show("Chưa có dữ liệu để lưu!", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if(!check_all_is_ok())
{
return;
}
SplashScreenManager.ShowForm(this, typeof(SplashScreen1), true, true, false);
US_GD_HE_SO_LNS v_us_gd_ct = new US_GD_HE_SO_LNS();
try
{
v_us_gd_ct.BeginTransaction();
for(int i = 0; i < m_grv_cong_tac.RowCount; i++)
{
v_us_gd_ct.ClearAllFields();
var data = m_grv_cong_tac.GetDataRow(i);
grid_to_us_gd_cong_tac(v_us_gd_ct, data);
v_us_gd_ct.Insert();
SplashScreenManager.Default.SendCommand(SplashScreen1.SplashScreenCommand.SetProgress, (int)((decimal)i / (decimal)m_grv_cong_tac.RowCount * 100));
}
v_us_gd_ct.CommitTransaction();
CHRM_BaseMessages.MsgBox_Infor("Đã lưu dữ liệu thành công");
}
catch(Exception)
{
if(v_us_gd_ct.is_having_transaction())
{
v_us_gd_ct.Rollback();
}
throw;
}
finally
{
SplashScreenManager.CloseForm(false);
}
}
private void load_data_hs_lns_lcd_now_2_form()
{
//thong tin lns
m_sle_chuc_danh_lns.EditValue = m_id_ma_hs_lns_hien_tai;
m_sle_muc_lns.EditValue = m_id_muc_hs_lns_hien_tai;
US_GD_HE_SO_LNS v_us_gd_hs_lns = new US_GD_HE_SO_LNS(m_id_gd_hs_lns_hien_tai);
m_txt_hs_lns.Text = v_us_gd_hs_lns.dcHE_SO.ToString();
// m_sle_chon_ly_do_chinh_sua_hs_lns.EditValue = v_us_gd_hs_lns.dcID_LY_DO_CHINH_SUA;
m_txt_ghi_chu_hs_lns.Text = v_us_gd_hs_lns.strGHI_CHU.ToString();
m_dat_ngay_bat_dau_lns.Value = v_us_gd_hs_lns.datNGAY_BAT_DAU;
m_dat_ngay_ket_thuc_lns.Value = v_us_gd_hs_lns.datNGAY_KET_THUC;
//Thong tin lcd
m_sle_chuc_danh_lcd.EditValue = m_id_ma_lcd_hien_tai;
m_sle_muc_lcd.EditValue = m_id_muc_lcd_hien_tai;
US_GD_LUONG_CHE_DO v_us_gd_lcd = new US_GD_LUONG_CHE_DO(m_id_gd_lcd_hien_tai);
m_txt_so_tien_lcd.Text = string.Format("{0:#,##0}", v_us_gd_lcd.dcSO_TIEN);
m_sle_chon_ly_do_chinh_sua_so_tien_lcd.EditValue = v_us_gd_lcd.dcID_LY_DO_CHINH_SUA;
m_txt_ghi_chu_lcd.Text = v_us_gd_lcd.strGHI_CHU.ToString();
m_dat_ngay_bat_dau_lcd.Value = v_us_gd_lcd.datNGAY_BAT_DAU;
m_dat_ngay_ket_thuc_lcd.Value = v_us_gd_lcd.datNGAY_KET_THUC;
}
private void cap_nhat_gd_he_so_lns()
{
if(m_txt_he_so_lns.EditValue == null)
{
return;
}
US_GD_HE_SO_LNS v_us = new US_GD_HE_SO_LNS();
v_us.dcID_NHAN_VIEN = CIPConvert.ToDecimal(m_sle_chon_nhan_vien.EditValue);
v_us.datNGAY_BAT_DAU = m_dat_ngay_bat_dau.DateTime.Date;
if (m_dat_ngay_ket_thuc.EditValue != null)
v_us.datNGAY_KET_THUC = m_dat_ngay_ket_thuc.DateTime.Date;
v_us.datNGAY_LAP = DateTime.Now.Date;
v_us.strNGUOI_LAP = CAppContext_201.getCurrentUserName();
v_us.dcHE_SO = Convert.ToDecimal(m_txt_he_so_lns.Text);
v_us.dcID_HE_SO_LNS = find_id_hs_lns();
v_us.UseTransOfUSObject(m_us_gd_hd);
v_us.KetThucLuongNangSuatNhanVien(v_us.dcID_NHAN_VIEN, m_dat_ngay_bat_dau.DateTime.Date);
v_us.Insert();
//v_us.CommitTransaction();
}
private void cho_gd_hs_lns_da_co_da_xoa_Y()
{
US_GD_HE_SO_LNS v_us = new US_GD_HE_SO_LNS(m_id_gd_hs_lns);
v_us.datNGAY_KET_THUC = m_dat_ngay_bat_dau_lns.Value.AddDays(-1);
try
{
v_us.BeginTransaction();
v_us.Update();
v_us.CommitTransaction();
}
catch (Exception v_e)
{
throw v_e;
}
}
