private void xoa_trang()
{
switch (m_e_form_mode)
{
case DataEntryFormMode.InsertDataState:
m_cbo_trang_thai_moi.SelectedIndex = 0;
m_us_quyet_dinh = null;
m_txt_ma_quyet_dinh.Text = "";
m_cbo_loai_quyet_dinh.SelectedIndex = 0;
m_txt_noi_dung.Text = "";
m_dat_ngay_co_hieu_luc.Value = DateTime.Today;
m_dat_ngay_co_hieu_luc_qd.Value = DateTime.Today;
m_dat_ngay_het_hieu_luc.Value = DateTime.Today;
m_dat_ngay_het_hieu_luc_qd.Value = DateTime.Today;
m_dat_ngay_het_hieu_luc.Checked = false;
m_dat_ngay_co_hieu_luc_qd.Checked = false;
m_dat_ngay_ky.Value = DateTime.Today;
break;
case DataEntryFormMode.SelectDataState:
break;
case DataEntryFormMode.UpdateDataState:
us_object_to_form();
break;
case DataEntryFormMode.ViewDataState:
break;
default:
break;
}
}
private bool view_quyet_dinh_saved()
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg))
{
return(true);
}
if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row))
{
return(true);
}
if (m_fg.Rows[m_fg.Row].IsNode)
{
return(false);
}
grid2us_object(m_us, m_fg.Row);
if (m_fg.Col == (int)e_col_Number.MA_QUYET_DINH)
{
US_DM_QUYET_DINH v_us = new US_DM_QUYET_DINH(m_us.dcID_QUYET_DINH);
if (v_us.strLINK != "")
{
f206_v_gd_cong_tac_view_document v_frm = new f206_v_gd_cong_tac_view_document();
v_frm.display(v_us.strLINK);
}
else
{
BaseMessages.MsgBox_Error("Chưa có file đính kèm.");
}
}
return(false);
}
private void m_grv_qua_trinh_lam_viec_Click(object sender, EventArgs e)
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_grv_qua_trinh_lam_viec))
{
return;
}
if (!CGridUtils.isValid_NonFixed_RowIndex(m_grv_qua_trinh_lam_viec, m_grv_qua_trinh_lam_viec.Row))
{
return;
}
if (m_grv_qua_trinh_lam_viec.Rows[m_grv_qua_trinh_lam_viec.Row].UserData != null)
{
grid2us_object(m_us_qua_trinh_lam_viec, m_grv_qua_trinh_lam_viec.Row);
if (m_grv_qua_trinh_lam_viec.Col == (int)e_col_Number.MA_QUYET_DINH)
{
if (m_us_qua_trinh_lam_viec.dcID_QUYET_DINH > 0)
{
US_DM_QUYET_DINH v_us = new US_DM_QUYET_DINH(m_us_qua_trinh_lam_viec.dcID_QUYET_DINH);
if (v_us.strLINK != "")
{
//FileExplorer.DownloadFile(v_us.strLINK);
f202_v_gd_qua_trinh_lam_viec_view v_frm = new f202_v_gd_qua_trinh_lam_viec_view();
v_frm.display_for_view_quyet_dinh(v_us);
}
else
{
BaseMessages.MsgBox_Error("Chưa có file đính kèm.");
}
}
else
{
BaseMessages.MsgBox_Error("Chưa có file đính kèm.");
}
}
if (m_grv_qua_trinh_lam_viec.Col == (int)e_col_Number.MA_QUYET_DINH_MIEN_NHIEM)
{
if (m_us_qua_trinh_lam_viec.dcID_QUYET_DINH > 0)
{
US_DM_QUYET_DINH v_us = new US_DM_QUYET_DINH(m_us_qua_trinh_lam_viec.dcID_QUYET_DINH);
if (v_us.strLINK != "")
{
//FileExplorer.DownloadFile(v_us.strLINK);
f202_v_gd_qua_trinh_lam_viec_view v_frm = new f202_v_gd_qua_trinh_lam_viec_view();
v_frm.display_for_view_quyet_dinh(v_us);
}
else
{
BaseMessages.MsgBox_Error("Chưa có file đính kèm.");
}
}
else
{
BaseMessages.MsgBox_Error("Chưa có file đính kèm.");
}
}
}
}
private void init_members()
{
m_us_dm_quyet_dinh = new US_DM_QUYET_DINH();
m_ds_dm_quyet_dinh = new DS_DM_QUYET_DINH();
m_us_v_gd_luong_theo_qd = new US_V_GD_LUONG_THEO_QD();
m_ds_gd_luong_theo_qd = new DS_GD_LUONG_THEO_QD();
}
private void reset_form_quyet_dinh()
{
m_us_dm_quyet_dinh = new US_DM_QUYET_DINH();
m_txt_ma_quyet_dinh.Text = "";
m_dat_ngay_ky.Value = DateTime.Now;
m_dat_ngay_co_hieu_luc.Value = DateTime.Now;
m_txt_noi_dung.Text = "";
m_lbl_file_name.Text = "";
}
public void select_data(decimal ip_dc_chon_quyet_dinh, ref US_DM_QUYET_DINH op_us)
{
m_dc_loai_quyet_dinh = ip_dc_chon_quyet_dinh;
m_e_form_mode = DataEntryFormMode.SelectDataState;
m_cmd_delete.Visible = false;
m_cmd_insert.Visible = false;
m_cmd_update.Visible = false;
ShowDialog();
op_us = m_us;
}
protected void m_cmd_luu_qd_Click(object sender, EventArgs e)
{
US_DM_QUYET_DINH v_us = new US_DM_QUYET_DINH();
m_hdf_id_quyet_dinh.Value = "";
//check validate luu quyet dinh
if (m_txt_so_qd.Text.Trim().Equals(""))
{
m_lbl_mess_qd.Text = "Bạn phải nhập Số quyết định!";
m_txt_so_qd.Focus();
return;
}
if (m_txt_noi_dung.Text.Trim().Equals(""))
{
m_lbl_mess_qd.Text = "Bạn phải nhập Nội dung quyết định!";
m_txt_noi_dung.Focus();
return;
}
if (m_txt_ngay_thang.Text.Trim().Equals(""))
{
m_lbl_mess_qd.Text = "Bạn phải nhập Ngày tháng!";
m_txt_ngay_thang.Focus();
return;
}
DateTime v_dat_ngay_thang = DateTime.Now;
try
{
v_dat_ngay_thang = CIPConvert.ToDatetime(m_txt_ngay_thang.Text.Trim());
}
catch (Exception)
{
m_lbl_mess_qd.Text = "Bạn phải nhập Ngày tháng!";
m_txt_ngay_thang.Focus();
return;
}
// insert gd quyet dinh
v_us.dcID_DON_VI = Person.get_id_don_vi();
v_us.dcID_LOAI_QUYET_DINH = ID_LOAI_QUYET_DINH.GIAO_KE_HOACH;
v_us.strNOI_DUNG = m_txt_noi_dung.Text.Trim();
v_us.strSO_QUYET_DINH = m_txt_so_qd.Text.Trim();
v_us.datNGAY_THANG = CIPConvert.ToDatetime(m_txt_ngay_thang.Text.Trim(), "dd/MM/yyyy");
v_us.Insert();
//do not edit
m_txt_so_qd.Enabled = false;
m_txt_noi_dung.Enabled = false;
m_txt_ngay_thang.Enabled = false;
m_lbl_mess_qd.Text = "Lưu QĐ thành công!";
//set id to hiddenfield
m_hdf_id_quyet_dinh.Value = v_us.dcID.ToString();
//reload_data_to_ddl();
load_data_to_grid();
}
private bool is_exist_quyet_dinh(string ip_str_ma_quyet_dinh)
{
US_DM_QUYET_DINH v_us = new US_DM_QUYET_DINH();
DS_DM_QUYET_DINH v_ds = new DS_DM_QUYET_DINH();
v_us.FillDataset_By_Ma_qd(v_ds, ip_str_ma_quyet_dinh);
if (v_ds.DM_QUYET_DINH.Rows.Count > 0)
{
return(true);
}
return(false);
}
public void display_for_insert(US_V_DM_DU_AN_QUYET_DINH_TU_DIEN ip_us)
{
m_e_form_mode = DataEntryFormMode.InsertDataState;
m_e_file_mode = DataEntryFileMode.UploadFile;
m_e_quyet_dinh_mode = DataEntryFormMode.ViewDataState;
m_us_quyet_dinh = new US_DM_QUYET_DINH(ip_us.dcID_QUYET_DINH);
us_quyet_dinh_to_form(m_us_quyet_dinh);
m_us_du_an = ip_us;
load_data_2_control();
this.ShowDialog();
}
private void us_obj_2_form(decimal i_dc_id_gd_chi_tiet_du_an)
{
US_GD_CHI_TIET_DU_AN v_us_gd_ct_da = new US_GD_CHI_TIET_DU_AN(i_dc_id_gd_chi_tiet_du_an);
m_us.strTRANG_THAI_HIEN_TAI = v_us_gd_ct_da.strTRANG_THAI_HIEN_TAI;
m_txt_mo_ta.Text = v_us_gd_ct_da.strMO_TA;
m_cbo_vi_tri.SelectedValue = v_us_gd_ct_da.dcID_VI_TRI;
m_dat_tham_gia.Value = v_us_gd_ct_da.datTHOI_DIEM_TG;
m_txt_ma_ns.Text = new US_DM_NHAN_SU(v_us_gd_ct_da.dcID_NHAN_SU).strMA_NV;
m_txt_ma_du_an.Text = new US_V_DM_DU_AN_QUYET_DINH_TU_DIEN(v_us_gd_ct_da.dcID_DU_AN).strMA_DU_AN;
if (v_us_gd_ct_da.dcTHOI_GIAN_TG == null)
{
m_txt_thoi_gian_tham_gia.Text = v_us_gd_ct_da.dcTHOI_GIAN_TG.ToString();
}
else
{
m_txt_thoi_gian_tham_gia.Text = "0";
}
if (v_us_gd_ct_da.dcID_DANH_HIEU != null)
{
m_cbo_danh_hieu.SelectedValue = v_us_gd_ct_da.dcID_DANH_HIEU;
}
if (v_us_gd_ct_da.datTHOI_DIEM_KT != null)
{
m_dat_ngay_kt.Value = v_us_gd_ct_da.datTHOI_DIEM_KT;
}
else
{
m_dat_ngay_kt.Checked = false;
}
if (v_us_gd_ct_da.dcID_QUYET_DINH != 0)
{
m_grb_quyet_dinh.Enabled = true;
m_us_quyet_dinh = new US_DM_QUYET_DINH(v_us_gd_ct_da.dcID_QUYET_DINH);
m_txt_ma_quyet_dinh.Text = m_us_quyet_dinh.strMA_QUYET_DINH;
m_lbl_loai_qd.Text = new US.US_CM_DM_TU_DIEN(CIPConvert.ToDecimal(TU_DIEN.QD_THANH_LAP_DU_AN)).strTEN;
m_dat_ngay_ky.Value = m_us_quyet_dinh.datNGAY_KY;
m_dat_ngay_co_hieu_luc_qd.Value = m_us_quyet_dinh.datNGAY_CO_HIEU_LUC;
if (m_us_quyet_dinh.datNGAY_HET_HIEU_LUC != null)
{
m_dat_ngay_het_hieu_luc_qd.Value = m_us_quyet_dinh.datNGAY_HET_HIEU_LUC;
}
m_txt_noi_dung.Text = m_us_quyet_dinh.strNOI_DUNG;
m_str_ma_qd = m_us_quyet_dinh.strMA_QUYET_DINH;
m_lbl_file_name.Text = m_us_quyet_dinh.strLINK;
}
}
private void us_quyet_dinh_to_form(US_V_GD_CONG_TAC ip_us)
{
m_us_dm_quyet_dinh = new US_DM_QUYET_DINH(ip_us.dcID_QUYET_DINH);
m_str_ma_quyet_dinh_old = ip_us.strMA_QUYET_DINH;
m_txt_ma_quyet_dinh.Text = ip_us.strMA_QUYET_DINH.Trim();
m_txt_loai_quyet_dinh.Text = new US_CM_DM_TU_DIEN(CIPConvert.ToDecimal(TU_DIEN.QD_CONG_TAC)).strTEN;
m_dat_ngay_ky.Value = ip_us.datNGAY_KY;
m_dat_ngay_co_hieu_luc.Value = ip_us.datNGAY_CO_HIEU_LUC;
m_lbl_file_name.Text = ip_us.strLINK;
m_txt_noi_dung.Text = ip_us.strNOI_DUNG;
load_data_to_grid_nhan_su(ip_us);
}
private void us_quyet_dinh_to_form(US_DM_QUYET_DINH ip_us)
{
m_str_ma_quyet_dinh_old = ip_us.strMA_QUYET_DINH;
m_txt_ma_quyet_dinh.Text = ip_us.strMA_QUYET_DINH.Trim();
m_lbl_loai_qd.Text = new US_CM_DM_TU_DIEN(CIPConvert.ToDecimal(TU_DIEN.QD_THANH_LAP_DU_AN)).strTEN;
m_dat_ngay_ky.Value = ip_us.datNGAY_KY;
m_dat_ngay_co_hieu_luc_qd.Value = ip_us.datNGAY_CO_HIEU_LUC;
if (ip_us.datNGAY_HET_HIEU_LUC > DateTime.Parse("01/01/1900"))
{
m_dat_ngay_het_hieu_luc_qd.Checked = true;
m_dat_ngay_het_hieu_luc_qd.Value = ip_us.datNGAY_HET_HIEU_LUC;
}
else
{
m_dat_ngay_kt.Checked = false;
}
m_lbl_file_name.Text = ip_us.strLINK;
m_txt_noi_dung.Text = ip_us.strNOI_DUNG;
}
private void select_data_2_us()
{
if (m_grv_dm_quyet_dinh.Rows[m_grv_dm_quyet_dinh.Row].IsNode)
{
BaseMessages.MsgBox_Error("Dòng được chọn không phải là Quyết định!");
}
else
{
if (!CGridUtils.IsThere_Any_NonFixed_Row(m_grv_dm_quyet_dinh))
{
return;
}
if (!CGridUtils.isValid_NonFixed_RowIndex(m_grv_dm_quyet_dinh, m_grv_dm_quyet_dinh.Row))
{
return;
}
grid2us_object(m_v_us, m_grv_dm_quyet_dinh.Row);
m_us = new US_DM_QUYET_DINH(m_v_us.dcID);
Close();
}
}
private bool check_is_trung_ma_quyet_dinh()
{
DS_DM_QUYET_DINH v_ds = new DS_DM_QUYET_DINH();
US_DM_QUYET_DINH v_us = new US_DM_QUYET_DINH();
v_us.FillDataset_By_Ma_qd(v_ds, m_txt_ma_quyet_dinh.Text);
if (m_b_check_quyet_dinh_save)
{
switch (m_e_form_mode)
{
case DataEntryFormMode.InsertDataState:
if (v_ds.DM_QUYET_DINH.Count > 0)
{
return(true);
}
break;
case DataEntryFormMode.SelectDataState:
if (v_ds.DM_QUYET_DINH.Count > 0 && m_txt_ma_quyet_dinh.Text != m_us_v_gd_cong_tac.strMA_QUYET_DINH)
{
return(true);
}
break;
case DataEntryFormMode.UpdateDataState:
break;
case DataEntryFormMode.ViewDataState:
break;
default:
break;
}
}
return(false);
}
private void us_object_2_form()
{
m_txt_ma_nv.Text = m_v_us_chi_tiet_cap_bac.strMA_NV;
m_txt_ho_ten.Text = m_v_us_chi_tiet_cap_bac.strHO_DEM.Trim() + @" " + m_v_us_chi_tiet_cap_bac.strTEN.Trim();
if (m_v_us_chi_tiet_cap_bac.datNGAY_BAT_DAU == DateTime.Parse("1/1/1900"))
{
m_dat_ngay_bat_dau.Value = DateTime.Now;
}
else
{
m_dat_ngay_bat_dau.Value = m_v_us_chi_tiet_cap_bac.datNGAY_BAT_DAU;
}
//m_dat_ngay_bat_dau.Value = m_v_us_chi_tiet_cap_bac.datNGAY_BAT_DAU.Date;
// var v_ds = new DS_V_GD_CHI_TIET_CAP_BAC();
// var v_us = new US_V_GD_CHI_TIET_CAP_BAC();
// v_us.FillDatasetByManhanvien(v_ds, m_v_us_chi_tiet_cap_bac.strMA_NV);
// var t = v_ds.V_GD_CHI_TIET_CAP_BAC.Rows[0][13];
// m_txt_cap_bac_hien_tai.Text = v_ds.V_GD_CHI_TIET_CAP_BAC.Rows[0][13].ToString();
//
if (m_v_us_chi_tiet_cap_bac.datNGAY_KET_THUC > DateTime.Parse("1/1/1900"))
{
m_dat_ngay_ket_thuc.Checked = true;
m_dat_ngay_ket_thuc.Value = m_v_us_chi_tiet_cap_bac.datNGAY_KET_THUC;
}
m_txt_cap_bac_hien_tai.Text = m_v_us_chi_tiet_cap_bac.strMA_CAP_BAC;
if (m_v_us_chi_tiet_cap_bac.dcID > 0)
{
US_GD_CHI_TIET_CAP_BAC v_us_chi_tiet_cap_bac = new US_GD_CHI_TIET_CAP_BAC(m_v_us_chi_tiet_cap_bac.dcID);
m_us_quyet_dinh = new US_DM_QUYET_DINH(v_us_chi_tiet_cap_bac.dcID_QUYET_DINH);
US_DM_QUYET_DINH v_us = new US_DM_QUYET_DINH(v_us_chi_tiet_cap_bac.dcID_QUYET_DINH);
m_txt_ma_quyet_dinh.Text = v_us.strMA_QUYET_DINH;
m_cbo_loai_quyet_dinh.SelectedValue = v_us.dcID_LOAI_QD;
m_dat_ngay_ky.Value = v_us.datNGAY_KY;
m_dat_ngay_co_hieu_luc_qd.Value = v_us.datNGAY_CO_HIEU_LUC;
m_txt_noi_dung.Text = v_us.strNOI_DUNG;
}
}
protected void m_ddl_quyet_dinh_SelectedIndexChanged(object sender, EventArgs e)
{
if (m_ddl_quyet_dinh.SelectedValue == null) return;
m_ddl_quyet_dinh.Visible = true;
m_hdf_id_quyet_dinh.Value = m_ddl_quyet_dinh.SelectedValue;
load_data_when_quyet_dinh_is_selected();
if (CIPConvert.ToDecimal(m_ddl_quyet_dinh.SelectedValue) < 0) return;
US_DM_QUYET_DINH v_us = new US_DM_QUYET_DINH(CIPConvert.ToDecimal(m_ddl_quyet_dinh.SelectedValue));
if (v_us.dcID_LOAI_QUYET_DINH_GIAO == ID_LOAI_GIAO_DICH.KH_DAU_NAM)
{
//m_rdb_kh_dau_nam.Checked = true;
//m_rdb_dieu_chinh.Checked = false;
//m_rdb_bo_sung.Checked = false;
m_lbl_loai_quyet_dinh.Text = "Đầu năm";
}
else if (v_us.dcID_LOAI_QUYET_DINH_GIAO == ID_LOAI_GIAO_DICH.BO_SUNG)
{
//m_rdb_kh_dau_nam.Checked = false;
//m_rdb_dieu_chinh.Checked = false;
//m_rdb_bo_sung.Checked = true;
m_lbl_loai_quyet_dinh.Text = "Bổ sung";
}
else if (v_us.dcID_LOAI_QUYET_DINH_GIAO == ID_LOAI_GIAO_DICH.DIEU_CHINH)
{
//m_rdb_kh_dau_nam.Checked = false;
//m_rdb_dieu_chinh.Checked = true;
//m_rdb_bo_sung.Checked = false;
m_lbl_loai_quyet_dinh.Text = "Điều chỉnh";
}
}
public static void load_data_to_cbo_quyet_dinh_by_loai_quyet_dinh(
LOAI_QUYET_DINH ip_loai_quyet_dinh
, DropDownList op_ddl_quyet_dinh)
{
decimal v_dc_id_don_vi = Person.get_id_don_vi();
DS_DM_QUYET_DINH v_ds = new DS_DM_QUYET_DINH();
US_DM_QUYET_DINH v_us = new US_DM_QUYET_DINH();
string v_str_querry = "";
if (ip_loai_quyet_dinh == LOAI_QUYET_DINH.GIAO_VON)
v_str_querry = "where "// id_don_vi=" + v_dc_id_don_vi
+ " id_loai_quyet_dinh= " + ID_LOAI_QUYET_DINH.GIAO_VON;
else if (ip_loai_quyet_dinh == LOAI_QUYET_DINH.GIAO_KE_HOACH)
v_str_querry = "where "//id_don_vi=" + v_dc_id_don_vi
+ " id_loai_quyet_dinh= " + ID_LOAI_QUYET_DINH.GIAO_KE_HOACH;
else if (ip_loai_quyet_dinh == LOAI_QUYET_DINH.TAT_CA)
v_str_querry = "where";// id_don_vi=" + v_dc_id_don_vi;
v_str_querry += " order by ngay_thang ";
v_us.FillDataset(v_ds, v_str_querry);
for (int v = 0; v < v_ds.DM_QUYET_DINH.Count; v++)
{
v_ds.Tables[0].Rows[v][DM_QUYET_DINH.NOI_DUNG] =
v_ds.Tables[0].Rows[v][DM_QUYET_DINH.SO_QUYET_DINH] + " " + v_ds.Tables[0].Rows[v][DM_QUYET_DINH.NOI_DUNG];
v_ds.AcceptChanges();
}
op_ddl_quyet_dinh.DataTextField = DM_QUYET_DINH.NOI_DUNG;
op_ddl_quyet_dinh.DataValueField = DM_QUYET_DINH.ID;
op_ddl_quyet_dinh.DataSource = v_ds.DM_QUYET_DINH;
op_ddl_quyet_dinh.DataBind();
op_ddl_quyet_dinh.Items.Insert(0, new ListItem("---Chọn quyết định---", "-1"));
}
/// <summary>
/// Load danh sách các quyết định theo các tiêu chí vào DropDownList đơn vị
/// </summary>
/// <param name="ip_dc_id_don_vi"></param>
/// <param name="ip_dc_id_loai_nhiem_vu"></param>
/// <param name="ip_dc_id_cong_trinh"></param>
/// <param name="ip_dc_id_du_an"></param>
/// <param name="ip_dat_tu_ngay"></param>
/// <param name="ip_dat_den_ngay"></param>
/// <param name="ip_str_tu_khoa"></param>
/// <param name="ip_e_tat_ca"></param>
/// <param name="ip_obj_cbo_quyet_dinh"></param>
public static void load_data_to_cbo_quyet_dinh(
decimal ip_dc_id_don_vi
, decimal ip_dc_id_loai_nhiem_vu
, decimal ip_dc_id_cong_trinh
, decimal ip_dc_id_du_an
, DateTime ip_dat_tu_ngay
, DateTime ip_dat_den_ngay
, string ip_str_tu_khoa
, eTAT_CA ip_e_tat_ca
, string ip_str_proc
, DropDownList ip_obj_cbo_quyet_dinh)
{
US_DM_QUYET_DINH v_us_dm_quyet_dinh = new US_DM_QUYET_DINH();
DS_DM_QUYET_DINH v_ds_dm_quyet_dinh = new DS_DM_QUYET_DINH();
DataSet v_ds = new DataSet();
DataTable v_dt = new DataTable();
v_ds.Tables.Add(v_dt);
string v_str_user_name = HttpContext.Current.Session[SESSION.UserName].ToString();
v_ds_dm_quyet_dinh.EnforceConstraints = false;
v_us_dm_quyet_dinh.get_ds_quyet_dinh(
v_ds
, ip_dc_id_don_vi
, ip_dc_id_loai_nhiem_vu
, ip_dc_id_cong_trinh
, ip_dc_id_du_an
, ip_dat_tu_ngay
, ip_dat_den_ngay
, ip_str_tu_khoa
, ip_str_proc
);
DataView v_dv_quyet_dinh = v_ds.Tables[0].DefaultView;
ip_obj_cbo_quyet_dinh.DataSource = v_dv_quyet_dinh.ToTable();
ip_obj_cbo_quyet_dinh.DataTextField = DM_QUYET_DINH.SO_QUYET_DINH;
ip_obj_cbo_quyet_dinh.DataValueField = DM_QUYET_DINH.ID;
ip_obj_cbo_quyet_dinh.DataBind();
if (ip_e_tat_ca == eTAT_CA.YES)
{
ip_obj_cbo_quyet_dinh.Items.Insert(0, new ListItem(CONST_TONG.TONG, CONST_GIAO_DICH.ID_TAT_CA.ToString()));
}
}
private void us_object_to_form()
{
decimal v_dc_id_quyet_dinh = CIPConvert.ToDecimal(m_hdf_id_quyet_dinh.Value);
if (v_dc_id_quyet_dinh <= 0)
{
m_lbl_mess.Text = "Có lỗi xảy ra trong quá trình xử lý, Bạn vui lòng thực hiện lại thao tác!";
return;
}
m_us = new US_DM_QUYET_DINH(v_dc_id_quyet_dinh);
m_txt_so_quyet_dinh.Text = m_us.strSO_QUYET_DINH;
m_txt_ngay_thang.Text = CIPConvert.ToStr(m_us.datNGAY_THANG, "dd/MM/yyyy");
m_txt_noi_dung.Text = m_us.strNOI_DUNG;
if (m_us.dcID_LOAI_QUYET_DINH == ID_LOAI_QUYET_DINH.GIAO_VON)
{
m_rdb_giao_von.Checked = true;
m_rdb_giao_ke_hoach.Checked = false;
}
else if (m_us.dcID_LOAI_QUYET_DINH == ID_LOAI_QUYET_DINH.GIAO_KE_HOACH)
{
m_rdb_giao_ke_hoach.Checked = true;
m_rdb_giao_von.Checked = false;
if (m_us.dcID_LOAI_QUYET_DINH_GIAO == ID_LOAI_GIAO_DICH.KH_DAU_NAM)
{
m_rdb_loai_quyet_dinh_giao_dau_nam.Checked = true;
m_rdb_loai_quyet_dinh_giao_bo_sung.Checked = false;
m_rdb_loai_quyet_dinh_giao_dieu_chinh.Checked = false;
}
else if (m_us.dcID_LOAI_QUYET_DINH_GIAO == ID_LOAI_GIAO_DICH.BO_SUNG)
{
m_rdb_loai_quyet_dinh_giao_dau_nam.Checked = false;
m_rdb_loai_quyet_dinh_giao_bo_sung.Checked = true;
m_rdb_loai_quyet_dinh_giao_dieu_chinh.Checked = false;
}
else if (m_us.dcID_LOAI_QUYET_DINH_GIAO == ID_LOAI_GIAO_DICH.DIEU_CHINH)
{
m_rdb_loai_quyet_dinh_giao_dau_nam.Checked = false;
m_rdb_loai_quyet_dinh_giao_bo_sung.Checked = false;
m_rdb_loai_quyet_dinh_giao_dieu_chinh.Checked = true;
}
}
load_rdb_loai_quyet_dinh_giao_from_select_loai_quyet_dinh();
m_txt_so_quyet_dinh.Focus();
}
private void save_data()
{
if (check_validate_data_is_ok())
{
if (get_form_mode(m_hdf_form_mode) == LOAI_FORM.THEM)
{
m_us = new US_DM_QUYET_DINH();
form_to_us_object();
m_us.Insert();
m_lbl_mess.Text = "Bạn đã thêm mới Quyết định thành công!";
load_data_to_grid();
xoa_trang();
}
else if (get_form_mode(m_hdf_form_mode) == LOAI_FORM.SUA)
{
decimal v_dc_id_quyet_dinh = CIPConvert.ToDecimal(m_hdf_id_quyet_dinh.Value);
if (v_dc_id_quyet_dinh <= 0)
{
m_lbl_mess.Text = "Có lỗi xảy ra trong quá trình xử lý, Bạn vui lòng thực hiện lại thao tác!";
return;
}
else
{
m_us = new US_DM_QUYET_DINH(v_dc_id_quyet_dinh);
form_to_us_object();
m_us.Update();
m_lbl_mess.Text = "Bạn đã cập nhật dữ liệu thành công!";
load_data_to_grid();
xoa_trang();
}
}
}
}
private void draw_GridView(DataTable ip_dt)
{
for (int i = 2; i < ip_dt.Columns.Count; i++)
{
BoundField bfield = new BoundField();
switch (ip_dt.Columns[i].ColumnName)
{
case "Column1":
bfield.HeaderText = "Tổng KH giao";
bfield.HeaderStyle.CssClass = "hiddenCell";
//bfield.ItemStyle.CssClass = "HeaderStyle"; //TuDM sua, bo mau sac o luoi
break;
case "SoDu":
bfield.HeaderText = "Số dư năm trước chuyển sang";
//bfield.ItemStyle.CssClass = "HeaderStyle";
bfield.HeaderStyle.CssClass = "hiddenCell";
break;
case "ChinhThuc":
bfield.HeaderText = "KH giao chính thức " + CIPConvert.ToDatetime(m_txt_tu_ngay.Text, c_configuration.DEFAULT_DATETIME_FORMAT).Year.ToString();
bfield.HeaderStyle.CssClass = "hiddenCell";
//bfield.ItemStyle.CssClass = "HeaderStyle";
break;
case "TongVon":
bfield.HeaderText = "Tổng cộng";
//bfield.ItemStyle.CssClass = "HeaderStyle";
break;
default:
var qd = new US_DM_QUYET_DINH(CIPConvert.ToDecimal(ip_dt.Columns[i].ColumnName.Substring(2)));
bfield.HeaderText = qd.strSO_QUYET_DINH;
if (qd.dcID_LOAI_QUYET_DINH == 648)
{
//bfield.ItemStyle.CssClass = "HeaderStyle";
}
else
{
// bfield.ItemStyle.CssClass = "HeaderStyle";
}
break;
}
bfield.DataField = ip_dt.Columns[i].ColumnName;
bfield.ItemStyle.HorizontalAlign = HorizontalAlign.Right;
bfield.HtmlEncode = false;
m_grv_bao_cao_giao_von.Columns.Add(bfield);
}
}
private void load_data_to_grid(decimal ip_id_quyet_dinh, decimal ip_id_loai_nhiem_vu = -1,
decimal ip_id_cong_trinh = -1, decimal ip_id_du_an = -1)
{
var v_dat_now = DateTime.Now;
//0. Chuan bi du lieu input
if (ip_id_quyet_dinh != -1)
{
US_DM_QUYET_DINH v_us_qd = new US_DM_QUYET_DINH(ip_id_quyet_dinh);
v_dat_now = v_us_qd.datNGAY_THANG;
}
DateTime v_dat_dau_nam = v_dat_now.AddDays(-v_dat_now.Day + 1);
v_dat_dau_nam = v_dat_dau_nam.AddMonths(-v_dat_dau_nam.Month + 1);
DateTime v_dat_cuoi_nam = v_dat_dau_nam.AddYears(1);
//1. Update noi dung chi tu Giao kh sang Giao von
US_GD_CHI_TIET_GIAO_VON v_us_giao_von = new US_GD_CHI_TIET_GIAO_VON();
v_us_giao_von.update_noi_dung_chi_from_giao_kh_sang_giao_von(v_dat_dau_nam,
v_dat_cuoi_nam, CIPConvert.ToDecimal( m_ddl_don_vi.SelectedValue), ip_id_quyet_dinh);
//2. Load data tu grid_giao_von len luoi de sua thong tin
DS_GRID_GIAO_VON v_ds = new DS_GRID_GIAO_VON();
US_GRID_GIAO_VON v_us = new US_GRID_GIAO_VON();
v_us.get_grid_giao_von_qbt(v_ds, ip_id_quyet_dinh,
CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue), v_dat_dau_nam, v_dat_cuoi_nam,
ip_id_loai_nhiem_vu, ip_id_cong_trinh, ip_id_du_an);
m_grv.DataSource = v_ds.Tables[0];
m_grv.DataBind();
//if (!m_hdf_id_giao_kh.Value.Equals(""))
//{
// m_grv.SelectedIndex = -1;
// for (int i = 0; i < m_grv.Rows.Count; i++)
// if (CIPConvert.ToDecimal(m_grv.DataKeys[i].Value) == CIPConvert.ToDecimal(m_hdf_id_giao_kh.Value)) m_grv.SelectedIndex = i;
//}
}
private void us_object_to_form()
{
m_us = new US_GD_CHI_TIET_GIAO_KH(CIPConvert.ToDecimal(m_hdf_id_giao_kh.Value));
if (!m_us.IsTU_CHU_YNNull())
{
if (m_us.strTU_CHU_YN == "Y")
{
m_rdb_chi_thuong_xuyen.Checked = true;
m_rdb_chi_khong_thuong_xuyen.Checked = false;
}
else
{
m_rdb_chi_thuong_xuyen.Checked = false;
m_rdb_chi_khong_thuong_xuyen.Checked = true;
}
}
m_txt_so_km.Text = m_us.strGHI_CHU_2;
if (Request.QueryString["ip_nguon_ns"] == "N")
{
m_txt_so_tien.Text = CIPConvert.ToStr(m_us.dcSO_TIEN_QUY_BT);
}
else
{
m_txt_so_tien.Text = CIPConvert.ToStr(m_us.dcSO_TIEN_NS);
}
m_txt_so_tien_nam_truoc_chuyen_sang.Text = CIPConvert.ToStr(m_us.dcSO_TIEN_NAM_TRUOC_CHUYEN_SANG);
m_txt_ghi_chu.Text = m_us.strGHI_CHU;
//m_txt_ten_quoc_lo.Text = v_us_du_an_cong_trinh.strTEN_DU_AN_CONG_TRINH.Replace("Quốc lộ ","");
if (!m_us.IsID_CONG_TRINHNull())
{
m_rdb_theo_quoc_lo.Checked = true;
m_rdb_theo_chuong_loai_khoan_muc.Checked = false;
m_rdb_theo_quoc_lo_CheckedChanged(null, null);
US_DM_CONG_TRINH_DU_AN_GOI_THAU v_us_du_an = new US_DM_CONG_TRINH_DU_AN_GOI_THAU(m_us.dcID_DU_AN);
US_DM_CONG_TRINH_DU_AN_GOI_THAU v_us_cong_trinh = new US_DM_CONG_TRINH_DU_AN_GOI_THAU(v_us_du_an.dcID_CHA);
//set cong trinh
m_ddl_cong_trinh.SelectedValue = v_us_du_an.dcID_CHA.ToString();
m_ddl_cong_trinh_SelectedIndexChanged(null, null);
m_txt_quoc_lo.Text = v_us_cong_trinh.strTEN;
m_ddl_cong_trinh.Visible = true;
m_txt_quoc_lo.Visible = false;
m_cmd_chon_quoc_lo.Visible = false;
m_cmd_them_quoc_lo.Visible = true;
//set du an
m_txt_du_an.Text = v_us_du_an.strTEN;
m_txt_du_an.Visible = false;
m_ddl_du_an.Visible = true;
m_cmd_chon_du_an.Visible = false;
m_cmd_them_du_an.Visible = true;
m_ddl_du_an.SelectedValue = v_us_du_an.dcID.ToString();
m_rdb_theo_chuong_loai_khoan_muc.Checked = false;
m_rdb_theo_quoc_lo.Checked = true;
}
else
{
m_rdb_theo_quoc_lo.Checked = false;
m_rdb_theo_chuong_loai_khoan_muc.Checked = true;
m_rdb_theo_chuong_loai_khoan_muc_CheckedChanged(null, null);
m_ddl_chuong.SelectedValue = m_us.dcID_CHUONG.ToString();
US_DM_CHUONG_LOAI_KHOAN_MUC v_us_khoan = new US_DM_CHUONG_LOAI_KHOAN_MUC(m_us.dcID_KHOAN);
m_ddl_loai.SelectedValue = v_us_khoan.dcID_CHA.ToString();
m_ddl_loai_SelectedIndexChanged(null, null);
m_ddl_khoan.SelectedValue = m_us.dcID_KHOAN.ToString();
m_ddl_muc.SelectedValue = m_us.dcID_MUC.ToString();
m_ddl_muc_SelectedIndexChanged(null, null);
if (!m_us.IsID_TIEU_MUCNull())
{
m_ddl_tieu_muc.SelectedValue = m_us.dcID_TIEU_MUC.ToString();
}
m_rdb_theo_chuong_loai_khoan_muc.Checked = true;
m_rdb_theo_quoc_lo.Checked = false;
}
m_ddl_loai_nhiem_vu.Focus();
m_ddl_loai_nhiem_vu.SelectedValue = m_us.dcID_LOAI_NHIEM_VU.ToString();
load_panel_loai_chi();
m_txt_noi_dung_du_toan.Text = m_us.strGHI_CHU_1;
//set quyet dinh
US_DM_QUYET_DINH v_us_quyet_dinh = new US_DM_QUYET_DINH(m_us.dcID_QUYET_DINH);
m_txt_so_qd.Text = v_us_quyet_dinh.strSO_QUYET_DINH;
m_txt_noi_dung.Text = v_us_quyet_dinh.strNOI_DUNG;
//m_txt_ngay_thang.Text = CIPConvert.ToStr(v_us_quyet_dinh.datNGAY_THANG, "dd/MM/yyyy");
m_lbl_ngay_thang.Text = CIPConvert.ToStr(v_us_quyet_dinh.datNGAY_THANG, "dd/MM/yyyy");
m_hdf_id_quyet_dinh.Value = v_us_quyet_dinh.dcID.ToString();
disable_edit_quyet_dinh();
}
private void us_object_to_form()
{
m_us = new US_GD_CHI_TIET_GIAO_KH(CIPConvert.ToDecimal(m_hdf_id_giao_kh.Value));
//US_DM_CONG_TRINH_DU_AN_GOI_THAU v_us_du_an_cong_trinh = new US_DM_CONG_TRINH_DU_AN_GOI_THAU(m_us.dcID_DU_AN_CONG_TRINH);
m_ddl_chuong.SelectedValue = m_us.dcID_CHUONG.ToString();
US_DM_CHUONG_LOAI_KHOAN_MUC v_us_khoan = new US_DM_CHUONG_LOAI_KHOAN_MUC(m_us.dcID_KHOAN);
m_ddl_loai.SelectedValue = v_us_khoan.dcID_CHA.ToString();
load_data_to_ddl_khoan();
m_ddl_khoan.SelectedValue = m_us.dcID_KHOAN.ToString();
m_ddl_muc.SelectedValue = m_us.dcID_MUC.ToString();
load_data_to_ddl_tieu_muc();
if (!m_us.IsID_TIEU_MUCNull())
{
m_ddl_tieu_muc.SelectedValue = m_us.dcID_TIEU_MUC.ToString();
}
m_txt_so_tien.Text = m_us.dcSO_TIEN_NS.ToString();
m_txt_ghi_chu.Text = m_us.strGHI_CHU;
//if (m_us.dcID_LOAI_GIAO_DICH == ID_LOAI_GIAO_DICH.KH_DAU_NAM)
//{
// m_rdb_kh_dau_nam.Checked = true;
// m_rdb_dieu_chinh.Checked = false;
// m_rdb_bo_sung.Checked = false;
//}
//else if (m_us.dcID_LOAI_GIAO_DICH == ID_LOAI_GIAO_DICH.BO_SUNG)
//{
// m_rdb_kh_dau_nam.Checked = false;
// m_rdb_dieu_chinh.Checked = false;
// m_rdb_bo_sung.Checked = true;
//}
//else
//{
// m_rdb_kh_dau_nam.Checked = false;
// m_rdb_dieu_chinh.Checked = true;
// m_rdb_bo_sung.Checked = false;
//}
//set quyet dinh
US_DM_QUYET_DINH v_us_quyet_dinh = new US_DM_QUYET_DINH(m_us.dcID_QUYET_DINH);
m_txt_so_qd.Text = v_us_quyet_dinh.strSO_QUYET_DINH;
m_txt_noi_dung.Text = v_us_quyet_dinh.strNOI_DUNG;
m_txt_ngay_thang.Text = CIPConvert.ToStr(v_us_quyet_dinh.datNGAY_THANG, "dd/MM/yyyy");
m_hdf_id_quyet_dinh.Value = v_us_quyet_dinh.dcID.ToString();
disable_edit_quyet_dinh();
}
protected void m_ddl_quyet_dinh_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (m_ddl_quyet_dinh.SelectedValue == null) return;
m_ddl_quyet_dinh.Visible = false;
m_hdf_id_quyet_dinh.Value = m_ddl_quyet_dinh.SelectedValue;
m_txt_so_qd.Visible = true;
m_txt_noi_dung.Visible = true;
m_txt_ngay_thang.Visible = true;
US_DM_QUYET_DINH v_us = new US_DM_QUYET_DINH(CIPConvert.ToDecimal(m_ddl_quyet_dinh.SelectedValue)); ;
m_txt_so_qd.Text = v_us.strSO_QUYET_DINH;
m_txt_noi_dung.Text = v_us.strNOI_DUNG;
m_txt_ngay_thang.Text = CIPConvert.ToStr(v_us.datNGAY_THANG, "dd/MM/yyyy");
disable_edit_quyet_dinh();
//reload_data_to_ddl();
load_data_to_grid();
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
private void save_data()
{
if (check_data_is_ok() == false)
{
return;
}
try
{
m_us.BeginTransaction();
#region Xử lý file đính kèm
switch (m_e_file_mode)
{
case DataEntryFileMode.UploadFile:
// Kiểm tra file đã tồn tại trên server hay chưa
if (FileExplorer.IsExistedFile(m_str_directory_to + FileExplorer.fileName))
{
BaseMessages.MsgBox_Infor("Tên file đã tồn tại. Vui lòng đổi tên khác");
return;
}
// Nếu đã chọn file
if (m_lbl_file_name.Text != "")
{
// Upload server có sử dụng user và pass
if (m_str_user_name != "")
{
FileExplorer.UploadFile(m_str_domain, m_str_directory_to, m_str_user_name, m_str_password);
}
// Upload không sử dụng user và pass
else
{
FileExplorer.UploadFile(m_str_domain, m_str_directory_to);
}
}
break;
case DataEntryFileMode.EditFile:
// Nếu ko up lên file mới sẽ bỏ qua bước này
if (m_str_link_old != m_lbl_file_name.Text)
{
// Kiểm tra file vừa upload đã tồn tại hay chưa
if (FileExplorer.IsExistedFile(m_str_directory_to + FileExplorer.fileName))
{
BaseMessages.MsgBox_Infor("Tên file đã tồn tại. Vui lòng đổi tên khác");
return;
}
// Xóa file cũ
if (FileExplorer.IsExistedFile(m_str_directory_to + m_str_link_old))
{
FileExplorer.DeleteFile(m_str_directory_to + m_str_link_old);
}
// Upload file mới lên
if (m_str_user_name != "")
{
FileExplorer.UploadFile(m_str_domain, m_str_directory_to, m_str_user_name, m_str_password);
}
else
{
FileExplorer.UploadFile(m_str_domain, m_str_directory_to);
}
}
break;
case DataEntryFileMode.DeleteFile:
// Kiểm tra file có tồn tại hay không
if (FileExplorer.IsExistedFile(m_str_directory_to + m_str_link_old) == false)
{
BaseMessages.MsgBox_Infor("File không tồn tại!");
return;
}
FileExplorer.DeleteFile(m_str_directory_to + m_str_link_old);
break;
}
#endregion
#region Xử lý quyết định
form_to_us_quyet_dinh();
switch (m_e_quyet_dinh_mode)
{
case DataEntryFormMode.InsertDataState:
if (is_exist_quyet_dinh(m_txt_ma_quyet_dinh.Text))
{
BaseMessages.MsgBox_Error("Mã quyết định đã tồn tại.");
m_txt_ma_quyet_dinh.Focus();
return;
}
m_us.Insert();
break;
case DataEntryFormMode.UpdateDataState:
if (!m_txt_ma_quyet_dinh.Text.Equals(m_str_ma_quyet_dinh_old))
{
if (is_exist_quyet_dinh(m_txt_ma_quyet_dinh.Text))
{
BaseMessages.MsgBox_Error("Mã quyết định đã tồn tại hoặc đang được dùng cho dự án khác.");
m_txt_ma_quyet_dinh.Focus();
return;
}
}
m_us.Update();
break;
}
#endregion
m_us.CommitTransaction();
}
catch (Exception)
{
if (m_us.is_having_transaction())
{
m_us.Rollback();
}
}
form_2_us_nhan_vien();
US_DM_QUYET_DINH v_us_qd = new US_DM_QUYET_DINH();
DS_DM_QUYET_DINH v_ds_qd = new DS_DM_QUYET_DINH();
switch (m_e_form_mode)
{
case DataEntryFormMode.InsertDataState:
// Insert nhân sự
chuyen_trang_thai_ve_no(m_us.dcID_NHAN_SU);
m_us.strTRANG_THAI_HIEN_TAI = "Y";
// Quyết định
if (m_b_check_quyet_dinh_save)
{
form_to_us_quyet_dinh();
if (m_b_check_quyet_dinh_null)
{
m_us_quyet_dinh.Insert();
US_DM_QUYET_DINH v_us = new US_DM_QUYET_DINH();
DS_DM_QUYET_DINH v_ds = new DS_DM_QUYET_DINH();
v_us.FillDataset_By_Ma_qd(v_ds, m_us_quyet_dinh.strMA_QUYET_DINH);
if (v_ds.DM_QUYET_DINH.Rows.Count != 0)
{
US_GD_QUYET_DINH_PHAP_NHAN v_us_qd_pn = new US_GD_QUYET_DINH_PHAP_NHAN();
v_us_qd_pn.dcID_PHAP_NHAN = CAppContext_201.getCurrentIDPhapnhan();
v_us_qd_pn.dcID_QUYET_DINH = CIPConvert.ToDecimal(v_ds_qd.Tables[0].Rows[0]["ID"]);
v_us_qd_pn.Insert();
}
}
else
{
m_us_quyet_dinh.Update();
}
v_us_qd.FillDataset_By_Ma_qd(v_ds_qd, m_us_quyet_dinh.strMA_QUYET_DINH);
if (v_ds_qd.Tables[0].Rows.Count != 0)
{
m_us.dcID_QUYET_DINH = CIPConvert.ToDecimal(v_ds_qd.Tables[0].Rows[0]["ID"]);
}
}
m_us.Insert();
break;
case DataEntryFormMode.UpdateDataState:
if (m_txt_ma_quyet_dinh.Text != "")
{
form_to_us_quyet_dinh();
if (m_b_check_quyet_dinh_save)
{
m_us_quyet_dinh.Insert();
}
else
{
m_us_quyet_dinh.Update();
}
v_us_qd.FillDataset_By_Ma_qd(v_ds_qd, m_us_quyet_dinh.strMA_QUYET_DINH);
if (v_ds_qd.Tables[0].Rows.Count != 0)
{
m_us.dcID_QUYET_DINH = CIPConvert.ToDecimal(v_ds_qd.Tables[0].Rows[0]["ID"]);
}
}
m_us.Update();
break;
}
BaseMessages.MsgBox_Infor("Dữ liệu đã được cập nhật");
this.Close();
}
private void load_data_to_grid(decimal ip_id_quyet_dinh, decimal ip_id_loai_nhiem_vu = -1,
decimal ip_id_cong_trinh = -1, decimal ip_id_du_an = -1)
{
if (!CValidateTextBox.IsValid(m_txt_ngay_thang, DataType.DateType, allowNull.NO))
{
m_lbl_mess_qd.Text = "Bạn phải nhập ngày tháng (dd/MM/yyyy)";
return;
}
var v_dat_now = CIPConvert.ToDatetime(m_txt_ngay_thang.Text.Trim(), "dd/MM/yyyy"); ;
//0. Chuan bi du lieu input
if (ip_id_quyet_dinh != -1)
{
US_DM_QUYET_DINH v_us_qd = new US_DM_QUYET_DINH(ip_id_quyet_dinh);
v_dat_now = v_us_qd.datNGAY_THANG;
}
DateTime v_dat_dau_nam = v_dat_now.AddDays(-v_dat_now.Day + 1);
v_dat_dau_nam = v_dat_dau_nam.AddMonths(-v_dat_dau_nam.Month + 1);
DateTime v_dat_cuoi_nam = v_dat_dau_nam.AddYears(1);
//1. Update noi dung chi tu Giao kh sang Giao von
US_GD_KHOI_LUONG v_us_khoi_luong = new US_GD_KHOI_LUONG();
v_us_khoi_luong.update_noi_dung_chi_from_giao_kh_sang_khoi_luong(
v_dat_dau_nam
, v_dat_cuoi_nam
, v_dat_now
, CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue));
//2. Load data tu grid_giao_von len luoi de sua thong tin
DS_GRID_GIAO_VON v_ds = new DS_GRID_GIAO_VON();
US_GRID_GIAO_VON v_us = new US_GRID_GIAO_VON();
v_us.get_grid_khoi_luong(v_ds
, CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue)
, v_dat_now
, CIPConvert.ToDecimal(m_ddl_loai_nhiem_vu.SelectedValue));
m_grv.DataSource = v_ds.Tables[0];
m_grv.DataBind();
if (!m_hdf_id_giao_kh.Value.Equals(""))
{
m_grv.SelectedIndex = -1;
for (int i = 0; i < m_grv.Rows.Count; i++)
if (CIPConvert.ToDecimal(m_grv.DataKeys[i].Value) == CIPConvert.ToDecimal(m_hdf_id_giao_kh.Value)) m_grv.SelectedIndex = i;
}
}
private void us_object_to_form()
{
m_txt_ma_nv.Text = m_us_v_trang_thai_ld.strMA_NV;
m_txt_ho_ten.Text = m_us_v_trang_thai_ld.strHO_DEM + " " + m_us_v_trang_thai_ld.strTEN;
m_txt_ma_nv.BackColor = SystemColors.Info;
m_txt_ma_nv.ReadOnly = true;
m_txt_ho_ten.BackColor = SystemColors.Info;
m_txt_ho_ten.ReadOnly = true;
m_us_v_trang_thai_ld.FillDatasetByManhanvien_trang_thai_hien_tai(m_ds_v_trang_thai_ld, m_us_v_trang_thai_ld.strMA_NV, CAppContext_201.getCurrentIDPhapnhan());
switch (m_e_form_mode)
{
case DataEntryFormMode.InsertDataState:
if (m_ds_v_trang_thai_ld.V_GD_TRANG_THAI_LAO_DONG.Select("MA_NV is not null").Length > 0)
{
m_us_v_trang_thai_ld.DataRow2Me((DataRow)m_ds_v_trang_thai_ld.V_GD_TRANG_THAI_LAO_DONG.Rows[0]);
m_txt_trang_thai_hien_tai.Text = m_us_v_trang_thai_ld.strTRANG_THAI_LAO_DONG;
m_cbo_trang_thai_moi.SelectedValue = m_us_v_trang_thai_ld.dcID_TRANG_LAO_DONG;
}
else
{
m_txt_trang_thai_hien_tai.Text = "";
}
m_txt_trang_thai_hien_tai.BackColor = SystemColors.Info;
m_txt_trang_thai_hien_tai.ReadOnly = true;
if (m_us_v_trang_thai_ld.dcID_QUYET_DINH != 0)
{
US_DM_QUYET_DINH v_us_quyet_dinh = new US_DM_QUYET_DINH(m_us_v_trang_thai_ld.dcID_QUYET_DINH);
m_str_link_old = v_us_quyet_dinh.strLINK;
if (v_us_quyet_dinh.strLINK == "")
{
return;
}
m_lbl_file_name.Text = v_us_quyet_dinh.strLINK;
}
break;
case DataEntryFormMode.UpdateDataState:
m_cbo_trang_thai_moi.SelectedValue = m_us_v_trang_thai_ld.dcID_TRANG_LAO_DONG;
if (m_us_v_trang_thai_ld.datNGAY_CO_HIEU_LUC > DateTime.Parse("01/01/1900"))
{
m_dat_ngay_co_hieu_luc.Value = m_us_v_trang_thai_ld.datNGAY_CO_HIEU_LUC;
}
// else
// m_dat_ngay_co_hieu_luc.Checked = false;
if (m_us_v_trang_thai_ld.datNGAY_HET_HIEU_LUC != null && m_us_v_trang_thai_ld.datNGAY_HET_HIEU_LUC > DateTime.Parse("01/01/1900"))
{
m_dat_ngay_het_hieu_luc.Checked = true;
m_dat_ngay_het_hieu_luc.Value = m_us_v_trang_thai_ld.datNGAY_HET_HIEU_LUC;
}
else
{
m_dat_ngay_het_hieu_luc.Checked = false;
}
m_us_quyet_dinh.FillDataset_By_Ma_qd(m_ds_quyet_dinh, m_us_v_trang_thai_ld.strMA_QUYET_DINH);
if (m_ds_quyet_dinh.DM_QUYET_DINH.Select("MA_QUYET_DINH is not null").Length > 0)
{
US_DM_QUYET_DINH v_us_qd = new US_DM_QUYET_DINH();
v_us_qd = new US_DM_QUYET_DINH(m_us_v_trang_thai_ld.dcID_QUYET_DINH);
// string[] v_arstr = v_us_qd.strMA_QUYET_DINH.Trim().Split('/');
// m_txt_ma_quyet_dinh.Text = v_arstr[0];
// BKI_HRM.US.US_CM_DM_TU_DIEN v_us = new BKI_HRM.US.US_CM_DM_TU_DIEN();
// BKI_HRM.DS.DS_CM_DM_TU_DIEN v_ds = new BKI_HRM.DS.DS_CM_DM_TU_DIEN();
// decimal v_dc_id = 0;
// v_us.FillDatasetByName(v_ds, v_arstr[v_arstr.Length - 1], ref v_dc_id);
// m_cbo_ma_quyet_dinh.SelectedValue = v_dc_id;
m_txt_ma_quyet_dinh.Text = v_us_qd.strMA_QUYET_DINH;
m_us_quyet_dinh.DataRow2Me((DataRow)m_ds_quyet_dinh.DM_QUYET_DINH.Rows[0]);
m_cbo_loai_quyet_dinh.SelectedValue = m_us_quyet_dinh.dcID_LOAI_QD;
m_dat_ngay_ky.Value = m_us_quyet_dinh.datNGAY_KY;
if (m_us_quyet_dinh.datNGAY_CO_HIEU_LUC > DateTime.Parse("01/01/1900"))
{
m_dat_ngay_co_hieu_luc_qd.Value = m_us_quyet_dinh.datNGAY_CO_HIEU_LUC;
}
// else
// m_dat_ngay_co_hieu_luc_qd.Checked = false;
if (m_us_quyet_dinh.datNGAY_HET_HIEU_LUC != null && m_us_quyet_dinh.datNGAY_HET_HIEU_LUC > DateTime.Parse("01/01/1900"))
{
m_dat_ngay_het_hieu_luc_qd.Checked = true;
m_dat_ngay_het_hieu_luc_qd.Value = m_us_quyet_dinh.datNGAY_HET_HIEU_LUC;
}
else
{
m_dat_ngay_het_hieu_luc_qd.Checked = false;
}
m_lbl_file_name.Text = v_us_qd.strLINK;
m_txt_noi_dung.Text = m_us_quyet_dinh.strNOI_DUNG;
m_ofd_chon_file.FileName = m_us_quyet_dinh.strLINK;
}
else
{
m_txt_ma_quyet_dinh.Text = "";
m_cbo_loai_quyet_dinh.SelectedIndex = 0;
m_dat_ngay_ky.Checked = false;
m_dat_ngay_co_hieu_luc_qd.Checked = false;
m_dat_ngay_het_hieu_luc_qd.Checked = false;
m_txt_noi_dung.Text = "";
m_ofd_chon_file.FileName = "";
}
if (m_us_v_trang_thai_ld.strTRANG_THAI_HIEN_TAI_YN == "Y")
{
m_ckb_trang_thai_hien_tai_yn.Checked = true;
}
else
{
m_ckb_trang_thai_hien_tai_yn.Checked = false;
}
break;
case DataEntryFormMode.ViewDataState:
if (m_us_v_trang_thai_ld.datNGAY_CO_HIEU_LUC > DateTime.Parse("01/01/1900"))
{
m_dat_ngay_co_hieu_luc.Value = m_us_v_trang_thai_ld.datNGAY_CO_HIEU_LUC;
}
else
{
m_dat_ngay_co_hieu_luc.Checked = false;
}
if (m_us_v_trang_thai_ld.datNGAY_HET_HIEU_LUC != null && m_us_v_trang_thai_ld.datNGAY_HET_HIEU_LUC > DateTime.Parse("01/01/1900"))
{
m_dat_ngay_het_hieu_luc.Checked = true;
m_dat_ngay_het_hieu_luc.Value = m_us_v_trang_thai_ld.datNGAY_HET_HIEU_LUC;
}
else
{
m_dat_ngay_het_hieu_luc.Checked = false;
}
m_us_quyet_dinh.FillDataset_By_Ma_qd(m_ds_quyet_dinh, m_us_v_trang_thai_ld.strMA_QUYET_DINH);
if (m_ds_quyet_dinh.DM_QUYET_DINH.Select("MA_QUYET_DINH is not null").Length > 0)
{
m_txt_ma_quyet_dinh.Text = m_us_v_trang_thai_ld.strMA_QUYET_DINH;
m_us_quyet_dinh.DataRow2Me((DataRow)m_ds_quyet_dinh.DM_QUYET_DINH.Rows[0]);
m_cbo_loai_quyet_dinh.SelectedValue = m_us_quyet_dinh.dcID_LOAI_QD;
m_dat_ngay_ky.Value = m_us_quyet_dinh.datNGAY_KY;
if (m_us_quyet_dinh.datNGAY_CO_HIEU_LUC > DateTime.Parse("01/01/1900"))
{
m_dat_ngay_co_hieu_luc_qd.Value = m_us_quyet_dinh.datNGAY_CO_HIEU_LUC;
}
else
{
m_dat_ngay_co_hieu_luc_qd.Checked = false;
}
if (m_us_quyet_dinh.datNGAY_HET_HIEU_LUC != null)
{
m_dat_ngay_het_hieu_luc_qd.Value = m_us_quyet_dinh.datNGAY_HET_HIEU_LUC;
}
else
{
m_dat_ngay_het_hieu_luc_qd.Checked = false;
}
m_txt_noi_dung.Text = m_us_quyet_dinh.strNOI_DUNG;
m_ofd_chon_file.FileName = m_us_quyet_dinh.strLINK;
}
else
{
m_txt_ma_quyet_dinh.Text = "";
m_cbo_loai_quyet_dinh.SelectedIndex = 0;
m_dat_ngay_ky.Checked = false;
m_dat_ngay_co_hieu_luc_qd.Checked = false;
m_dat_ngay_het_hieu_luc_qd.Checked = false;
m_txt_noi_dung.Text = "";
m_ofd_chon_file.FileName = "";
}
m_txt_noi_dung.ReadOnly = true;
m_txt_noi_dung.BackColor = SystemColors.Info;
m_txt_ma_quyet_dinh.ReadOnly = true;
m_txt_ma_quyet_dinh.BackColor = SystemColors.Info;
m_txt_trang_thai_hien_tai.ReadOnly = true;
m_txt_trang_thai_hien_tai.BackColor = SystemColors.Info;
m_cbo_loai_quyet_dinh.Enabled = false;
m_cbo_trang_thai_moi.Visible = false;
m_lbl_trang_thai_moi.Visible = false;
m_dat_ngay_co_hieu_luc.Enabled = false;
m_dat_ngay_co_hieu_luc_qd.Enabled = false;
m_dat_ngay_co_hieu_luc.Enabled = false;
m_dat_ngay_ky.Enabled = false;
break;
default: break;
}
}
private decimal insert_quyet_dinh()
{
US_DM_QUYET_DINH v_us = new US_DM_QUYET_DINH();
//if (m_rdb_kh_dau_nam.Checked == true)
//{
// v_us.dcID_LOAI_QUYET_DINH_GIAO = ID_LOAI_GIAO_DICH.KH_DAU_NAM;
//}
//else if (m_rdb_bo_sung.Checked == true)
//{
// v_us.dcID_LOAI_QUYET_DINH_GIAO = ID_LOAI_GIAO_DICH.BO_SUNG;
//}
//else v_us.dcID_LOAI_QUYET_DINH_GIAO = ID_LOAI_GIAO_DICH.DIEU_CHINH;
v_us.dcID_DON_VI = Person.get_id_don_vi();
v_us.dcID_LOAI_QUYET_DINH = ID_LOAI_QUYET_DINH.GIAO_VON;
v_us.strNOI_DUNG = m_txt_noi_dung.Text.Trim();
v_us.strSO_QUYET_DINH = m_txt_so_qd.Text.Trim();
//v_us.datNGAY_THANG = CIPConvert.ToDatetime(m_txt_ngay_thang.Text.Trim(), "dd/MM/yyyy");
v_us.Insert();
return v_us.dcID;
}
private bool check_validate_data_is_ok()
{
//Kiem tra trùng Số quyết định
if (get_form_mode(m_hdf_form_mode) == LOAI_FORM.THEM)
{
/*
* Kiem tra trung so quyet dinh
* Neu co quyet dinh co So quyet dinh thi return false
*
*/
if (getCountQuyetDinhCoSo(m_txt_so_quyet_dinh.Text.Trim()) > 0)
{
m_lbl_mess.Text = "Đã có Số quyết định " + m_txt_so_quyet_dinh.Text + ", Bạn hãy nhập Số quyết định khác!";
return false;
}
}
else if (get_form_mode(m_hdf_form_mode) == LOAI_FORM.SUA)
{
/*
*Kiem tra xem, So quyet dinh X
*Co the giong so hien tai va phai khac voi tat ca cac So quyet dinh
*/
//Nếu không thay đổi Số QĐ thì ok
US_DM_QUYET_DINH v_us = new US_DM_QUYET_DINH(CIPConvert.ToDecimal(m_hdf_id_quyet_dinh.Value));
if (!v_us.strSO_QUYET_DINH.Equals(m_txt_so_quyet_dinh.Text.Trim()))
//Nếu thay đổi Số QĐ thì phải kiểm tra xem có trùng với Số QĐ cũ không
if (getCountQuyetDinhCoSo(m_txt_so_quyet_dinh.Text.Trim()) > 0)
{
m_lbl_mess.Text = "Đã có Số quyết định " + m_txt_so_quyet_dinh.Text + ", Bạn hãy nhập Số quyết định khác!";
return false;
}
}
else if (get_form_mode(m_hdf_form_mode) == LOAI_FORM.XOA)
{
/*
* Thong bao: Co x don vi da nhap du lieu cua quyet dinh nay, ban co muon xoa du lieu
* Hoi nguoi dung co that su muon xoa khong, neu xoa thi se xoa het du lieu cua quyet dinh nay
*/
//return false;
}
if (get_form_mode(m_hdf_form_mode) == LOAI_FORM.SUA || get_form_mode(m_hdf_form_mode) == LOAI_FORM.THEM)
{
if (!CValidateTextBox.IsValid(m_txt_so_quyet_dinh, DataType.StringType, allowNull.NO))
{
m_lbl_mess.Text = "Bạn phải nhập Số quyết định!";
m_txt_so_quyet_dinh.Focus();
return false;
}
if (!CValidateTextBox.IsValid(m_txt_noi_dung, DataType.StringType, allowNull.NO))
{
m_lbl_mess.Text = "Bạn phải nhập Nội dung!";
m_txt_noi_dung.Focus();
return false;
}
if (!CValidateTextBox.IsValid(m_txt_ngay_thang, DataType.DateType, allowNull.NO))
{
m_lbl_mess.Text = "Bạn phải nhập Ngày tháng định dạng dd/MM/yyyy!";
m_txt_ngay_thang.Focus();
return false;
}
}
return true;
}
private void load_data_cong_trinh_du_an_giao_kh_to_ddl(DropDownList op_ddl, WinFormControls.LOAI_DU_AN ip_loai_du_an)
{
if (m_hdf_id_quyet_dinh.Value.Trim().Equals("") | m_hdf_id_quyet_dinh.Value.Trim().Equals("-1"))
{
op_ddl.Items.Clear();
}
else
{
US_DM_QUYET_DINH v_us_quyet_dinh = new US_DM_QUYET_DINH(CIPConvert.ToDecimal(m_hdf_id_quyet_dinh.Value));
DateTime v_dat_dau_nam = v_us_quyet_dinh.datNGAY_THANG;
v_dat_dau_nam = v_dat_dau_nam.AddDays(-v_dat_dau_nam.Day + 1);
v_dat_dau_nam = v_dat_dau_nam.AddMonths(-v_dat_dau_nam.Month + 1);
DateTime v_dat_cuoi_nam = v_dat_dau_nam.AddYears(1);
WinFormControls.load_data_to_cbo_du_an_cong_trinh_from_giao_kh(ip_loai_du_an
, op_ddl);
}
}
private int getCountQuyetDinhCoSo(string ip_str_so_quyet_dinh)
{
DS_DM_QUYET_DINH v_ds = new DS_DM_QUYET_DINH();
US_DM_QUYET_DINH v_us = new US_DM_QUYET_DINH();
v_us.FillDataset(v_ds, "where " + DM_QUYET_DINH.SO_QUYET_DINH + " = N'" + ip_str_so_quyet_dinh + "'");
return v_ds.DM_QUYET_DINH.Count;
}
private void load_data_when_quyet_dinh_is_selected()
{
m_txt_so_qd.Visible = false;
m_txt_noi_dung.Visible = true;
//m_txt_ngay_thang.Visible = true;
disable_edit_quyet_dinh();
if (CIPConvert.ToDecimal(m_ddl_quyet_dinh.SelectedValue) < 0) return;
US_DM_QUYET_DINH v_us = new US_DM_QUYET_DINH(CIPConvert.ToDecimal(m_ddl_quyet_dinh.SelectedValue)); ;
m_txt_so_qd.Text = v_us.strSO_QUYET_DINH;
m_txt_noi_dung.Text = v_us.strNOI_DUNG;
//m_txt_ngay_thang.Text = CIPConvert.ToStr(v_us.datNGAY_THANG, "dd/MM/yyyy");
m_lbl_ngay_thang.Text = CIPConvert.ToStr(v_us.datNGAY_THANG, "dd/MM/yyyy");
//reload_data_to_ddl();
load_data_to_grid();
}
private List<decimal> getDanhSachQDGiaoVon()
{
DateTime v_dat_tu_ngay = CIPConvert.ToDatetime(m_txt_tu_ngay.Text, c_configuration.DEFAULT_DATETIME_FORMAT);
DateTime v_dat_den_ngay = CIPConvert.ToDatetime(m_txt_den_ngay.Text, c_configuration.DEFAULT_DATETIME_FORMAT);
List<decimal> v_lst = new List<decimal>();
US_DM_QUYET_DINH v_us = new US_DM_QUYET_DINH();
DS_DM_QUYET_DINH v_ds = new DS_DM_QUYET_DINH();
v_us.FillDatasetByLoaiQD(v_ds, v_dat_tu_ngay, v_dat_den_ngay, c_configuration.GIAO_VON, -1);
for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
{
v_lst.Add(CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i][DM_QUYET_DINH.ID].ToString()));
}
return v_lst;
}
public void get_us(ref US_DM_QUYET_DINH op_us)
{
op_us = m_us;
}
private void load_data_to_grid()
{
try
{
//Kiem tra neu khong phai la don vi nhap thi chi cho xem
if (m_ddl_don_vi.SelectedValue != Person.get_id_don_vi().ToString())
{
m_grv.Columns[0].Visible = false;
m_cmd_insert.Visible = false;
m_cmd_update.Visible = false;
m_cmd_cancel.Visible = false;
}
else
{
m_grv.Columns[0].Visible = true;
if (get_form_mode(m_hdf_form_mode) == LOAI_FORM.SUA)
{
m_cmd_update.Visible = true;
m_cmd_cancel.Visible = true;
}
else if (get_form_mode(m_hdf_form_mode) == LOAI_FORM.THEM)
{
m_cmd_insert.Visible = true;
m_cmd_cancel.Visible = true;
}
}
//decimal v_id_dc_loai = 1;
decimal v_id_dc_reported_user;
// Chú thích: id_dc_loai = 1 - Loại dự án
// id_dc_loai = 2 - CLKM
//Kiểm tra xem thuộc loại nào:
//if (m_rdb_theo_quoc_lo.Checked == true)
//{
// v_id_dc_loai = 1;
//}
//if (m_rdb_theo_chuong_loai_khoan_muc.Checked == true)
//{
// v_id_dc_loai = 2;
//}
//Lấy id_reported_user
v_id_dc_reported_user = Person.get_user_id();
//1. Get dataset
DS_GRID_GIAO_KH v_ds = new DS_GRID_GIAO_KH();
//2. Lay du lieu
US_GRID_GIAO_KH v_us = new US_GRID_GIAO_KH();
decimal v_dc_id_quyet_dinh = -1;
if (m_hdf_id_quyet_dinh.Value.Trim().Equals(""))
{
v_dc_id_quyet_dinh = -1;
}
else
v_dc_id_quyet_dinh = CIPConvert.ToDecimal(m_hdf_id_quyet_dinh.Value);
if (v_dc_id_quyet_dinh != -1)
{
US_DM_QUYET_DINH v_us_qd = new US_DM_QUYET_DINH(v_dc_id_quyet_dinh);
m_lbl_grid_ngay.Text = CIPConvert.ToStr(v_us_qd.datNGAY_THANG, "dd/MM/yyyy");
m_lbl_grid_so_quyet_dinh.Text = v_us_qd.strSO_QUYET_DINH;
m_lbl_grid_ve_viec.Text = v_us_qd.strNOI_DUNG;
}
//kiem tra xem dang nhap Nguon nao
string v_str_is_nguon_ns = "N";
if (Request.QueryString["ip_nguon_ns"] == "Y")
{
v_str_is_nguon_ns = "Y";
}
if (v_dc_id_quyet_dinh < 0) return;
v_us.get_grid_giao_kh_qbt(v_ds
, v_dc_id_quyet_dinh
, v_str_is_nguon_ns
, v_id_dc_reported_user
, CIPConvert.ToDecimal(m_ddl_don_vi.SelectedValue));
m_grv.DataSource = v_ds.Tables[0];
m_grv.DataBind();
if (!m_hdf_id_giao_kh.Value.Equals(""))
{
m_grv.SelectedIndex = -1;
for (int i = 0; i < m_grv.Rows.Count; i++)
if (CIPConvert.ToDecimal(m_grv.DataKeys[i].Value) == CIPConvert.ToDecimal(m_hdf_id_giao_kh.Value)) m_grv.SelectedIndex = i;
}
//get tong tien
decimal v_dc_tong_tien = 0;
for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
{
if (v_ds.Tables[0].Rows[i][GRID_GIAO_KH.ID].ToString() != "-1")
{
v_dc_tong_tien += get_so_tien(v_ds.Tables[0].Rows[i][GRID_GIAO_KH.NTCT].ToString()) +
get_so_tien(v_ds.Tables[0].Rows[i][GRID_GIAO_KH.NS].ToString()) +
get_so_tien(v_ds.Tables[0].Rows[i][GRID_GIAO_KH.QUY].ToString());
}
}
m_lbl_grid_tong_tien.Text = CIPConvert.ToStr(v_dc_tong_tien, "#,###,##");
}
catch (Exception v_e)
{
m_lbl_mess_grid.Text = v_e.ToString();
}
}
private string get_header_text(string p, int ip_index)
{
string v_res = "";
var v_arr = p.Split('_');
if (v_arr[0].Contains("KTC")) {
v_res += "Không T.Chủ";
}
else if (v_arr[0].Contains("TC")) {
v_res += "T.Chủ";
}
else {
v_res += "Tổng";
}
if (ip_index % 3 == 0) {
US_DM_QUYET_DINH v_us_quyet_dinh = new US_DM_QUYET_DINH(CIPConvert.ToDecimal(v_arr[1]));
m_lst_str_header.Add(v_us_quyet_dinh.strSO_QUYET_DINH);
}
return v_res;
}
private void save_data()
{
m_lbl_mess_detail.Text = "";
m_lbl_mess_detail.Visible = true;
m_lbl_mess_ghi_du_lieu.Text = "";
if (!check_validate_data_gd_is_ok()) return;
if (!form_to_us_object()) return;
switch (get_form_mode(m_hdf_form_mode))
{
case LOAI_FORM.THEM:
m_us.Insert();
m_lbl_mess_ghi_du_lieu.Text = "Bạn đã ghi dữ liệu thành công!";
break;
case LOAI_FORM.SUA:
try
{
//m_us.BeginTransaction();
US_DM_QUYET_DINH v_us_quyet_dinh = new US_DM_QUYET_DINH(CIPConvert.ToDecimal(m_hdf_id_quyet_dinh.Value));
US_GD_CHI_TIET_GIAO_KH v_us_ten_cu = new US_GD_CHI_TIET_GIAO_KH(CIPConvert.ToDecimal(m_hdf_id_giao_kh.Value));
//m_us.update_ten_du_an_giao_kh_to_giao_von_va_unc(Person.get_id_don_vi()
// , v_us_ten_cu.dcID_LOAI_NHIEM_VU
// , v_us_ten_cu.dcID_DU_AN_CONG_TRINH
// , v_us_ten_cu.strTEN_DU_AN
// , m_us.strTEN_DU_AN
// , WinFormControls.get_dau_nam_form_date(v_us_quyet_dinh.datNGAY_THANG)
// , WinFormControls.get_cuoi_nam_form_date(v_us_quyet_dinh.datNGAY_THANG));
m_us.Update();
m_lbl_mess_ghi_du_lieu.Text = "Bạn đã cập nhật dữ liệu thành công!";
//m_us.CommitTransaction();
}
catch (Exception)
{
//m_us.Rollback();
m_lbl_mess_ghi_du_lieu.Text = "Quá trình cập nhật xảy ra lỗi, bạn vui lòng thực hiện lại thao tác!";
}
break;
}
xoa_trang();
//m_ddl_du_an.SelectedValue = "-1";
load_data_to_grid();
}
//protected void m_grv_RowDataBound(object sender, GridViewRowEventArgs e)
//{
// try
// {
// if (e.Row.RowType == DataControlRowType.Header)
// {
// for (int i = 6; i < e.Row.Cells.Count; i++)
// {
// US_DM_QUYET_DINH v_us_qd = new US_DM_QUYET_DINH();
// DS_DM_QUYET_DINH v_ds_qd = new DS_DM_QUYET_DINH();
// v_us_qd.FillDataset(v_ds_qd, "where " + DM_QUYET_DINH.SO_QUYET_DINH + " = N'" + e.Row.Cells[i].Text + "'");
// if (v_ds_qd.DM_QUYET_DINH.Count > 0)
// {
// e.Row.Cells[i].Text = "QĐ số " + v_ds_qd.Tables[0].Rows[0][DM_QUYET_DINH.SO_QUYET_DINH] + " ngày " +
// CIPConvert.ToStr(v_ds_qd.Tables[0].Rows[0][DM_QUYET_DINH.NGAY_THANG], "dd/MM/yyyy");
// }
// }
// }
// }
// catch (Exception v_e)
// {
// CSystemLog_301.ExceptionHandle(this, v_e);
// }
//}
protected void m_grv_RowDataBound(object sender, GridViewRowEventArgs e)
{
try
{
if (e.Row.RowType == DataControlRowType.Header)
{
for (int i = 0; i < e.Row.Controls.Count; i++)
{
var headerCell = e.Row.Controls[i] as DataControlFieldHeaderCell;
if (headerCell != null)
{
US_DM_QUYET_DINH v_us_qd = new US_DM_QUYET_DINH();
DS_DM_QUYET_DINH v_ds_qd = new DS_DM_QUYET_DINH();
v_us_qd.FillDataset(v_ds_qd, "where " + DM_QUYET_DINH.SO_QUYET_DINH + " = N'" + headerCell.ContainingField.ToString().Trim() + "'");
if (v_ds_qd.DM_QUYET_DINH.Count > 0)
{
headerCell.Text = "QĐ số " + v_ds_qd.Tables[0].Rows[0][DM_QUYET_DINH.SO_QUYET_DINH] + " ngày " +
CIPConvert.ToStr(v_ds_qd.Tables[0].Rows[0][DM_QUYET_DINH.NGAY_THANG], "dd/MM/yyyy");
}
}
}
}
else if (e.Row.RowType == DataControlRowType.DataRow)
{
if (m_grv.DataKeys[e.Row.RowIndex].Value.ToString().Trim().Equals(""))
{
e.Row.Font.Bold = true;
}
e.Row.Cells[1].Width = 200;
for (int i = 7; i < e.Row.Controls.Count; i++)
{
Label v_lbl = new Label();
if (e.Row.Cells[i] == null)
return;
decimal v_i_so_tien = 0;
bool v_b_is_number = decimal.TryParse(e.Row.Cells[i].Text, out v_i_so_tien);
if (v_b_is_number)
{
v_lbl.Text = CIPConvert.ToStr(WebformControls.get_so_tien(e.Row.Cells[i].Text), "#,###,##");
}
e.Row.Cells[i].Controls.Add(v_lbl);
e.Row.Cells[i].CssClass = "csscurrency";
e.Row.Cells[i].Width = 80;
}
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
public void display_for_view_quyet_dinh(US_DM_QUYET_DINH ip_us)
{
m_us_dm_quyet_dinh = ip_us;
this.ShowDialog();
}
