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; } }