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();
}
//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 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 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()
{
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);
}
}
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 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 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);
v_us_gd_hd.BeginTransaction();
v_us_gd_cong_tac.UseTransOfUSObject(v_us_gd_hd);
v_us_gd_cong_tac.Insert();
v_us_gd_hs_lns.UseTransOfUSObject(v_us_gd_hd);
v_us_gd_hs_lns.Insert();
v_us_gd_hd.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;
}
}
