protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!this.IsPostBack)
{
load_2_cbo_don_vi_tt();
load_2_cbo_giang_vien();
load_2_cbo_trang_thai_hd();
load_2_cbo_don_vi_quan_ly();
load_2_cbo_loai_hop_dong();
load_2_cbo_po_phu_trach();
load_2_cbo_mon_hoc_1();
load_2_cbo_mon_hoc_2();
load_2_cbo_mon_hoc_3();
load_2_cbo_mon_hoc_4();
load_2_cbo_mon_hoc_5();
load_2_cbo_mon_hoc_6();
if (Request.QueryString["mode"] != null && Request.QueryString["mode"].ToString().Equals("edit"))
{
// Load data need to update - if mode = update
load_data_2_us_by_id_and_show_on_form(CIPConvert.ToDecimal(Request.QueryString["id"]));
}
//else
//{
// if (Session["UserName"] != null)
// {
// // m_cbo_po_phu_trach_chinh.SelectedValue = CIPConvert.ToStr(Session["UserName"]);
// //m_cbo_po_phu_trach.ToolTip = CIPConvert.ToStr(Session["UserName"]);
// }
//}
}
if (Request.QueryString["mode"] != null && Request.QueryString["mode"].ToString().Equals("edit"))
{
m_init_mode = DataEntryFormMode.UpdateDataState;
m_dc_id = CIPConvert.ToDecimal(Request.QueryString["id"]);
}
else
{
m_init_mode = DataEntryFormMode.InsertDataState;
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
public string get_so_tien_thanh_toan(object ip_obj_so_luong_nghiem_thu, object ip_obj_don_gia)
{
string v_str_so_tien_thanh_toan = "";
if (ip_obj_so_luong_nghiem_thu.GetType() == typeof(DBNull) || ip_obj_don_gia.GetType() == typeof(DBNull))
{
v_str_so_tien_thanh_toan = "";
}
else
{
v_str_so_tien_thanh_toan = CIPConvert.ToStr(CIPConvert.ToDecimal(ip_obj_don_gia) * CIPConvert.ToDecimal(ip_obj_so_luong_nghiem_thu), "#,###");
}
return(v_str_so_tien_thanh_toan);
}
private void m_cbo_hoc_ky_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (m_bol_check)
{
load_data_2_grid(CIPConvert.ToDecimal(m_cbo_lop_sinh_vien.SelectedValue.ToString()));
}
}
catch (Exception)
{
MessageBox.Show("Đã xảy ra lỗi trong hệ thống!");
}
}
private void form_2_us_object(US_V_GD_THANH_TOAN_DETAIL op_us_gd_thanh_toan_detail)
{
try
{
op_us_gd_thanh_toan_detail.dcID_NOI_DUNG_THANH_TOAN = CIPConvert.ToDecimal(m_cbo_noi_dung_tt.SelectedValue);
op_us_gd_thanh_toan_detail.dcDON_GIA_TT = CIPConvert.ToDecimal(m_txt_don_gia_hd.Text.Trim());
op_us_gd_thanh_toan_detail.dcSO_LUONG_HE_SO = CIPConvert.ToDecimal(m_txt_so_luong_he_so.Text.Trim());
op_us_gd_thanh_toan_detail.dcID_GD_THANH_TOAN = CIPConvert.ToDecimal(Request.QueryString["id_gdtt"]);
op_us_gd_thanh_toan_detail.strDESCRIPTION = m_txt_description.Text;
}
catch (Exception v_e)
{
throw v_e;
}
}
protected void m_cbo_noi_dung_thanh_toan_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
decimal v_dc_id_noi_dung_tt = CIPConvert.ToDecimal(m_cbo_noi_dung_thanh_toan.SelectedValue);
US_V_DM_NOI_DUNG_THANH_TOAN v_us_dm_noi_dung_tt = new US_V_DM_NOI_DUNG_THANH_TOAN(v_dc_id_noi_dung_tt);
m_txt_don_gia.Text = CIPConvert.ToStr(v_us_dm_noi_dung_tt.dcDON_GIA_DEFAULT, "#,###");
m_txt_so_luong.Text = CIPConvert.ToStr(v_us_dm_noi_dung_tt.dcSO_LUONG_HE_SO_DEFAULT, "#,#");
m_lbl_don_vi.Text = v_us_dm_noi_dung_tt.strDON_VI_TINH;
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
// Chỉ load lên những đợt thanh toán chưa kết thúc
private void load_data_2_cbo_dot_thanh_toan()
{
DS_V_DM_DOT_THANH_TOAN v_ds_dot_thanh_toan = new DS_V_DM_DOT_THANH_TOAN();
US_V_DM_DOT_THANH_TOAN v_us_dot_thanh_toan = new US_V_DM_DOT_THANH_TOAN();
v_us_dot_thanh_toan.load_dot_thanh_toan_by_trang_thai(ID_TRANG_THAI_DOT_TT.DA_LAP_DOT, v_ds_dot_thanh_toan);
//v_us_dot_thanh_toan.FillDataset(v_ds_dot_thanh_toan, " WHERE ID_TRANG_THAI_DOT_TT = " + get_id_trang_thai_dot_tt_da_lap_dot()+" ORDER BY ID DESC");
for (int i = 0; i < v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN.Rows.Count; i++)
{
if (CIPConvert.ToDecimal(v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN.Rows[i][V_DM_DOT_THANH_TOAN.ID]) != get_id_of_dot_tt_kho())
{
m_cbo_dot_thanh_toan.Items.Add(new ListItem(CIPConvert.ToStr(v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN.Rows[i][V_DM_DOT_THANH_TOAN.TEN_DOT_TT]), CIPConvert.ToStr(v_ds_dot_thanh_toan.V_DM_DOT_THANH_TOAN.Rows[i][V_DM_DOT_THANH_TOAN.ID])));
}
}
}
private void delete_dm_hd_khung(int ip_i_row_del)
{
try
{
decimal v_dc_id_id_hd_khung = CIPConvert.ToDecimal(m_grv_dm_danh_sach_hop_dong_khung.DataKeys[ip_i_row_del].Value);
m_us_dm_hop_dong_khung.dcID = v_dc_id_id_hd_khung;
m_us_dm_hop_dong_khung.DeleteByID(v_dc_id_id_hd_khung);
m_lbl_thong_bao.Text = "Xóa bản ghi thành công";
get_form_search_data_and_load_to_grid();
}
catch (Exception v_e)
{
throw v_e;
}
}
private void m_cmd_TM_huy_hon_hang_Click(object sender, EventArgs e)
{
try
{
DataRow v_dr = m_grv_ds_don_dat_hang_can_nghiem_thu.GetDataRow(m_grv_ds_don_dat_hang_can_nghiem_thu.FocusedRowHandle);
m_us = new US_GD_DAT_HANG(CIPConvert.ToDecimal(v_dr["ID"].ToString()));
f103_TD_ly_do_tu_choi f103 = new f103_TD_ly_do_tu_choi();
f103.Display(m_us);
load_data_to_grid();
}
catch (Exception v_e)
{
CSystemLog_100.ExceptionHandle(v_e);
}
}
protected void m_grv_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
try
{
m_lbl_mess.Text = "";
m_e_form_mode = DataEntryFormMode.UpdateDataState;
m_hdf_id.Value = CIPConvert.ToStr(this.m_grv.DataKeys[e.NewSelectedIndex].Value);
m_us_gd_lop_mon_detail = new US_GD_LOP_MON_DETAIL(CIPConvert.ToDecimal(this.m_grv.DataKeys[e.NewSelectedIndex].Value));
us_object_2_form();
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
private void when_cbo_dot_tt_changed()
{
if (m_cbo_dot_thanh_toan.Items.Count == 0)
{
m_cmd_search.Enabled = false;
return;
}
m_cmd_search.Enabled = true;
decimal v_dc_id_dot_thanh_toan = CIPConvert.ToDecimal(m_cbo_dot_thanh_toan.SelectedValue);
US_V_DM_DOT_THANH_TOAN v_us_dot_thanh_toan = new US_V_DM_DOT_THANH_TOAN(v_dc_id_dot_thanh_toan);
m_dat_ngay_thanh_toan.SelectedDate = v_us_dot_thanh_toan.datNGAY_TT_DU_KIEN;
// Chỉ lấy toàn bộ các thanh toán trong KHO
load_data_2_grid_search_trang_thai(hdf_ma_dot_tt_kho.Value, CIPConvert.ToDecimal(m_hdf_id_trang_thai_thanh_toan_chua_duoc_thanh_toan.Value));
}
protected void m_grv_gd_assign_su_kien_cho_giang_vien_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
decimal v_dc_id_cv_gv = CIPConvert.ToDecimal(m_grv_gd_assign_su_kien_cho_giang_vien.DataKeys[e.RowIndex].Value);
m_us_cong_viec_moi.DeleteByID(v_dc_id_cv_gv);
m_lbl_thong_bao_sau_cap_nhat.Text = " * Xóa bản ghi thành công !";
load_data_2_grv();
m_cbo_so_hop_dong_loc.ToolTip = "";
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
private void load_data_2_export_excel()
{
if (rdl_trang_thai_tt_check.Items[0].Selected)
{
load_data_2_grid(get_ma_dot_tt_by_id_dot(CIPConvert.ToDecimal(m_cbo_dot_thanh_toan.SelectedValue)));
}
else if (rdl_trang_thai_tt_check.Items[1].Selected)
{
m_us_v_gd_thanh_toan.f412_load_thanh_toan_by_ma_dot_tt_va_trang_thai_tt_va_loai_hd(get_ma_dot_tt_by_id_dot(CIPConvert.ToDecimal(m_cbo_dot_thanh_toan.SelectedValue)), ID_TRANG_THAI_THANH_TOAN.CHUNG_TU_DA_DUOC_DUYET, "HL", m_v_ds_gd_thanh_toan, CIPConvert.ToStr(Session["UserName"]));
}
else
{
m_us_v_gd_thanh_toan.f412_load_thanh_toan_by_ma_dot_tt_va_trang_thai_tt_va_loai_hd(get_ma_dot_tt_by_id_dot(CIPConvert.ToDecimal(m_cbo_dot_thanh_toan.SelectedValue)), ID_TRANG_THAI_THANH_TOAN.CHUNG_TU_KHONG_DUOC_DUYET, "HL", m_v_ds_gd_thanh_toan, CIPConvert.ToStr(Session["UserName"]));
}
}
internal void display_for_refurse_dealine(decimal deadline_id)
{
try
{
DataRow v_dr = m_grv_ds_don_dat_hang.GetDataRow(m_grv_ds_don_dat_hang.FocusedRowHandle);
m_us = new US_GD_DAT_HANG(CIPConvert.ToDecimal(v_dr["ID"].ToString()));
this.Show();
v_deadline = deadline_id;
load_data_2_grid();
}
catch (Exception v_e)
{
CSystemLog_100.ExceptionHandle(v_e);
}
}
private void m_cmd_chinh_sua_don_hang_Click(object sender, EventArgs e)
{
try
{
DataRow v_dr = m_grv_ds_don_dat_hang.GetDataRow(m_grv_ds_don_dat_hang.FocusedRowHandle);
US_GD_DAT_HANG v_us = new US_GD_DAT_HANG(CIPConvert.ToDecimal(v_dr["ID"].ToString()));
f100_don_dat_hang_new v_f100 = new f100_don_dat_hang_new();
v_f100.displayForUpdate(v_us, v_deadline);
load_data_2_grid();
}
catch (Exception v_e)
{
CSystemLog_100.ExceptionHandle(v_e);
}
}
protected void m_grv_dm_chuc_nang_he_thong_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
m_lbl_mess.Text = "";
delete_dm_chuc_nang(e.RowIndex);
load_data_2_grid(CIPConvert.ToDecimal(m_cbo_chuc_nang_cap_1.SelectedValue));
m_lbl_mess.Text = "Xóa bản ghi thành công!";
}
catch (Exception v_e)
{
// de su dung CsystemLog_301 bat buoc Site phai dat trong thu muc cap 1. Vi du: DanhMuc/Dictionary.aspx
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
private void when_cbo_dot_tt_changed()
{
if (m_cbo_dot_thanh_toan.Items.Count == 0)
{
m_lbl_thong_bao0.Text = "Chưa có đợt thanh toán nào";
m_cmd_search.Enabled = false;
return;
}
m_cmd_search.Enabled = true;
decimal v_dc_id_dot_thanh_toan = CIPConvert.ToDecimal(m_cbo_dot_thanh_toan.SelectedValue);
US_V_DM_DOT_THANH_TOAN v_us_dot_thanh_toan = new US_V_DM_DOT_THANH_TOAN(v_dc_id_dot_thanh_toan);
m_dat_ngay_thanh_toan.SelectedDate = v_us_dot_thanh_toan.datNGAY_TT_DU_KIEN;
load_data_2_grid(get_ma_dot_tt_by_id_dot(CIPConvert.ToDecimal(m_cbo_dot_thanh_toan.SelectedValue)));
}
public string get_mapping_ten_giang_vien(object i_dc_id_giang_vien)
{
string v_str_ten_giang_vien = "";
try
{
US_V_DM_GIANG_VIEN v_us_dm_giang_vien = new US_V_DM_GIANG_VIEN(CIPConvert.ToDecimal(i_dc_id_giang_vien));
v_str_ten_giang_vien = v_us_dm_giang_vien.strHO_VA_TEN_DEM.TrimEnd() + " " + v_us_dm_giang_vien.strTEN_GIANG_VIEN;
}
catch (Exception v_e)
{
throw v_e;
}
return(v_str_ten_giang_vien);
}
private void delete_dm_tu_dien(int i_int_row_index)
{
try
{
decimal v_dc_id = CIPConvert.ToDecimal(m_grv.DataKeys[i_int_row_index].Value);
m_us_gd_lop_mon_detail.DeleteByID(v_dc_id);
load_data_2_grid();
m_lbl_mess.Text = "Xóa bản ghi thành công.";
}
catch (Exception v_e)
{
m_lbl_mess.Text = "Lỗi trong quá trình xóa bản ghi.";
throw v_e;
}
}
public string get_mapping_ten_loai_ho_so(object i_dc_id_loai_ho_so)
{
string v_str_ten_loai_ho_so = "";
try
{
US_CM_DM_TU_DIEN v_us_dm_tu_dien = new US_CM_DM_TU_DIEN(CIPConvert.ToDecimal(i_dc_id_loai_ho_so));
v_str_ten_loai_ho_so = v_us_dm_tu_dien.strTEN;
}
catch (Exception v_e)
{
throw v_e;
}
return(v_str_ten_loai_ho_so);
}
private void m_cmd_TM_danh_gia_Click(object sender, EventArgs e)
{
try
{
DataRow v_dr = m_grv_ds_don_dat_hang_can_nghiem_thu.GetDataRow(m_grv_ds_don_dat_hang_can_nghiem_thu.FocusedRowHandle);
m_us = new US_GD_DAT_HANG(CIPConvert.ToDecimal(v_dr["ID"].ToString()));
f115_TM_danh_gia v_f115 = new f115_TM_danh_gia();
v_f115.displayForTM(m_us);
load_data_to_grid();;
}
catch (Exception v_e)
{
CSystemLog_100.ExceptionHandle(v_e);
}
}
public string get_mapping_loai_giang_vien(object i_dc_id_giang_vien)
{
string v_str_loai_giang_vien = "";
try
{
US_V_DM_GIANG_VIEN v_us_dm_giang_vien = new US_V_DM_GIANG_VIEN(CIPConvert.ToDecimal(i_dc_id_giang_vien));
v_str_loai_giang_vien = v_us_dm_giang_vien.strGVHD_YN.Trim() + v_us_dm_giang_vien.strGVCM_YN.Trim();
}
catch (Exception v_e)
{
throw v_e;
}
return(v_str_loai_giang_vien);
}
private void load_thong_tin_nguoi_dai_dien()
{
US_V_DM_NGUOI_DAI_DIEN v_us_ndd = new US_V_DM_NGUOI_DAI_DIEN(CIPConvert.ToDecimal(m_cbo_nguoi_dai_dien.SelectedValue));
m_txt_dien_thoai_ndd.Text = v_us_ndd.strNDD_DIEN_THOAI;
m_txt_dien_thoai_ndd.Enabled = false;
if (m_txt_dien_thoai_ndd.Text != "")
{
m_pic_call_ndd.Visible = true;
}
else
{
m_pic_call_ndd.Visible = false;
}
}
private void m_cmd_TM_cap_nhat_xu_ly_Click(object sender, EventArgs e)
{
try
{
f101_cap_nhat_xu_don_hang v_f = new f101_cap_nhat_xu_don_hang();
DataRow v_dr = m_grv_gd_dat_hang_gd_log_dat_hang.GetDataRow(m_grv_gd_dat_hang_gd_log_dat_hang.FocusedRowHandle);
US_GD_DAT_HANG v_us = new US_GD_DAT_HANG(CIPConvert.ToDecimal(v_dr["ID_DON_HANG"].ToString()));
v_f.Display_for_update(v_us);
load_data_2_grid();
}
catch (Exception v_e)
{
CSystemLog_100.ExceptionHandle(v_e);
}
}
private void load_data_2_cbo_hop_dong_loc()
{
US_V_DM_HOP_DONG_KHUNG v_us_v_dm_hop_dong_khung = new US_V_DM_HOP_DONG_KHUNG();
DS_V_DM_HOP_DONG_KHUNG v_ds_v_dm_hop_dong_khung = new DS_V_DM_HOP_DONG_KHUNG();
m_cbo_so_hop_dong.Items.Clear();
v_us_v_dm_hop_dong_khung.load_hop_dong_by_id_giang_vien_cm_da_ky(CIPConvert.ToDecimal(m_cbo_ten_giang_vien.SelectedValue), v_ds_v_dm_hop_dong_khung);
if (v_ds_v_dm_hop_dong_khung.V_DM_HOP_DONG_KHUNG.Rows.Count > 0)
{
for (int v_i = 0; v_i < v_ds_v_dm_hop_dong_khung.V_DM_HOP_DONG_KHUNG.Rows.Count; v_i++)
{
m_cbo_so_hop_dong.Items.Add(new ListItem(CIPConvert.ToStr(v_ds_v_dm_hop_dong_khung.V_DM_HOP_DONG_KHUNG.Rows[v_i][V_DM_HOP_DONG_KHUNG.SO_HOP_DONG]), CIPConvert.ToStr(v_ds_v_dm_hop_dong_khung.V_DM_HOP_DONG_KHUNG.Rows[v_i][V_DM_HOP_DONG_KHUNG.ID])));
}
}
}
//
//Event
//
protected void m_cmd_luu_du_lieu_Click(object sender, EventArgs e)
{
try
{
string v_str_trang_thai_thong_ket = m_cbo_trang_thai_thong_tin.SelectedValue;
m_us_dm_giang_vien.strCO_LOI_YN = v_str_trang_thai_thong_ket;
m_us_dm_giang_vien.dcID = CIPConvert.ToDecimal(m_txt_ma_giang_vien.ToolTip);
m_us_dm_giang_vien.thay_doi_trang_thai_thong_tin_ho_so();
m_lbl_mess.Text = "Đã phản hồi thành công trạng thái của hồ sơ!";
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
private bool check_nghiem_thu_va_thanh_toan_update(decimal ip_dc_id_hd_khung)
{
if (rdl_noi_dung_list.Items[0].Selected == true)
{
if (CIPConvert.ToDecimal(m_txt_gia_tri_nghiem_thu_thuc_te.Text.Trim()) == (CIPConvert.ToDecimal(m_txt_so_tien_thanh_toan.Text.Trim())) + get_so_tien_da_thanh_toan_update(ip_dc_id_hd_khung))
{
return(true);
}
else
{
return(false);
}
}
return(true);
}
private void delete_ht_bo_dich_vu(GridView v_grv, decimal v_cap_sd)
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_query = "SELECT hbdv.ID FROM HT_BO_DICH_VU hbdv WHERE hbdv.ID_DICH_VU =" + m_us_dich_vu.dcID.ToString() + "AND hbdv.CAP_SU_DUNG=" + v_cap_sd.ToString();
v_us.FillDatasetWithQuery(v_ds, v_query);
for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
{
US_HT_BO_DICH_VU v_us_bo_dv = new US_HT_BO_DICH_VU(CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i]["ID"].ToString()));
v_us_bo_dv.Delete();
}
}
protected void m_grv_dm_danh_sach_giang_vien_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
try
{
decimal v_dc_id_dm_giang_vien = CIPConvert.ToDecimal(m_grv_dm_danh_sach_giang_vien_to_choose.DataKeys[e.NewSelectedIndex].Value);
US_V_DM_GIANG_VIEN v_us_dm_giang_vien = new US_V_DM_GIANG_VIEN(v_dc_id_dm_giang_vien);
Session["id_giang_vien"] = v_us_dm_giang_vien.dcID;
Session["name_giang_vien"] = v_us_dm_giang_vien.strTEN_GIANG_VIEN;
Response.Write("<script language='javascript'>{windown.close();}</scritp>");
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
private void delete_row(int i_int_row_index)
{
try
{
decimal v_dc_id = CIPConvert.ToDecimal(m_grv_dm_ho_so.DataKeys[i_int_row_index].Value);
m_us_dm_ho_so_giang_vien.DeleteByID(v_dc_id);
m_lbl_mess.Text = "Xóa bản ghi thành công.";
load_data_2_grid();
}
catch (Exception v_e)
{
m_lbl_mess.Text = "Lỗi trong quá trình xóa bản ghi.";
throw v_e;
}
}
//
//
// Event
//
//
protected void Page_Load(object sender, EventArgs e)
{
try
{
m_cmd_thoat.Attributes.Add("onclick", "window.close();");
if (this.Request.QueryString["mode"] != null && this.Request.QueryString["id_lop_mon"] != null)
{
if (this.Request.QueryString["mode"] == "update")
{
m_e_form_mode = DataEntryFormMode.UpdateDataState;
}
else if (this.Request.QueryString["mode"] == "insert")
{
m_e_form_mode = DataEntryFormMode.InsertDataState;
}
else if (this.Request.QueryString["mode"] == "view")
{
m_e_form_mode = DataEntryFormMode.ViewDataState;
}
else
{
return;
}
m_dc_id_lop_mon = CIPConvert.ToDecimal(this.Request.QueryString["id_lop_mon"].ToString());
}
if (!this.IsPostBack)
{
load_2_cbo_mon_hoc();
switch (m_e_form_mode)
{
case DataEntryFormMode.UpdateDataState:
load_form_update();
break;
case DataEntryFormMode.InsertDataState:
break;
case DataEntryFormMode.ViewDataState:
break;
}
}
}catch (Exception v_e) {
CSystemLog_301.ExceptionHandle(this, v_e);
}
}