private bool check_ma_muc_da_ton_tai()
{
US_DM_LUONG_CHE_DO v_us = new US_DM_LUONG_CHE_DO();
DS_DM_LUONG_CHE_DO v_ds = new DS_DM_LUONG_CHE_DO();
decimal v_id_ma = CIPConvert.ToDecimal(m_sle_ma_lcd.EditValue);
decimal v_id_muc = CIPConvert.ToDecimal(m_sle_muc_lcd.EditValue);
v_us.FillDataset(v_ds, "where id_ma_lcd = " + v_id_ma + "and id_muc_lcd =" + v_id_muc);
if ((m_us.dcID_MA_LCD != v_id_ma || m_us.dcID_MUC_LCD != v_id_muc) && v_ds.Tables[0].Rows.Count !=0)
{
return true;
}
return false;
}
public void display_4_update(US_DM_LUONG_CHE_DO ip_us)
{
this.Text = "F106 - Sửa loại lương chế độ";
m_lbl_header.Text = "SỬA LOẠI LƯƠNG CHẾ ĐỘ";
m_e_form_mode = DataEntryFormMode.UpdateDataState;
m_id_dm_luong_che_do_4_update = ip_us.dcID;
m_sle_ma_lcd.EditValue = ip_us.dcID_MA_LCD.ToString();
m_sle_muc_lcd.EditValue = ip_us.dcID_MUC_LCD.ToString();
m_txt_so_tien.Text = ip_us.dcSO_TIEN.ToString();
m_us = ip_us;
//CHRMCommon.format_text_2_money(m_txt_so_tien);
this.CenterToScreen();
this.ShowDialog();
}
private DataRow get_luong_cd_theo_ma_muc()
{
if (m_sle_ma_lcd.EditValue == null || m_sle_muc_lcd.EditValue == null)
return null;
else
{
US_DM_LUONG_CHE_DO v_us = new US_DM_LUONG_CHE_DO();
DS_DM_LUONG_CHE_DO v_ds = new DS_DM_LUONG_CHE_DO();
v_us.FillDatasetTheoIDMaMuc(v_ds, m_sle_ma_lcd.EditValue.ToString(), m_sle_muc_lcd.EditValue.ToString());
if (v_ds.Tables[0].Rows.Count == 0)
return null;
else return v_ds.Tables[0].Rows[0];
}
}
private decimal find_so_tien_lcd(decimal id_lcd)
{
US_DM_LUONG_CHE_DO v_us = new US_DM_LUONG_CHE_DO(id_lcd);
return v_us.dcSO_TIEN;
}
private decimal find_id_lcd_by_ma_lcd(string ma_lcd, string muc_lcd)
{
try
{
decimal id_ma_lcd = (from DataRow dr in m_dt_ma_lcd.Rows
where (string)dr["MA_TU_DIEN"] == ma_lcd
select (decimal)dr["ID"]).FirstOrDefault();
decimal id_muc_lcd = (from DataRow dr in m_dt_muc_lcd.Rows
where (string)dr["MA_TU_DIEN"] == muc_lcd
select (decimal)dr["ID"]).FirstOrDefault();
US_DM_LUONG_CHE_DO v_us = new US_DM_LUONG_CHE_DO();
DS_DM_LUONG_CHE_DO v_ds = new DS_DM_LUONG_CHE_DO();
v_us.FillDataset(v_ds);
decimal id_lcd = (from DataRow dr in v_ds.Tables[0].Rows
where (decimal)dr["ID_MA_LCD"] == id_ma_lcd & (decimal)dr["ID_MUC_LCD"] == id_muc_lcd
select (decimal)dr["ID"]).FirstOrDefault();
return id_lcd;
}
catch (Exception v_e)
{
throw v_e;
}
}
private decimal find_so_tien_lcd(decimal ip_dc_id_ma_lcd, decimal ip_dc_id_muc_lcd)
{
try
{
US_DM_LUONG_CHE_DO v_us = new US_DM_LUONG_CHE_DO();
DS_DM_LUONG_CHE_DO v_ds = new DS_DM_LUONG_CHE_DO();
v_us.FillDataset(v_ds);
string v_str_filter = "ID_MA_LCD = " + ip_dc_id_ma_lcd + " AND ID_MUC_LCD = " + ip_dc_id_muc_lcd;
DataRow[] v_dr = v_ds.DM_LUONG_CHE_DO.Select(v_str_filter);
if (v_dr.Count() == 0)
{
return 0;
}
else
{
return CIPConvert.ToDecimal(v_dr.First()["SO_TIEN"].ToString());
}
}
catch (Exception v_e)
{
throw v_e;
}
}
private decimal find_id_muc_lcd_hien_tai(decimal m_id_gd_hs_lns_lcd_hien_tai)
{
US_GD_HS_LNS_LCD v_us_gd_hs_lns_lcd = new US_GD_HS_LNS_LCD(m_id_gd_hs_lns_lcd_hien_tai);
US_DM_LUONG_CHE_DO v_us_dm_lcd = new US_DM_LUONG_CHE_DO(v_us_gd_hs_lns_lcd.dcID_LCD);
return CIPConvert.ToDecimal(v_us_dm_lcd.dcID_MUC_LCD);
}
private decimal find_id_muc_lcd(decimal ip_dc_id_lcd)
{
US_DM_LUONG_CHE_DO v_us = new US_DM_LUONG_CHE_DO();
DS_DM_LUONG_CHE_DO v_ds = new DS_DM_LUONG_CHE_DO();
v_us.FillDataset(v_ds);
string v_str_filter = "ID = " + ip_dc_id_lcd;
DataRow[] v_dr = v_ds.DM_LUONG_CHE_DO.Select(v_str_filter);
if (v_dr.Count() == 0)
{
return -1;
}
else
{
return CIPConvert.ToDecimal(v_dr.First()["ID_MUC_LCD"].ToString());
}
}
private void us_obj_2_form(decimal v_id_gd_hd, decimal v_id_gd_lns_lcd)
{
US_GD_HOP_DONG v_us_gd_hd = new US_GD_HOP_DONG(v_id_gd_hd);
if (v_id_gd_lns_lcd != -1)
{
US_GD_HS_LNS_LCD v_us_gd_lns_lcd = new US_GD_HS_LNS_LCD(v_id_gd_lns_lcd);
US_DM_HE_SO_LUONG_NS v_us_dm_hs_lns = new US_DM_HE_SO_LUONG_NS(v_us_gd_lns_lcd.dcID_HS_LNS);
US_DM_LUONG_CHE_DO v_us_dm_lcd = new US_DM_LUONG_CHE_DO(v_us_gd_lns_lcd.dcID_LCD);
m_sle_chon_nhan_vien.EditValue = v_us_gd_hd.dcID_NHAN_VIEN;
m_txt_ma_hd.Text = v_us_gd_hd.strMA_HOP_DONG;
m_sle_loai_hop_dong.EditValue = v_us_gd_hd.dcID_LOAI_HOP_DONG;
m_dat_ngay_bat_dau.Value = v_us_gd_hd.datNGAY_BAT_DAU;
m_dat_ngay_ket_thuc.Value = v_us_gd_hd.datNGAY_KET_THUC;
m_dat_ngay_ky.Value = v_us_gd_hd.datNGAY_KY_HOP_DONG;
if (v_us_gd_hd.dcID_LOAI_HOP_DONG == CONST_ID_LOAI_HOP_DONG.HOP_DONG_HOC_VIEC)
{
m_gr_LNS.Enabled = false;
m_gr_LCD.Enabled = false;
}
else
{
m_sle_chuc_danh_lns.EditValue = v_us_dm_hs_lns.dcID_MA_LNS;
m_sle_muc_lns.EditValue = v_us_dm_hs_lns.dcID_MUC_LNS;
m_sle_chuc_danh_lcd.EditValue = v_us_dm_lcd.dcID_MA_LCD;
m_sle_muc_lcd.EditValue = v_us_dm_lcd.dcID_MUC_LCD;
}
}
else
{
m_sle_chon_nhan_vien.EditValue = v_us_gd_hd.dcID_NHAN_VIEN;
m_txt_ma_hd.Text = v_us_gd_hd.strMA_HOP_DONG;
m_sle_loai_hop_dong.EditValue = v_us_gd_hd.dcID_LOAI_HOP_DONG;
m_dat_ngay_bat_dau.Value = v_us_gd_hd.datNGAY_BAT_DAU;
m_dat_ngay_ket_thuc.Value = v_us_gd_hd.datNGAY_KET_THUC;
m_dat_ngay_ky.Value = v_us_gd_hd.datNGAY_KY_HOP_DONG;
if (v_us_gd_hd.dcID_LOAI_HOP_DONG == CONST_ID_LOAI_HOP_DONG.HOP_DONG_HOC_VIEC)
{
m_gr_LNS.Enabled = false;
m_gr_LCD.Enabled = false;
}
}
if (m_e_form_mode == DataEntryFormMode.UpdateDataState)
{
}
}
private decimal find_lcd(decimal ip_dc_chuc_danh, decimal ip_dc_muc)
{
US_DM_LUONG_CHE_DO v_us = new US_DM_LUONG_CHE_DO();
DS_DM_LUONG_CHE_DO v_ds = new DS_DM_LUONG_CHE_DO();
v_us.FillDataset(v_ds);
string v_str_filter = "ID_MA_LCD = " + ip_dc_chuc_danh + " AND ID_MUC_LCD = " + ip_dc_muc;
DataRow[] v_dr = v_ds.DM_LUONG_CHE_DO.Select(v_str_filter);
if (v_dr.Count() == 0)
{
return 0;
}
else
{
return CIPConvert.ToDecimal(v_dr.First()["SO_TIEN"].ToString());
}
}
private void save_data()
{
US_DM_LUONG_CHE_DO v_us_dm_luong_che_do = new US_DM_LUONG_CHE_DO();
form_2_us_obj(v_us_dm_luong_che_do);
try
{
switch (m_e_form_mode)
{
case DataEntryFormMode.InsertDataState:
v_us_dm_luong_che_do.BeginTransaction();
v_us_dm_luong_che_do.Insert();
v_us_dm_luong_che_do.CommitTransaction();
m_id_dm_luong_che_do_moi_tao = v_us_dm_luong_che_do.dcID;
break;
case DataEntryFormMode.UpdateDataState:
v_us_dm_luong_che_do.dcID = m_id_dm_luong_che_do_4_update;
v_us_dm_luong_che_do.BeginTransaction();
v_us_dm_luong_che_do.Update();
v_us_dm_luong_che_do.CommitTransaction();
break;
default:
break;
}
CHRM_BaseMessages.MsgBox_Infor(CONST_ID_MSGBOX.INFOR_DU_LIEU_DA_DUOC_CAP_NHAT);
this.Close();
}
catch (Exception v_e)
{
throw v_e;
}
}
//save data
private void form_2_us_obj(US_DM_LUONG_CHE_DO ip_us)
{
ip_us.dcID_MA_LCD = CIPConvert.ToDecimal(m_sle_ma_lcd.EditValue);
ip_us.dcID_MUC_LCD = CIPConvert.ToDecimal(m_sle_muc_lcd.EditValue);
ip_us.dcSO_TIEN = CIPConvert.ToDecimal(m_txt_so_tien.Text.Trim());
}
