protected void Page_Load(object sender, EventArgs e)
{
try
{
//this.Form.DefaultButton = m_cmd_tim_kiem.UniqueID;
if (!IsPostBack)
{
US_HT_NGUOI_SU_DUNG v_us_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG();
if (Session[SESSION.AccounLoginYN] == "Y")
{
decimal v_id_user = CIPConvert.ToDecimal(Session[SESSION.UserID]);
US_HT_NGUOI_SU_DUNG v_us_ht_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG();
IP.Core.IPData.DS_HT_NGUOI_SU_DUNG v_ds_ht_nguoi_su_dung = new IP.Core.IPData.DS_HT_NGUOI_SU_DUNG();
v_us_ht_nguoi_su_dung.FillDataset(v_ds_ht_nguoi_su_dung, " WHERE ID =" + v_id_user);
decimal v_id_user_group = CIPConvert.ToDecimal(v_ds_ht_nguoi_su_dung.HT_NGUOI_SU_DUNG.Rows[0]["ID_USER_GROUP"]);
US_HT_QUAN_HE_SU_DUNG_DU_LIEU v_us_ht_qh_sd_dl = new US_HT_QUAN_HE_SU_DUNG_DU_LIEU();
DS_HT_QUAN_HE_SU_DUNG_DU_LIEU v_ds_ht_qh_sd_dl = new DS_HT_QUAN_HE_SU_DUNG_DU_LIEU();
v_us_ht_qh_sd_dl.FillDataset(v_ds_ht_qh_sd_dl, "where ID_USER_GROUP =" + v_id_user_group);
m_hdf_id_trung_tam.Value = v_ds_ht_qh_sd_dl.HT_QUAN_HE_SU_DUNG_DU_LIEU.Rows[0]["ID_PHONG_BAN"].ToString();
set_thang_hien_tai();
set_inital_form_mode();
}
//thong_bao("", false);
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
if (!Person.check_user_have_menu())
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "<script type = 'text/javascript'>alert('Bạn không có quyền sử dụng chức năng này!');window.location.replace('/TraCuuKeToan/')</script>");
}
US_HT_NGUOI_SU_DUNG v_us_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG();
if (Session[SESSION.AccounLoginYN] == "Y")
{
decimal v_id_user = CIPConvert.ToDecimal(Session[SESSION.UserID]);
US_HT_NGUOI_SU_DUNG v_us_ht_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG();
IP.Core.IPData.DS_HT_NGUOI_SU_DUNG v_ds_ht_nguoi_su_dung = new IP.Core.IPData.DS_HT_NGUOI_SU_DUNG();
v_us_ht_nguoi_su_dung.FillDataset(v_ds_ht_nguoi_su_dung, " WHERE ID =" + v_id_user);
decimal v_id_user_group = CIPConvert.ToDecimal(v_ds_ht_nguoi_su_dung.HT_NGUOI_SU_DUNG.Rows[0]["ID_USER_GROUP"]);
US_HT_QUAN_HE_SU_DUNG_DU_LIEU v_us_ht_qh_sd_dl = new US_HT_QUAN_HE_SU_DUNG_DU_LIEU();
DS_HT_QUAN_HE_SU_DUNG_DU_LIEU v_ds_ht_qh_sd_dl = new DS_HT_QUAN_HE_SU_DUNG_DU_LIEU();
v_us_ht_qh_sd_dl.FillDataset(v_ds_ht_qh_sd_dl, "where ID_USER_GROUP =" + v_id_user_group);
m_hdf_id_trung_tam.Value = v_ds_ht_qh_sd_dl.HT_QUAN_HE_SU_DUNG_DU_LIEU.Rows[0]["ID_PHONG_BAN"].ToString();
}
else
{
Response.Redirect("../Default.aspx", false);
HttpContext.Current.ApplicationInstance.CompleteRequest();
}
set_time_set_ten_trung_tam();
load_data_to_grid();
thong_bao("", false);
view_detail_grv(false);
}
}
catch (System.Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
private bool gui_mail_thong_bao_cho_td()
{
string v_user_group_name = "TD_" + m_hdf_ma_trung_tam.Value.ToUpper();
US_HT_USER_GROUP v_us_user_group = new US_HT_USER_GROUP();
DS_HT_USER_GROUP v_ds_user_group = new DS_HT_USER_GROUP();
v_us_user_group.FillDataset(v_ds_user_group, "where USER_GROUP_NAME = '" + v_user_group_name + "' or USER_GROUP_NAME= '" + v_user_group_name + "-TU'");
if (v_ds_user_group.HT_USER_GROUP.Rows.Count > 0)
{
decimal v_id_user_group = CIPConvert.ToDecimal(v_ds_user_group.HT_USER_GROUP.Rows[0]["ID"]);
US_HT_NGUOI_SU_DUNG v_us_ht_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG();
IP.Core.IPData.DS_HT_NGUOI_SU_DUNG v_ds_ht_nguoi_su_dung = new IP.Core.IPData.DS_HT_NGUOI_SU_DUNG();
v_us_ht_nguoi_su_dung.FillDataset(v_ds_ht_nguoi_su_dung, "where ID_USER_GROUP =" + v_id_user_group);
string v_mail = v_ds_ht_nguoi_su_dung.HT_NGUOI_SU_DUNG.Rows[0]["MAIL"].ToString();
string v_str_noi_dung = "Kính gửi: Trưởng phòng " + " " + m_hdf_ma_trung_tam.Value
+ "\n"
+ "Vui lòng truy cập vào đường link bên dưới để duyệt đơn hàng VPP. Xin cám ơn!"
+ "\n"
+ "http://trm.topica.edu.vn/QuanLyHanhChinh/ChucNang/f481_td_duyet_don_hang_1.aspx?id_phong_ban=" + m_hdf_id_trung_tam.Value + "&form_mode=" + CONST_ID_TRANG_THAI_DON_HANG.XIN_TD_DUYET; ;
if (!v_mail.Equals("")) { BCTKApp.App_Code.HelpUtils.SendEmailHanhChinhTopica(v_mail, "Xin TD duyệt đơn hàng VPP", v_str_noi_dung); return true; }
else { thong_bao("Chưa có địa chỉ mail của TD.", true); return false; }
}
else
{ thong_bao("Không tìm thấy user TD để gửi mail.", true); return false; }
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
//this.Form.DefaultButton = m_cmd_tim_kiem.UniqueID;
if (!IsPostBack)
{
//if (!Person.check_user_have_menu())
//{
// ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "<script type = 'text/javascript'>alert('Bạn không có quyền sử dụng chức năng này!');window.location.replace('/TraCuuKeToan/')</script>");
//}
US_HT_NGUOI_SU_DUNG v_us_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG();
if (Session[SESSION.AccounLoginYN] == "Y")
{
decimal v_id_user = CIPConvert.ToDecimal(Session[SESSION.UserID]);
US_HT_NGUOI_SU_DUNG v_us_ht_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG();
IP.Core.IPData.DS_HT_NGUOI_SU_DUNG v_ds_ht_nguoi_su_dung = new IP.Core.IPData.DS_HT_NGUOI_SU_DUNG();
v_us_ht_nguoi_su_dung.FillDataset(v_ds_ht_nguoi_su_dung, " WHERE ID =" + v_id_user);
decimal v_id_user_group = CIPConvert.ToDecimal(v_ds_ht_nguoi_su_dung.HT_NGUOI_SU_DUNG.Rows[0]["ID_USER_GROUP"]);
US_HT_QUAN_HE_SU_DUNG_DU_LIEU v_us_ht_qh_sd_dl = new US_HT_QUAN_HE_SU_DUNG_DU_LIEU();
DS_HT_QUAN_HE_SU_DUNG_DU_LIEU v_ds_ht_qh_sd_dl = new DS_HT_QUAN_HE_SU_DUNG_DU_LIEU();
v_us_ht_qh_sd_dl.FillDataset(v_ds_ht_qh_sd_dl, "where ID_USER_GROUP =" + v_id_user_group);
m_hdf_id_trung_tam.Value = v_ds_ht_qh_sd_dl.HT_QUAN_HE_SU_DUNG_DU_LIEU.Rows[0]["ID_PHONG_BAN"].ToString();
m_hdf_id_user.Value = v_id_user.ToString();
set_inital_form_mode();
view_detail_grv(false);
}
thong_bao("", false, false);
}
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
protected void m_lbt_khong_duyet_OnClick(object sender, EventArgs e)
{
try
{
string v_mail;
US_HT_NGUOI_SU_DUNG v_us_ht_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG();
IP.Core.IPData.DS_HT_NGUOI_SU_DUNG v_ds_ht_nguoi_su_dung = new IP.Core.IPData.DS_HT_NGUOI_SU_DUNG();
v_us_ht_nguoi_su_dung.FillDataset(v_ds_ht_nguoi_su_dung, "where id= " + CIPConvert.ToDecimal(m_hdf_id_user.Value));
if (v_ds_ht_nguoi_su_dung.HT_NGUOI_SU_DUNG.Count > 0)
v_mail = v_ds_ht_nguoi_su_dung.HT_NGUOI_SU_DUNG.Rows[0]["MAIL"].ToString();
else { v_mail = "";}
US_GD_DON_DAT_HANG v_us_gd_don_hang = new US_GD_DON_DAT_HANG(CIPConvert.ToDecimal(m_hdf_id_don_hang.Value));
DateTime v_ngay_dat_hang = CIPConvert.ToDatetime(m_hdf_ngay_gui.Value);
DateTime m_dat_dau_thang = new DateTime(v_ngay_dat_hang.Year, v_ngay_dat_hang.Month, 1);
DateTime m_dat_cuoi_thang = m_dat_dau_thang.AddMonths(1).AddDays(-1);
if (CIPConvert.ToDecimal(m_hdf_form_mode.Value) == CONST_ID_TRANG_THAI_DON_HANG.XIN_TD_DUYET)
v_us_gd_don_hang.dcID_TRANG_THAI = CONST_ID_TRANG_THAI_DON_HANG.TD_KHONG_DUYET;
if (CIPConvert.ToDecimal(m_hdf_form_mode.Value) == CONST_ID_TRANG_THAI_DON_HANG.XIN_CC_DUYET)
v_us_gd_don_hang.dcID_TRANG_THAI = CONST_ID_TRANG_THAI_DON_HANG.CC_KHONG_DUYET;
v_us_gd_don_hang.Update();
string v_str_noi_dung = "Dear " + m_hdf_nguoi_gui.Value + ",\n"
+"Trung tâm- ban: " + m_hdf_ma_trung_tam.Value + "." + "\n"
+ "Đơn hàng MP:" + m_lbl_ma_don_hang_de.Text + " Lần: " + m_hdf_lan_dat.Value + " Ngày đặt: " + m_hdf_ngay_dat.Value + " Không được duyệt!"
+ "\n"
+ "Xin cám ơn!";
if (!v_mail.Equals("")) { BCTKApp.App_Code.HelpUtils.SendEmailHanhChinhTopica(v_mail, "Thông báo không duyệt", v_str_noi_dung); thong_bao("Đã gửi mail thông báo không duyệt cho người gửi đơn hàng này!",true); }
else { thong_bao("Chưa gửi mail thông báo duyệt cho người gửi đơn hàng!"); }
m_grv_don_hang_de.Visible = false;
m_grv_don_hang_nhap.Visible = false;
}
catch (System.Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
protected void m_lbt_duyet_OnClick(object sender, EventArgs e)
{
try
{
if (check_quyen_duyet() == false) { return; }
string v_mail;
US_HT_NGUOI_SU_DUNG v_us_ht_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG();
IP.Core.IPData.DS_HT_NGUOI_SU_DUNG v_ds_ht_nguoi_su_dung = new IP.Core.IPData.DS_HT_NGUOI_SU_DUNG();
v_us_ht_nguoi_su_dung.FillDataset(v_ds_ht_nguoi_su_dung, "where id= " + CIPConvert.ToDecimal(m_hdf_id_user.Value));
if (v_ds_ht_nguoi_su_dung.HT_NGUOI_SU_DUNG.Count > 0)
v_mail = v_ds_ht_nguoi_su_dung.HT_NGUOI_SU_DUNG.Rows[0]["MAIL"].ToString();
else v_mail = "";
US_GD_DON_DAT_HANG v_us_gd_don_hang = new US_GD_DON_DAT_HANG(CIPConvert.ToDecimal(m_hdf_id_don_hang.Value));
int thisyear = DateTime.Now.Year;
DateTime m_dat_dau_thang = new DateTime(thisyear, int.Parse(m_cbo_chon_thang.SelectedValue.ToString()), 1);
DateTime m_dat_cuoi_thang = m_dat_dau_thang.AddMonths(1).AddDays(-1);
v_us_gd_don_hang.dcID_TRANG_THAI = CONST_ID_TRANG_THAI_DON_HANG.DA_DUYET;
v_us_gd_don_hang.Update();
m_lbl_tong_tien_da_chi.Text = CIPConvert.ToStr(v_us_gd_don_hang.get_tong_tien_da_chi_hang_thang(v_us_gd_don_hang.dcID_PHONG_BAN, m_dat_cuoi_thang), "#,###");
string v_str_noi_dung = "Dear " + m_hdf_nguoi_gui.Value + ",\n"
+"Trung tâm- ban: " + m_hdf_ma_trung_tam.Value + "." + "\n"
+ "Đơn hàng VPP Mã phiếu:"+ m_lbl_ma_don_hang_de.Text+ " Lần: "+ m_hdf_lan_dat.Value+ " Ngày đặt: "+ m_hdf_ngay_dat.Value+ " đã được duyệt thành công!"
+ "\n"
+ "Xin cám ơn!";
if (!v_mail.Equals("")) { BCTKApp.App_Code.HelpUtils.SendEmailHanhChinhTopica(v_mail, "Thông báo đã duyệt", v_str_noi_dung); thong_bao("Duyệt thành công!", true); }
else { thong_bao("Duyệt thành công!"); }
m_grv_don_hang_nhap.Visible = false;
m_grv_don_hang_de.Visible = false;
}
catch (System.Exception v_e)
{
CSystemLog_301.ExceptionHandle(this, v_e);
}
}
