private void m_cmd_ok_Click(object sender, EventArgs e)
{
for (int i = 0; i < grv_danh_sach.SelectedRowsCount; i++)
{
if (m_id_nhom == 2)
{
f999_ht_bo_pm_td_dich_vu_de.m_lst_id_nguoi_xu_ly_cap_1.Add(CIPConvert.ToDecimal(grv_danh_sach.GetDataRow(grv_danh_sach.GetSelectedRows()[i])["ID"].ToString()));
}
if (m_id_nhom == 3)
{
f999_ht_bo_pm_td_dich_vu_de.m_lst_id_nguoi_xu_ly_cap_2.Add(CIPConvert.ToDecimal(grv_danh_sach.GetDataRow(grv_danh_sach.GetSelectedRows()[i])["ID"].ToString()));
}
if (m_id_nhom == 5)
{
f999_ht_bo_pm_td_dich_vu_de.m_lst_id_nguoi_xu_ly_cap_3.Add(CIPConvert.ToDecimal(grv_danh_sach.GetDataRow(grv_danh_sach.GetSelectedRows()[i])["ID"].ToString()));
}
}
this.Close();
}
protected void m_cmd_tao_moi_Click(object sender, EventArgs e)
{
try
{
// thu thập dữ liệu
form_2_us_obj();
// Insert
m_us_ht_chuc_nang.Insert();
// hiển thị lại lên lưới
load_data_2_grid(CIPConvert.ToDecimal(m_cbo_chuc_nang_cap_1.SelectedValue));
// Reset lại control
reset_control();
m_lbl_mess.Text = "Thêm bản ghi thành công!";
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
private bool kiemtradulieu()
{
if (CIPConvert.ToDecimal(m_cbo_ten_khoa_vien.SelectedValue.ToString()) == -1)
{
MessageBox.Show("Chọn khoa viện!");
return(false);
}
if (CIPConvert.ToDecimal(m_cbo_khoa.SelectedValue.ToString()) == -1)
{
MessageBox.Show("Chọn khóa!");
return(false);
}
if (m_txt_lop_sinh_vien.Text == "")
{
MessageBox.Show("Hãy điền tên lớp sinh viên");
return(false);
}
return(true);
}
private void search_gv_cong_viec_moi_and_load_2_grv()
{
// Thu thập dữ liệu từ form tìm kiếm
string v_str_so_hd = m_cbo_so_hop_dong_loc.SelectedItem.Text;
decimal v_dc_noi_dung = CIPConvert.ToDecimal(m_cbo_noi_dung_thanh_toan.SelectedValue);
decimal v_dc_id_trang_thai = CIPConvert.ToDecimal(m_cbo_trang_thai_cv_gv.SelectedValue);
string v_str_tu_khoa = m_txt_tu_khoa.Text.Trim();
// Search
m_us_cong_viec_moi.loc_du_lieu_gv_cong_viec_moi(m_ds_cong_viec_moi, v_str_so_hd, v_dc_noi_dung, v_dc_id_trang_thai, v_str_tu_khoa);
m_grv_gd_assign_su_kien_cho_giang_vien.DataSource = m_ds_cong_viec_moi.GD_GV_CONG_VIEC_MOI;
m_grv_gd_assign_su_kien_cho_giang_vien.DataBind();
m_lbl_ket_qua_loc_du_lieu.Text = "Kết quả lọc dữ liệu: Có " + m_ds_cong_viec_moi.GD_GV_CONG_VIEC_MOI.Rows.Count + " bản ghi phù hợp.";
if (m_ds_cong_viec_moi.GD_GV_CONG_VIEC_MOI.Rows.Count == 0)
{
m_lbl_ket_qua_loc_du_lieu.Text = "Kết quả lọc dữ liệu";
m_lbl_thong_bao_sau_cap_nhat.Text = "* Không có bản ghi nào phù hợp.";
}
}
public string get_so_tien_thanh_toan(object ip_obj_don_gia, object ip_obj_trang_thai, object ip_obj_so_luong, object ip_obj_so_luong_nghiem_thu)
{
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
{
if (CIPConvert.ToDecimal(ip_obj_trang_thai) > ID_TRANG_THAI_CONG_VIEC_GVCM.DA_DUYET_KE_HOACH)
{
v_str_so_tien_thanh_toan = CIPConvert.ToStr(CIPConvert.ToDecimal(ip_obj_don_gia) * CIPConvert.ToDecimal(ip_obj_so_luong_nghiem_thu), "#,###");
}
else
{
v_str_so_tien_thanh_toan = CIPConvert.ToStr(CIPConvert.ToDecimal(ip_obj_don_gia) * CIPConvert.ToDecimal(ip_obj_so_luong), "#,###");
}
}
return(v_str_so_tien_thanh_toan);
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_str_query = "";
if (CIPConvert.ToDecimal(m_cbo_lop_sinh_vien.SelectedValue.ToString()) > -1)
{
v_str_query = "SELECT * FROM V_KET_QUA_HOC_TAP WHERE ID_LOP_SINH_VIEN=" + m_cbo_lop_sinh_vien.SelectedValue + "AND ID_HOC_KY=" + m_cbo_ky_hoc.SelectedValue;
}
else
{
v_str_query = "SELECT * FROM V_KET_QUA_HOC_TAP WHERE ID_HOC_KY=" + m_cbo_ky_hoc.SelectedValue;
}
v_us.FillDatasetWithQuery(v_ds, v_str_query);
m_grc_bao_cao_hoc_tap_theo_lop_sinh_vien.DataSource = v_ds.Tables[0];
}
protected void m_cbo_dot_thanh_toan_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
fill_data_2_thong_tin_dot_tt(CIPConvert.ToDecimal(m_cbo_dot_thanh_toan.SelectedValue));
if (CIPConvert.ToDecimal(m_cbo_dot_thanh_toan.SelectedValue) == get_id_of_dot_tt_kho())
{
m_cmd_duyet_tat_ca_chung_tu.Enabled = false;
}
else
{
m_cmd_duyet_tat_ca_chung_tu.Enabled = true;
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
protected void Page_Load(object sender, EventArgs e)
{
m_lbl_thong_bao.Text = "";
if (!IsPostBack)
{
load_data_2_dot_tt();
string v_str_ma_dot = m_cbo_dot_thanh_toan.SelectedValue;
if (m_cbo_dot_thanh_toan.Items.Count > 0)
{
fill_data_2_thong_tin_dot_tt(CIPConvert.ToDecimal(m_cbo_dot_thanh_toan.SelectedValue));
m_cmd_duyet_tat_ca_chung_tu.Enabled = true;
}
else
{
m_lbl_thong_bao.Text = "Chưa có đợt thanh toán nào !";
m_cmd_duyet_tat_ca_chung_tu.Enabled = false;
}
}
}
private void update_trang_thai_don_hang(US_GD_DAT_HANG v_us)
{
US_DUNG_CHUNG v_us_dc = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us_dc.FillDatasetWithQuery(v_ds, "SELECT * FROM V_GD_DAT_HANG_GD_LOG_DAT_HANG WHERE THAO_TAC_HET_HAN_YN = 'N' AND [ID_DON_HANG] = " + v_us.dcID.ToString());
for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
{
US_GD_LOG_DAT_HANG V_us = new US_GD_LOG_DAT_HANG(CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i]["ID"].ToString()));
V_us.strTHAO_TAC_HET_HAN_YN = "Y";
V_us.Update();
}
//cập nhật thời gian hoàn thành cho đơn hàng
US_GD_DAT_HANG v_us1 = new US_GD_DAT_HANG(v_us.dcID);
v_us1.datTHOI_GIAN_HOAN_THANH = System.DateTime.Now;
v_us1.Update();
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_str_query;
if (CIPConvert.ToDecimal(m_cbo_muc_canh_cao.SelectedValue.ToString()) > -1)
{
v_str_query = "SELECT VKQHT.* ,DS_XU_LY.MUC_CANH_CAO FROM V_KET_QUA_HOC_TAP AS VKQHT, (SELECT * FROM dbo.fn_ds_xu_ly_hoc_tap(" + m_cbo_hoc_ky.SelectedValue.ToString() + ") ) AS DS_XU_LY WHERE DS_XU_LY.ID_SINH_VIEN = VKQHT.ID_SINH_VIEN AND VKQHT.ID_HOC_KY = " + m_cbo_hoc_ky.SelectedValue.ToString() + "AND DS_XU_LY.MUC_CANH_CAO = N'" + m_cbo_muc_canh_cao.Text + "'";
}
else
{
v_str_query = "SELECT VKQHT.* ,DS_XU_LY.MUC_CANH_CAO FROM V_KET_QUA_HOC_TAP AS VKQHT, (SELECT * FROM dbo.fn_ds_xu_ly_hoc_tap(" + m_cbo_hoc_ky.SelectedValue.ToString() + ") ) AS DS_XU_LY WHERE DS_XU_LY.ID_SINH_VIEN = VKQHT.ID_SINH_VIEN AND VKQHT.ID_HOC_KY = " + m_cbo_hoc_ky.SelectedValue.ToString();
}
v_us.FillDatasetWithQuery(v_ds, v_str_query);
m_grc_bao_cao_hoc_tap_theo_sv.DataSource = v_ds.Tables[0];
}
protected void m_grv_danh_sach_du_toan_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
try
{
m_grv_danh_sach_du_toan.PageIndex = e.NewPageIndex;
if (m_txt_so_hd_search.Text == "")
{
load_data_2_grid(get_ma_dot_tt_by_id_dot(CIPConvert.ToDecimal(m_cbo_dot_thanh_toan.SelectedValue)));
}
else
{
load_data_2_grid_search(get_ma_dot_tt_by_id_dot(CIPConvert.ToDecimal(m_cbo_dot_thanh_toan.SelectedValue)), m_txt_so_hd_search.Text.Trim());
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
public void display(SinhVien i_obj_sinh_vien, string i_str_call_id)
{
load_data_2_cbo_truong();
m_e_form_mode = e_form_mode.TU_DONG_OPEN;
m_txt_dien_thoai.Text = i_obj_sinh_vien.Dien_thoai;
m_txt_ho_ten.Text = i_obj_sinh_vien.Ho_ten;
m_txt_ma_hoc_vien.Text = i_obj_sinh_vien.Ma_sinh_vien;
m_txt_ma_lop.Text = i_obj_sinh_vien.Ma_lop;
if (i_obj_sinh_vien.Ngay_sinh != CIPConvert.ToDatetime("01/01/0001", "dd/MM/yyyy"))
{
m_dtp_ngay_sinh.Value = CIPConvert.ToDatetime(i_obj_sinh_vien.Ngay_sinh.ToShortDateString(), "dd/MM/yyyy");
}
if (i_obj_sinh_vien.Truong != null)
{
m_cbo_truong.SelectedValue = i_obj_sinh_vien.Truong;
}
else
{
m_cbo_truong.SelectedIndex = 0;
}
if (i_obj_sinh_vien.Ho_Ten_QLHT != "" && i_obj_sinh_vien.Ho_Ten_QLHT != null)
{
m_txt_ho_ten_qlht.Text = i_obj_sinh_vien.Ho_Ten_QLHT;
}
if (i_obj_sinh_vien.Dien_thoai_QLHT != "" && i_obj_sinh_vien.Dien_thoai_QLHT != null)
{
m_txt_dien_thoai_qlht.Text = i_obj_sinh_vien.Dien_thoai_QLHT;
}
m_call_id = i_str_call_id;
if (m_txt_ho_ten.Text.Trim() == "")
{
m_cmd_tim_hv_khac.Enabled = true;
m_chk_hoc_vien_moi.Enabled = true;
m_chk_hoc_vien_moi.Checked = true;
}
//
this.ShowDialog();
this.Activate();
}
private void form_2_us_nhan_vien()
{
m_us.dcID_DU_AN = m_us_du_an.dcID;
m_us.strMA_DU_AN = m_us_du_an.strMA_DU_AN;
m_us.strTEN_DU_AN = m_us_du_an.strTEN_DU_AN;
US_DM_NHAN_SU v_us_nhan_su = new US_DM_NHAN_SU();
DS_DM_NHAN_SU v_ds_nhan_su = new DS_DM_NHAN_SU();
v_us_nhan_su.FillDataset_search_by_ma_nv(v_ds_nhan_su, m_lbl_ma_nhan_vien.Text);
if (v_ds_nhan_su.DM_NHAN_SU.Rows.Count > 0)
{
m_us.dcID_NHAN_SU = (decimal)v_ds_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.ID];
m_us.strMA_NV = v_ds_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.MA_NV].ToString();
m_us.strHO_DEM = v_ds_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.HO_DEM].ToString();
m_us.strTEN = v_ds_nhan_su.DM_NHAN_SU.Rows[0][DM_NHAN_SU.TEN].ToString();
}
m_us.dcID_VI_TRI = (decimal)m_cbo_vi_tri.SelectedValue;
m_us.strVI_TRI = m_cbo_vi_tri.Text;
US_V_GD_TRANG_THAI_LAO_DONG v_us_trang_thai_ld = new US_V_GD_TRANG_THAI_LAO_DONG();
DS_V_GD_TRANG_THAI_LAO_DONG v_ds_trang_thai_ld = new DS_V_GD_TRANG_THAI_LAO_DONG();
v_us_trang_thai_ld.FillDatasetByManhanvien_trang_thai_hien_tai(v_ds_trang_thai_ld, m_lbl_ma_nhan_vien.Text, CAppContext_201.getCurrentIDPhapnhan());
if (v_ds_trang_thai_ld.V_GD_TRANG_THAI_LAO_DONG.Rows.Count > 0)
{
m_us.strTRANG_THAI_LAO_DONG = v_ds_trang_thai_ld.V_GD_TRANG_THAI_LAO_DONG.Rows[0][V_GD_TRANG_THAI_LAO_DONG.TRANG_THAI_LAO_DONG].ToString();
}
m_us.datTHOI_DIEM_TG = m_dat_tham_gia.Value;
m_us.datTHOI_DIEM_KT = m_dat_ngay_kt.Value;
m_us.dcTHOI_GIAN_TG = CIPConvert.ToDecimal(m_txt_thoi_gian_tham_gia.Text);
m_us.dcID_DANH_HIEU = (decimal)m_cbo_danh_hieu.SelectedValue;
m_us.strDANH_HIEU = m_cbo_danh_hieu.Text;
m_us.strMA_QUYET_DINH = m_txt_ma_quyet_dinh.Text;
m_us.strLOAI_QD = m_lbl_loai_quyet_dinh.Text;
m_us.strMO_TA = m_txt_mo_ta.Text;
}
private void us_obj_2_form(US_V_GD_THANH_TOAN ip_us_gd_thanh_toan)
{
m_txt_tham_so.Visible = true;
if (Request.QueryString["id_tt"] == null)
{
m_cbo_dot_thanh_toan.SelectedValue = CIPConvert.ToStr(get_id_dot_tt_by_ma_dot(ip_us_gd_thanh_toan.strSO_PHIEU_THANH_TOAN));
}
m_txt_so_hop_dong.Text = get_so_hd_khung_by_id_hd(ip_us_gd_thanh_toan.dcID_HOP_DONG_KHUNG);
if (ip_us_gd_thanh_toan.strLOAI_HOP_DONG.Equals("VH"))
{
m_lbl_tham_so.Text = "Mã lớp";
m_txt_tham_so.Text = ip_us_gd_thanh_toan.strREFERENCE_CODE;
}
else
{
m_lbl_tham_so.Text = "Nội dung thanh toán";
if (!ip_us_gd_thanh_toan.IsREFERENCE_CODENull())
{
m_txt_tham_so.Text = "Tạm ứng " + ip_us_gd_thanh_toan.strREFERENCE_CODE;
}
else
{
m_txt_tham_so.Text = "Thanh lý hợp đồng";
m_txt_gia_tri_nghiem_thu_thuc_te.Text = CIPConvert.ToStr(ip_us_gd_thanh_toan.dcGIA_TRI_NGHIEM_THU_THUC_TE, "#,###");
}
}
m_dat_ngay_thanh_toan.SelectedDate = ip_us_gd_thanh_toan.datNGAY_THANH_TOAN;
m_txt_so_tien_thanh_toan.Text = CIPConvert.ToStr(ip_us_gd_thanh_toan.dcTONG_TIEN_THANH_TOAN, "#,###");
m_txt_so_tien_thuc_nhan.Text = CIPConvert.ToStr(ip_us_gd_thanh_toan.dcTONG_TIEN_THUC_NHAN, "#,###");
m_txt_so_tien_thue1.Text = CIPConvert.ToStr(ip_us_gd_thanh_toan.dcSO_TIEN_THUE, "#,###");
if (Request.QueryString["id_tt"] != null)
{
m_cbo_trang_thai_thanh_toan.SelectedValue = CIPConvert.ToStr(ip_us_gd_thanh_toan.dcID_TRANG_THAI_THANH_TOAN);
}
else
{
m_cbo_trang_thai_thanh_toan.SelectedValue = CIPConvert.ToStr(ID_TRANG_THAI_THANH_TOAN.CHUA_CO_XAC_NHAN_CUA_GIANG_VIEN);
}
// Lưu lại id_trang_thai_thanh_toan_cuc
hdf_id_trang_thai_thanh_toan_cu.Value = CIPConvert.ToStr(ip_us_gd_thanh_toan.dcID_TRANG_THAI_THANH_TOAN);
m_txt_mo_ta.Text = ip_us_gd_thanh_toan.strDESCRIPTION;
}
private void form_2_us_object()
{
System.Globalization.CultureInfo enUS = new System.Globalization.CultureInfo("en-US");
DateTime v_dat_out_result;
m_us_cong_viec_moi.dcID_HOP_DONG_KHUNG = CIPConvert.ToDecimal(m_cbo_so_hop_dong.SelectedValue);
m_us_cong_viec_moi.dcID_NOI_DUNG_TT = CIPConvert.ToDecimal(m_cbo_noi_dung_thanh_toan.SelectedValue);
if (m_txt_so_luong.Text.Trim() != "")
{
m_us_cong_viec_moi.dcSO_LUONG_HE_SO = CIPConvert.ToDecimal(m_txt_so_luong.Text);
}
if (m_txt_don_gia.Text != "")
{
m_us_cong_viec_moi.dcDON_GIA = CIPConvert.ToDecimal(m_txt_don_gia.Text);
}
if (DateTime.TryParseExact(CIPConvert.ToStr(m_dat_ngay_bat_dau.SelectedDate), "dd/MM/yyyy", enUS, System.Globalization.DateTimeStyles.None, out v_dat_out_result))
{
if (m_dat_ngay_bat_dau.SelectedDate != CIPConvert.ToDatetime("01/01/0001"))
{
m_us_cong_viec_moi.datNGAY_DAT_HANG = m_dat_ngay_bat_dau.SelectedDate;
}
// Nếu công việc này chưa đc đặt hàng, lấy ngày đầu tiên của tháng trước
else
{
DateTime v_dat_today = DateTime.Today;
int v_i_year = v_dat_today.Year;
int v_i_month = v_dat_today.Month - 1;
if (v_i_month == 0)
{
v_i_year = v_i_year - 1;
v_i_month = 12;
}
DateTime v_dat_ngay_dat_hang = new DateTime(v_i_year, v_i_month, 1);
m_us_cong_viec_moi.datNGAY_DAT_HANG = v_dat_ngay_dat_hang;
}
}
m_us_cong_viec_moi.datNGAY_NGHIEM_THU = DateTime.Today;
m_us_cong_viec_moi.dcSO_LUONG_NGHIEM_THU = CIPConvert.ToDecimal(m_txt_so_luong_nghiem_thu.Text.Trim());
m_us_cong_viec_moi.dcID_TRANG_THAI = CIPConvert.ToDecimal(m_cbo_trang_thai_cv_gv.SelectedValue);
m_us_cong_viec_moi.strGHI_CHU = m_txt_ghi_chu.Text;
m_us_cong_viec_moi.dcID_USER_NHAP = get_id_user_by_username(CIPConvert.ToStr(Session["Username"]));
}
private void form_2_us_object(US_V_DM_NOI_DUNG_THANH_TOAN ip_us_noi_dung_thanh_toan)
{
ip_us_noi_dung_thanh_toan.strTEN_NOI_DUNG = m_txt_ten_noi_dung.Text;
ip_us_noi_dung_thanh_toan.dcID_LOAI_HOP_DONG = CIPConvert.ToDecimal(m_ddl_loai_hop_dong.SelectedValue);
ip_us_noi_dung_thanh_toan.strMA_DON_VI_TINH = m_ddl_ma_don_vi_tinh.SelectedValue;
ip_us_noi_dung_thanh_toan.strMA_TAN_SUAT = m_ddl_ma_tan_xuat.SelectedValue;
ip_us_noi_dung_thanh_toan.dcDON_GIA_DEFAULT = CIPConvert.ToDecimal(m_txt_don_gia.Text);
ip_us_noi_dung_thanh_toan.strGHI_CHU = m_txt_ghi_chu.Text;
if (m_rd_yes_hoc_lieu.Checked)
{
ip_us_noi_dung_thanh_toan.strHOC_LIEU_YN = "Y";
}
else
{
ip_us_noi_dung_thanh_toan.strHOC_LIEU_YN = "N";
}
if (m_rd_yes_van_hanh.Checked)
{
ip_us_noi_dung_thanh_toan.strVAN_HANH_YN = "Y";
}
else
{
ip_us_noi_dung_thanh_toan.strVAN_HANH_YN = "N";
}
if (m_txt_so_luong_he_so_default.Text == "")
{
ip_us_noi_dung_thanh_toan.dcSO_LUONG_HE_SO_DEFAULT = 0;
}
else
{
ip_us_noi_dung_thanh_toan.dcSO_LUONG_HE_SO_DEFAULT = CIPConvert.ToDecimal(m_txt_so_luong_he_so_default.Text.Trim());
}
if (m_rdl_su_dung_yn.Items[0].Selected)
{
ip_us_noi_dung_thanh_toan.strSU_DUNG_YN = "Y";
}
else
{
ip_us_noi_dung_thanh_toan.strSU_DUNG_YN = "N";
}
ip_us_noi_dung_thanh_toan.strSU_KIEN_YN = "N";
}
private void update_quyen_chuc_nang()
{
try
{
m_lbl_mess.Text = "";
string v_str_id_chuc_nangs = "";
foreach (ListItem ltTemp in this.m_lst_chuc_nang_user.Items)
{
v_str_id_chuc_nangs += ltTemp.Value + ",";
}
US_HT_QUYEN_GROUP v_us_quyen_group = new US_HT_QUYEN_GROUP();
v_us_quyen_group.update_quyen_group(CIPConvert.ToDecimal(m_cbo_user_group.SelectedValue), v_str_id_chuc_nangs);
m_lbl_mess.Text = "Cập nhật quyền sử dụng chức năng cho nhóm thành công";
}
catch (Exception v_e)
{
m_lbl_mess.Text = "Lỗi trong quá trình cập nhật bản ghi.";
throw v_e;
}
}
private void m_cmd_OK_Click(object sender, EventArgs e)
{
try
{
if (check_du_lieu_truoc_luu())
{
US_DM_KHOA v_us = new US_DM_KHOA();
v_us.strKHOA = m_txt_khoa.Text;
v_us.dcTRANG_THAI_HSD = 7;
v_us.dcNAM_BAT_DAU = CIPConvert.ToDecimal(m_txt_nam_bat_dau.Text);
v_us.Insert();
MessageBox.Show("Thêm mới thành công khóa:" + m_txt_khoa.Text);
this.Close();
}
}
catch
{
MessageBox.Show("Đã xảy ra lỗi hệ thống!");
}
}
private void form_2_us_obj(US_V_GD_THANH_TOAN op_us_gd_thanh_toan)
{
op_us_gd_thanh_toan.strSO_PHIEU_THANH_TOAN = get_ma_dot_tt_by_id_dot(CIPConvert.ToDecimal(m_cbo_dot_thanh_toan.SelectedValue));
op_us_gd_thanh_toan.dcID_HOP_DONG_KHUNG = get_id_hd_khung_by_so_hd(m_txt_so_hop_dong.Text.Trim());
if (m_txt_tham_so.Text.Contains("Tạm ứng"))
{
op_us_gd_thanh_toan.strREFERENCE_CODE = cut_string_tam_ung(m_txt_tham_so.Text.Trim());
}
else if (m_lbl_tham_so.Text.Contains("Mã lớp"))
{
op_us_gd_thanh_toan.strREFERENCE_CODE = m_txt_tham_so.Text;
}
else
{
op_us_gd_thanh_toan.SetREFERENCE_CODENull();
}
op_us_gd_thanh_toan.dcID_TRANG_THAI_THANH_TOAN = CIPConvert.ToDecimal(m_cbo_trang_thai_thanh_toan.SelectedValue);
// Mã đợt thanh toán cũ của thanh toán đươc lưu trong phần mô tả
op_us_gd_thanh_toan.strDESCRIPTION = m_txt_mo_ta.Text.Trim() + " " + op_us_gd_thanh_toan.strSO_PHIEU_THANH_TOAN;
}
// Mục đích là view phụ lục hợp đồng khung và sửa phụ lục
protected void Page_Load(object sender, EventArgs e)
{
//m_lbl_thong_bao.Text = "";
//m_cbo_noi_dung_tt.Enabled = true;
m_grv_gd_hop_dong_noi_dung_tt.Columns[0].Visible = false;
m_grv_gd_hop_dong_noi_dung_tt.Columns[1].Visible = false;
if (!IsPostBack)
{
//m_cmd_cap_nhat_pl.Enabled = true;
//m_cmd_luu_du_lieu.Enabled = true;
// show on grid
if (Request.QueryString["id_hd"] != null)
{
m_dc_id_hd = CIPConvert.ToDecimal(Request.QueryString["id_hd"]);
//load_2_cbo_noi_dung_tt(get_id_loai_hd_hop_dong_id(m_dc_id_hd));
load_data_2_grid(m_dc_id_hd);
}
}
load_data_2_basic_control();
}
private void tu_dong_danh_gia()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_str_query = "SELECT * FROM GD_DAT_HANG WHERE THOI_GIAN_HOAN_THANH is not null AND ID_DANH_GIA_TU_USER_DAT_HANG IS NULL";
v_us.FillDatasetWithQuery(v_ds, v_str_query);
for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
{
US_GD_DAT_HANG v_us_gd_dat_hang = new US_GD_DAT_HANG(CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i]["ID"].ToString()));
DateTime v_thoi_gian_hoan_thanh = v_us_gd_dat_hang.datTHOI_GIAN_HOAN_THANH.AddDays(3);
if (System.DateTime.Compare(v_thoi_gian_hoan_thanh, System.DateTime.Now) == -1)
{
v_us_gd_dat_hang.dcID_DANH_GIA_TU_USER_DAT_HANG = 124;
v_us_gd_dat_hang.Update();
}
}
}
private void load_data_2_grid()
{
try {
m_us_dm_tu_dien.fill_tu_dien_cung_loai_ds(CIPConvert.ToStr(m_cbo_loai_tu_dien_grv.SelectedValue), m_ds_dm_tu_dien);
m_grv_dm_tu_dien.DataSource = m_ds_dm_tu_dien.CM_DM_TU_DIEN;
m_grv_dm_tu_dien.DataBind();
if (m_ds_dm_tu_dien.CM_DM_TU_DIEN.Rows.Count == 0)
{
m_lbl_thong_bao.Text = "Chưa có nội dung thanh toán cho lọai hợp đồng này";
m_lbl_thong_bao.Visible = true;
}
else
{
m_lbl_thong_bao.Visible = false;
}
}
catch (Exception v_e) {
throw v_e;
}
}
private decimal get_so_tien_da_thanh_toan_update(decimal ip_dc_id_hop_dong_khung)
{
US_V_GD_THANH_TOAN v_us_v_gd_tt = new US_V_GD_THANH_TOAN();
DS_V_GD_THANH_TOAN v_ds_v_gd_tt = new DS_V_GD_THANH_TOAN();
// lấy toàn bộ thanh toán của hợp đồng theo id_hop_dong
v_us_v_gd_tt.FillDataset(v_ds_v_gd_tt, " WHERE ID_HOP_DONG_KHUNG=" + ip_dc_id_hop_dong_khung + " ORDER BY ID");
// Nếu đã có thanh toán
if (v_ds_v_gd_tt.V_GD_THANH_TOAN.Rows.Count > 0)
{
decimal v_dc_so_tien_da_tt = 0;
//string v_str_so_lan_tam_ung = cut_end_string(CIPConvert.ToStr(v_ds_v_gd_tt.V_GD_THANH_TOAN.Rows[v_ds_v_gd_tt.V_GD_THANH_TOAN.Rows.Count - 1][V_GD_THANH_TOAN.REFERENCE_CODE]));
v_dc_so_tien_da_tt += CIPConvert.ToDecimal(v_ds_v_gd_tt.V_GD_THANH_TOAN.Rows[v_ds_v_gd_tt.V_GD_THANH_TOAN.Rows.Count - 1][V_GD_THANH_TOAN.DA_THANH_TOAN]);
return(v_dc_so_tien_da_tt);
}
else
{
return(0);
}
}
private void load_data_2_cbo_trang_thai_cv_gv()
{
US_CM_DM_TU_DIEN v_us_tu_dien = new US_CM_DM_TU_DIEN();
DS_CM_DM_TU_DIEN v_ds_tu_dien = new DS_CM_DM_TU_DIEN();
v_us_tu_dien.FillDataset(v_ds_tu_dien, " WHERE ID_LOAI_TU_DIEN = " + (int)e_loai_tu_dien.TRANG_THAI_CONG_VIEC_GV);
m_cbo_trang_thai_cv_gv.DataTextField = CM_DM_TU_DIEN.TEN;
m_cbo_trang_thai_cv_gv.DataValueField = CM_DM_TU_DIEN.ID;
m_cbo_trang_thai_cv_gv.DataSource = v_ds_tu_dien.CM_DM_TU_DIEN;
m_cbo_trang_thai_cv_gv.DataBind();
m_cbo_trang_thai_cv_gv.SelectedIndex = 0;
m_cbo_trang_thai_cv_loc.Items.Add(new ListItem("Tất cả", "0"));
for (int v_i = 0; v_i < v_ds_tu_dien.CM_DM_TU_DIEN.Rows.Count; v_i++)
{
m_cbo_trang_thai_cv_loc.Items.Add(new ListItem(CIPConvert.ToStr(v_ds_tu_dien.CM_DM_TU_DIEN.Rows[v_i][CM_DM_TU_DIEN.TEN]), CIPConvert.ToStr(v_ds_tu_dien.CM_DM_TU_DIEN.Rows[v_i][CM_DM_TU_DIEN.ID])));
}
}
private decimal get_so_tien_da_thanh_toan(decimal ip_dc_id_hop_dong_khung)
{
US_V_GD_THANH_TOAN v_us_v_gd_tt = new US_V_GD_THANH_TOAN();
DS_V_GD_THANH_TOAN v_ds_v_gd_tt = new DS_V_GD_THANH_TOAN();
// lấy toàn bộ thanh toán của hợp đồng theo id_hop_dong
v_us_v_gd_tt.f601_load_thanh_toan_theo_hop_dong_de_kiem_tra(ip_dc_id_hop_dong_khung, v_ds_v_gd_tt);
// Nếu đã có thanh toán
if (v_ds_v_gd_tt.V_GD_THANH_TOAN.Rows.Count > 0)
{
decimal v_dc_so_tien_da_tt = 0;
//string v_str_so_lan_tam_ung = cut_end_string(CIPConvert.ToStr(v_ds_v_gd_tt.V_GD_THANH_TOAN.Rows[v_ds_v_gd_tt.V_GD_THANH_TOAN.Rows.Count - 1][V_GD_THANH_TOAN.REFERENCE_CODE]));
v_dc_so_tien_da_tt += CIPConvert.ToDecimal(v_ds_v_gd_tt.V_GD_THANH_TOAN.Rows[v_ds_v_gd_tt.V_GD_THANH_TOAN.Rows.Count - 1][V_GD_THANH_TOAN.DA_THANH_TOAN]) + CIPConvert.ToDecimal(v_ds_v_gd_tt.V_GD_THANH_TOAN.Rows[v_ds_v_gd_tt.V_GD_THANH_TOAN.Rows.Count - 1][V_GD_THANH_TOAN.TONG_TIEN_THANH_TOAN]);
return(v_dc_so_tien_da_tt);
}
else
{
return(0);
}
}
protected void m_cmd_duyet_ke_hoach_Click(object sender, EventArgs e)
{
try
{
int v_i_count = 0;
foreach (GridViewRow row in m_grv_gd_assign_su_kien_cho_giang_vien.Rows)
{
bool isChecked = ((CheckBox)row.FindControl("chkItem")).Checked;
if (isChecked)
{
v_i_count += 1;
// Lấy id của công việc
decimal v_dc_id_cong_viec = CIPConvert.ToDecimal(((CheckBox)row.FindControl("chkItem")).ToolTip);
decimal v_dc_id_trang_thai_hien_tai = CIPConvert.ToDecimal(((CheckBox)row.FindControl("chkTrangThai")).ToolTip);
if (!check_trang_thai_chuyen(v_dc_id_trang_thai_hien_tai, ID_TRANG_THAI_CONG_VIEC_GVCM.DA_DUYET_KE_HOACH))
{
continue;
}
m_us_cong_viec_moi.dcID = v_dc_id_cong_viec;
// Chuyển trạng thái của công việc sang đã duyệt
m_us_cong_viec_moi.cap_nhat_trang_thai_cong_viec(ID_TRANG_THAI_CONG_VIEC_GVCM.DA_DUYET_KE_HOACH);
}
}
// Neu so items duoc check lớn hơn 0
if (v_i_count > 0)
{
// Load lại dữ liêụ
load_data_2_grv();
m_lbl_thong_bao_sau_cap_nhat.Text = "Duyệt công việc đã chọn thành công!";
}
// Nếu ko
else
{
m_lbl_mess.Text = "Bạn chưa chọn công việc nào để duyệt!";
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
private void us_object_2_form()
{
m_dat_ngay_tao.Value = m_us_dm_cau_hoi.datNGAY_TAO;
m_txt_nguoi_tao.Text = m_us_dm_cau_hoi.strTEN_NGUOI_TAO;
m_txt_noi_dung_cau_hoi.Text = m_us_dm_cau_hoi.strNOI_DUNG_CAU_HOI;
m_cbo_don_vi_truong.SelectedValue = CIPConvert.ToStr(m_us_dm_cau_hoi.dcID_TO_CHUC);
m_cbo_nhom_cau_hoi.SelectedValue = CIPConvert.ToStr(m_us_dm_cau_hoi.dcID_NHOM_CAU_HOI);
if (!m_us_dm_cau_hoi.IsLINK_TL_THAM_KHAONull())
{
m_txt_link_tai_lieu.Text = m_us_dm_cau_hoi.strLINK_TL_THAM_KHAO;
}
switch (m_e_form_mode)
{
case e_form_mode.SUA_CAU_HOI:
if (m_us_dm_cau_tra_loi.dcID > 0)
{
m_txt_cau_tra_loi.Text = m_us_dm_cau_tra_loi.strCAU_TRA_LOI;
m_cbo_trang_thai_cau_tra_loi.SelectedValue = m_us_dm_cau_tra_loi.dcID_TRANG_THAI;
m_txt_link_tai_lieu.Text = m_us_dm_cau_tra_loi.strLINK_TL_THAM_KHAO;
}
m_txt_cau_tra_loi.Enabled = false;
m_txt_link_tai_lieu.Enabled = false;
m_cbo_trang_thai_cau_tra_loi.Enabled = false;
break;
case e_form_mode.DUYET_CAU_TRA_LOI:
m_dat_ngay_tao.Value = m_us_all_cau_hoi.datNGAY_TAO;
m_txt_nguoi_tao.Text = m_us_all_cau_hoi.strTEN_NGUOI_TAO;
m_txt_noi_dung_cau_hoi.Text = m_us_all_cau_hoi.strNOI_DUNG_CAU_HOI;
m_cbo_don_vi_truong.SelectedValue = CIPConvert.ToStr(m_us_all_cau_hoi.dcID_TO_CHUC);
m_cbo_nhom_cau_hoi.SelectedValue = CIPConvert.ToStr(m_us_all_cau_hoi.dcID_NHOM_CAU_HOI);
m_txt_link_tai_lieu.Text = m_us_dm_cau_tra_loi.strLINK_TL_THAM_KHAO;
m_txt_cau_tra_loi.Text = m_us_dm_cau_tra_loi.strCAU_TRA_LOI;
m_cbo_trang_thai_cau_tra_loi.SelectedValue = m_us_dm_cau_tra_loi.dcID_TRANG_THAI;
break;
}
}
private void m_cmd_sua_Click(object sender, EventArgs e)
{
try
{
DataRow v_dr = m_grv_dm_sinh_vien.GetDataRow(m_grv_dm_sinh_vien.FocusedRowHandle);
if (v_dr != null)
{
if (check_du_lieu_truoc_luu(v_dr) == true)
{
//update DM sinh viên
US_DM_SINH_VIEN v_us = new US_DM_SINH_VIEN(CIPConvert.ToDecimal(v_dr["ID"].ToString()));
v_us.strMA_SINH_VIEN = m_txt_ma_so_sinh_vien.Text;
v_us.strTEN_SINH_VIEN = m_txt_ho_ten_sinh_vien.Text;
v_us.strSDT = m_txt_so_dien_thoai.Text;
if (m_rdb_nam.Checked == true)
{
v_us.strGIOI_TINH = "N";
}
else
{
v_us.strGIOI_TINH = "W";
}
v_us.strQUE_QUAN = m_txt_que_quan.Text;
v_us.datNGAY_SINH = m_dat_ngay_sinh.Value;
v_us.dcID_LOP_SINH_VIEN = CIPConvert.ToDecimal(m_cbo_lop_sinh_vien.SelectedValue);
v_us.dcTRANG_THAI = CIPConvert.ToDecimal(m_cbo_trang_thai.SelectedValue);
v_us.Update();
MessageBox.Show("Cập nhật thành công!");
load_data_2_grid();
}
}
else
{
MessageBox.Show("hãy chọn 1 sinh viên!");
}
}
catch
{
MessageBox.Show("Đã xảy ra lỗi trong hệ thống!");
}
}
private void gui_email_hoan_thanh_don_hang()
{
string v_str_email_dvmc = f002_main_form.m_str_email_dvmc;
string v_str_password_dvmc = CEncryptKeyString.DecryptString(f002_main_form.m_str_password_dvmc);
string to = m_us_v_gd_dat_hang.strUSER_NV_DAT_HANG + "@topica.edu.vn";
string v_str_subject = "";
string v_str_content = "";
string v_str_link_portal = f002_main_form.m_str_url_hoan_thanh_don_hang;
v_str_link_portal = v_str_link_portal.Replace("<MA_DON_HANG>", m_us_v_gd_dat_hang.strMA_DON_HANG);
v_str_subject = m_ds_dm_mau_mail_hoan_thanh.DM_MAU_EMAIL.Rows[0][DM_MAU_EMAIL.TIEU_DE_MAIL].ToString();
v_str_content = m_ds_dm_mau_mail_hoan_thanh.DM_MAU_EMAIL.Rows[0][DM_MAU_EMAIL.NOI_DUNG_EMAIL].ToString();
// find and replace thông tin trong content mail
v_str_content = v_str_content.Replace("MA_DON_HANG", m_us_v_gd_dat_hang.strMA_DON_HANG);
v_str_content = v_str_content.Replace("LINK_DANH_GIA_DON_HANG", v_str_link_portal);
v_str_content = v_str_content.Replace("NOI_DUNG_DON_HANG", m_us_v_gd_dat_hang.strNOI_DUNG_DAT_HANG);
v_str_content = v_str_content.Replace("USER_NHAN_VIEN", m_us_v_gd_dat_hang.strUSER_NV_DAT_HANG);
v_str_content = v_str_content.Replace("USER_DON_VI", m_cbo_dv_don_vi.Text);
v_str_content = v_str_content.Replace("USER_DIEN_THOAI", m_us_v_gd_dat_hang.strDIEN_THOAI);
v_str_content = v_str_content.Replace("USER_THOI_GIAN_DAT_HANG", m_us_v_gd_dat_hang.datTHOI_GIAN_DAT_HANG.ToString());
v_str_content = v_str_content.Replace("LOAI_DICH_VU_HO_TRO", m_cbo_loai_dich_vu.Text);
v_str_content = v_str_content.Replace("YEU_CAU_CU_THE", m_us_v_gd_dat_hang.strNOI_DUNG_DAT_HANG);
v_str_content = v_str_content.Replace("THOI_GIAN_MONG_MUON_SUA_XONG", m_str_loai_thoi_gian_hoan_thanh);
v_str_content = v_str_content.Replace("PHAN_HOI_CUA_DVMC", m_us_v_gd_dat_hang.strPHAN_HOI_TU_DVMC);
v_str_content = v_str_content.Replace("NGUOI_XU_LY_DON_HANG", m_us_v_gd_dat_hang.strNGUOI_XU_LY);
v_str_content = v_str_content.Replace("NGUOI_NHAN_DAT_HANG", m_cbo_nguoi_nhan_dat_hang.Text);
v_str_content = v_str_content.Replace("LICH_SU_TRAO_DOI", m_txt_lich_su_trao_doi.Text);
v_str_content = v_str_content.Replace("THOI_GIAN_HOAN_THANH_THUC_TE", CIPConvert.ToStr(DateTime.Now, "HH:mm:ss dd/MM/yyyy"));
v_str_content = v_str_content + f002_main_form.m_str_chu_ky_dvmc;
v_str_subject = v_str_subject.Replace("<MA_DON_HANG>", m_us_v_gd_dat_hang.strMA_DON_HANG);
try
{
HelpUtils.send_mail("Dịch Vụ Một Cửa", v_str_email_dvmc, v_str_password_dvmc, to, "", v_str_subject, v_str_content);
}
catch (Exception v_e)
{
CSystemLog_100.ExceptionHandle(v_e, "Gửi email thông báo cho khách hàng lỗi. Hãy xem lại cấu hình email DVMC!");
}
}
private void us_object_2_form(US_V_GD_THANH_TOAN_LUONG_ONLINE ip_us_gd_thanh_toan_online)
{
m_cbo_dv_quan_ly.SelectedValue = ip_us_gd_thanh_toan_online.dcID_DON_VI_QUAN_LY;
m_txt_ho_ten_gv.Text = ip_us_gd_thanh_toan_online.strHO_TEN_GIANG_VIEN;
m_txt_noi_dung_thanh_toan.Text = ip_us_gd_thanh_toan_online.strNOI_DUNG_THANH_TOAN;
m_txt_ten_course.Text = ip_us_gd_thanh_toan_online.strCOURSE_NAME;
m_txt_don_gia.Text = CIPConvert.ToStr(ip_us_gd_thanh_toan_online.dcDON_GIA, "#,###");
if (ip_us_gd_thanh_toan_online.dcID_KHOAN_CHI == C_TU_DIEN_LOAI_NOI_DUNG_HD_ONLINE.LUONG_CM_CHINH_TRI ||
ip_us_gd_thanh_toan_online.dcID_KHOAN_CHI == C_TU_DIEN_LOAI_NOI_DUNG_HD_ONLINE.LUONG_CM_KO_CHINH_TRI ||
ip_us_gd_thanh_toan_online.dcID_KHOAN_CHI == C_TU_DIEN_LOAI_NOI_DUNG_HD_ONLINE.LUONG_HD_CHINH_TRI ||
ip_us_gd_thanh_toan_online.dcID_KHOAN_CHI == C_TU_DIEN_LOAI_NOI_DUNG_HD_ONLINE.LUONG_HD_KO_CHINH_TRI)
{
m_txt_so_luong.Text = "1";
m_txt_he_so.Text = CIPConvert.ToStr(ip_us_gd_thanh_toan_online.dcSO_LUONG_HE_SO, "#,###.0");
}
else
{
if (ip_us_gd_thanh_toan_online.dcSO_LUONG_HE_SO == 0)
{
m_txt_so_luong.Text = "0";
}
else
{
m_txt_so_luong.Text = CIPConvert.ToStr(ip_us_gd_thanh_toan_online.dcSO_LUONG_HE_SO, "#,###");
}
m_txt_he_so.Text = "1";
}
m_txt_he_so.Text = CIPConvert.ToStr(ip_us_gd_thanh_toan_online.dcSO_LUONG_HE_SO, "#,###.0");
m_cbo_trang_thai_thanh_toan.SelectedValue = ip_us_gd_thanh_toan_online.dcID_TRANG_THAI;
m_txt_ghi_chu.Text = ip_us_gd_thanh_toan_online.strGHI_CHU;
// Cho phép sửa thông tin ra đề, chấm bài cuối kỳ
if (ip_us_gd_thanh_toan_online.dcID_KHOAN_CHI == C_TU_DIEN_LOAI_NOI_DUNG_HD_ONLINE.RA_DE_HET_MON ||
ip_us_gd_thanh_toan_online.dcID_KHOAN_CHI == C_TU_DIEN_LOAI_NOI_DUNG_HD_ONLINE.CHAM_HET_MON)
{
m_txt_so_luong.Enabled = true;
m_txt_so_luong.BackColor = Color.White;
}
}
