private void ban_hanh_van_ban( string ip_str_danh_sach_email_ban_hanh , decimal ip_dc_id_van_thu) { US_GD_VAN_THU v_us = new US_GD_VAN_THU(ip_dc_id_van_thu); string[] v_arr_email = ip_str_danh_sach_email_ban_hanh.Split(';'); string v_str_mess = ""; try { for (int i = 0; i < v_arr_email.Length; i++) { if (!v_arr_email[i].Trim().Equals("")) { string v_str_send_to = v_arr_email[i]; if (!v_str_send_to.Contains("@gmail.com") && !v_str_send_to.Contains("@yahoo.com") && !v_str_send_to.Contains("@topica.edu.vn")) v_str_send_to += "@topica.edu.vn"; //Ghi du lieu Ban hanh van ban VanThu v_van_thu = new VanThu(); decimal v_dc_id_gd_ban_hanh = -1; v_dc_id_gd_ban_hanh = v_van_thu.ban_hanh_van_ban(v_us.dcID, DateTime.Now, v_str_send_to); string v_str_web_url = get_html_contain(ConfigurationSettings.AppSettings["WEB_URL"] + "/ChucNang/f604_xac_nhan_cong_van.aspx?mail=" + v_str_send_to + "&id_cong_van=" + v_dc_id_gd_ban_hanh, v_us.strTEN_LOAI_VA_TRICH_YEU_ND); if (!HelpUtils.SendEmailWithHtmlContent(v_str_send_to , "[QuanLyVanThu] Ban hanh van ban" , v_str_web_url , v_us.strLINK_SCAN)) { MessageBox.Show("Đã có lỗi trong quá trình thực hiện, bạn vui lòng thực hiện lại thao tác!", "Thông báo"); return; } //Ghi lich su Ban hanh van ban string v_str_van_ban_so = ""; if (v_us.dcID_LOAI_CONG_VAN == ID_LOAI_VAN_THU.CONG_VAN_DEN) { v_str_van_ban_so = v_us.strSO_CV_DEN; } else v_str_van_ban_so = v_us.strSO_VA_KY_HIEU; v_van_thu.ghi_lich_su_hanh_dong( CAppContext_201.getCurrentUserID() , DateTime.Now , "Ban hành văn bản số: " + v_str_van_ban_so + " cho email: " + v_str_send_to); } } v_us.Update(); MessageBox.Show("Đã gửi email ban hành văn bản thành công!", "Thông báo"); this.Close(); } catch (Exception v_e) { //CSystemLog_301.ExceptionHandle(v_e); MessageBox.Show("Đã có lỗi trong quá trình thực hiện, bạn vui lòng thực hiện lại thao tác!", "Thông báo"); return; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string v_str_email = ""; decimal v_dc_id_cong_van = 0; if (Request.QueryString["mail"] != null) { v_str_email = Request.QueryString["mail"]; } else { Response.Redirect("../../QuanLyHanhChinh"); } if (Request.QueryString["id_cong_van"] != null) { v_dc_id_cong_van = CIPConvert.ToDecimal(Request.QueryString["id_cong_van"]); } else { Response.Redirect("../../QuanLyHanhChinh"); } v_str_email = v_str_email.Replace("@topica.edu.vn", "").Replace("@gmail.com", ""); DS_GD_BAN_HANH_VAN_BAN v_ds_gd_ban_hanh = new DS_GD_BAN_HANH_VAN_BAN(); US_GD_BAN_HANH_VAN_BAN v_us_gd_ban_hanh = new US_GD_BAN_HANH_VAN_BAN(); v_us_gd_ban_hanh.FillDataset(v_ds_gd_ban_hanh, "where id=" + v_dc_id_cong_van); if (v_ds_gd_ban_hanh.GD_BAN_HANH_VAN_BAN.Count > 0) { // update lai danh sach email xac nhan VanThu v_van_thu = new VanThu(); v_van_thu.nhan_van_ban(v_dc_id_cong_van, DateTime.Now); //Ghi lich su v_us_gd_ban_hanh = new US_GD_BAN_HANH_VAN_BAN(v_dc_id_cong_van); string v_str_van_ban_so = ""; US_GD_VAN_THU v_us_gd_van_thu = new US_GD_VAN_THU(v_us_gd_ban_hanh.dcID_VAN_BAN); if (v_us_gd_van_thu.dcID_LOAI_CONG_VAN == ID_LOAI_VAN_THU.CONG_VAN_DEN) { v_str_van_ban_so = v_us_gd_van_thu.strSO_CV_DEN; } else v_str_van_ban_so = v_us_gd_van_thu.strSO_VA_KY_HIEU; //v_van_thu.ghi_lich_su_hanh_dong(Person.get_user_id(), DateTime.Now, "Nhận văn bản số: " + v_str_van_ban_so); m_lbl_thong_bao.Text = "Cám ơn bạn đã xác nhận công văn! Từ bây giờ, bạn có thể tra cứu công văn này trong chức năng!"; m_hpl_chuc_nang.NavigateUrl = "f603_tra_cuu_van_ban.aspx"; m_hpl_chuc_nang.Text = "Tra cứu văn thư"; } else Response.Redirect("../../QuanLyHanhChinh"); } }
protected void m_grv_dm_bill_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandArgument.ToString().Equals("")) return; decimal v_dc_id_van_thu = CIPConvert.ToDecimal(e.CommandArgument); US_GD_VAN_THU v_us = new US_GD_VAN_THU(v_dc_id_van_thu); if (v_us.strLINK_SCAN.Equals("")) return; if (e.CommandName == "TaiFile") { BCTKApp.App_Code.HelpUtils.Download(Server.MapPath("~") + "\\PdfScan", v_us.strLINK_SCAN.Replace("210.245.89.37/FileUpload_Vanthu/", "")); string v_str_file_save = Server.MapPath("~") + "\\PdfScan\\" + v_us.strLINK_SCAN.Replace("210.245.89.37/FileUpload_Vanthu/", ""); WebClient User = new WebClient(); Byte[] FileBuffer = User.DownloadData(v_str_file_save); if (FileBuffer != null) { Response.ContentType = "application/pdf"; Response.AddHeader("content-length", FileBuffer.Length.ToString()); Response.BinaryWrite(FileBuffer); } } }
private bool insert_data() { try { string v_str_file_name = m_txt_file_upload.Text.Split('\\')[m_txt_file_upload.Text.Split('\\').Length - 1]; string v_str_save_file = ConfigurationSettings.AppSettings["DOMAIN"] + "/" + "FileUpload_Vanthu" + "/" + v_str_file_name.Replace(ConfigurationSettings.AppSettings["DOMAIN"] + "/" + "FileUpload_Vanthu" + "/",""); if (!m_txt_file_upload.Text.Trim().Equals("") && !m_txt_file_upload.Text.Contains(ConfigurationSettings.AppSettings["DOMAIN"])) { if (!HelpUtils.ftpTransfer(m_txt_file_upload.Text.Replace(v_str_file_name, ""), v_str_file_name)) return false; } US_GD_VAN_THU v_us_gd_van_thu = new US_GD_VAN_THU(); if (m_dc_id_van_thu != 0) v_us_gd_van_thu = new US_GD_VAN_THU(m_dc_id_van_thu); if (m_tcd_ngay_tren_cv.getValue() == null) v_us_gd_van_thu.SetNGAY_THANG_TREN_CONG_VANNull(); else v_us_gd_van_thu.datNGAY_THANG_TREN_CONG_VAN = CIPConvert.ToDatetime(m_tcd_ngay_tren_cv.Text, "dd/MM/yyyy"); if (m_tcd_ngay_nhap.getValue() == null) v_us_gd_van_thu.SetNGAY_LAPNull(); else v_us_gd_van_thu.datNGAY_LAP = CIPConvert.ToDatetime(m_tcd_ngay_nhap.Text, "dd/MM/yyyy"); v_us_gd_van_thu.strSO_VA_KY_HIEU = m_txt_so_va_ky_hieu.Text.Trim(); v_us_gd_van_thu.strTEN_LOAI_VA_TRICH_YEU_ND = m_txt_ten_loai.Text.Trim(); US_DM_PHONG_BAN_PHAP_NHAN v_us_dm_phong_ban = new US_DM_PHONG_BAN_PHAP_NHAN(); DS_DM_PHONG_BAN_PHAP_NHAN v_ds_dm_phong_ban = new DS_DM_PHONG_BAN_PHAP_NHAN(); if (m_cbx_ban_luu.SelectedValue != null) { v_us_dm_phong_ban.FillDataset(v_ds_dm_phong_ban, " where id_phong_ban = " + m_cbx_ban_luu.SelectedValue); v_us_gd_van_thu.dcID_NGUOI_NHAN_BAN_LUU = CIPConvert.ToDecimal(m_cbx_ban_luu.SelectedValue); v_us_gd_van_thu.dcID_NOI_NGUOI_NHAN = CIPConvert.ToDecimal(m_cbx_ban_luu.SelectedValue); } else { v_us_gd_van_thu.SetID_NGUOI_NHAN_BAN_LUUNull(); v_us_gd_van_thu.SetID_NOI_NGUOI_NHANNull(); } if (v_ds_dm_phong_ban.Tables[0].Rows.Count > 0) v_us_gd_van_thu.dcID_PHAP_NHAN = CIPConvert.ToDecimal(v_ds_dm_phong_ban.Tables[0].Rows[0][DM_PHONG_BAN_PHAP_NHAN.ID_PHAP_NHAN]); else v_us_gd_van_thu.SetID_PHAP_NHANNull(); v_us_gd_van_thu.strGHI_CHU = m_txt_ghi_chu.Text.Trim(); v_us_gd_van_thu.dcID_TRANG_THAI = CIPConvert.ToDecimal(m_cbx_trang_thai.SelectedValue); v_us_gd_van_thu.strNGUOI_LAP = m_txt_nguoi_nhap.Text.Trim(); if (!m_txt_file_upload.Text.Trim().Equals(string.Empty)) v_us_gd_van_thu.strLINK_SCAN = v_str_save_file; else v_us_gd_van_thu.strLINK_SCAN = string.Empty; v_us_gd_van_thu.strSO_CV_DEN = m_txt_so_cv_den.Text.Trim(); v_us_gd_van_thu.strNOI_GUI = m_txt_noi_gui.Text.Trim(); v_us_gd_van_thu.dcID_LOAI_CONG_VAN = ID_LOAI_VAN_THU.CONG_VAN_DEN; v_us_gd_van_thu.strNOI_NHAN = m_cbx_ban_luu.Text.Trim(); if (v_us_dm_phong_ban.dcID == -1) { v_us_gd_van_thu.Insert(); US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN(); DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN(); v_us.FillDataset(v_ds, "where ma_tu_dien='CV_DEN'"); if (v_ds.CM_DM_TU_DIEN.Count > 0) { v_us.DataRow2Me(v_ds.Tables[0].Rows[0]); string v_str_so = v_ds.Tables[0].Rows[0][CM_DM_TU_DIEN.TEN_NGAN].ToString(); string v_str_nam = v_ds.Tables[0].Rows[0][CM_DM_TU_DIEN.TEN].ToString(); v_str_so = CIPConvert.ToStr(CIPConvert.ToDecimal(v_str_so) + 1, "0#"); m_txt_so_cv_den.Text = v_str_so + "/" + v_str_nam; v_us.strTEN = v_str_nam; v_us.strTEN_NGAN = v_str_so; v_us.Update(); } } else { v_us_dm_phong_ban.Update(); } return true; } catch (Exception v_e) { CSystemLog_301.ExceptionHandle(v_e); return false; } }
private void us_object_to_form() { if (m_dc_id_van_thu == 0) return; else { US_GD_VAN_THU v_us = new US_GD_VAN_THU(m_dc_id_van_thu); m_txt_file_upload.Text = v_us.strLINK_SCAN; m_txt_ghi_chu.Text = v_us.strGHI_CHU; m_txt_nguoi_nhap.Text = v_us.strNGUOI_LAP; m_txt_noi_gui.Text = v_us.strNOI_GUI; m_txt_so_va_ky_hieu.Text = v_us.strSO_VA_KY_HIEU; m_txt_so_cv_den.Text = v_us.strSO_CV_DEN; m_txt_ten_loai.Text = ""; } }
private void delete_v_gd_van_thu_all() { if (!CGridUtils.IsThere_Any_NonFixed_Row(m_fg)) return; if (!CGridUtils.isValid_NonFixed_RowIndex(m_fg, m_fg.Row)) return; if (BaseMessages.askUser_DataCouldBeDeleted(8) != BaseMessages.IsDataCouldBeDeleted.CouldBeDeleted) return; US_V_GD_VAN_THU_ALL v_us = new US_V_GD_VAN_THU_ALL(); US_GD_VAN_THU v_us_gd_van_thu = new US_GD_VAN_THU(); grid2us_object(v_us, m_fg.Row); try { v_us_gd_van_thu = new US_GD_VAN_THU(v_us.dcID); v_us_gd_van_thu.BeginTransaction(); v_us_gd_van_thu.Delete(); v_us_gd_van_thu.CommitTransaction(); m_fg.Rows.Remove(m_fg.Row); } catch (Exception v_e) { v_us_gd_van_thu.Rollback(); CDBExceptionHandler v_objErrHandler = new CDBExceptionHandler(v_e, new CDBClientDBExceptionInterpret()); v_objErrHandler.showErrorMessage(); } }
private void us_object_to_form(decimal ip_dc_id_cong_van) { if (ip_dc_id_cong_van == 0) { xoa_trang(); return; } US_GD_VAN_THU v_us = new US_GD_VAN_THU(ip_dc_id_cong_van); string[] v_arr_i = v_us.strSO_VA_KY_HIEU.Split('/'); m_txt_ghi_chu.Text = v_us.strGHI_CHU; m_txt_noi_nhan.Text = v_us.strNOI_NHAN; m_txt_file_upload.Text = v_us.strLINK_SCAN; m_txt_nguoi_ky.Text = v_us.strNGUOI_KY; m_txt_nguoi_nhap.Text = v_us.strNGUOI_LAP; m_txt_so.Text = v_arr_i[0] + "/" + v_arr_i[1]; m_cbx_ky_hieu.Text = v_us.strSO_VA_KY_HIEU.Replace(m_txt_so.Text,""); m_cbx_phap_nhan.SelectedValue = v_us.dcID_PHAP_NHAN.ToString(); m_cbx_trang_thai.SelectedValue = v_us.dcID_TRANG_THAI.ToString(); if (v_us.IsNGAY_LAPNull()) m_tcd_ngay_nhap.Text = ""; else m_tcd_ngay_nhap.Text = CIPConvert.ToStr(v_us.datNGAY_LAP, "dd/MM/yyyy"); if (v_us.IsNGAY_THANG_TREN_CONG_VANNull()) m_tcd_ngay_tren_cv.Text = ""; else m_tcd_ngay_tren_cv.Text = CIPConvert.ToStr(v_us.datNGAY_THANG_TREN_CONG_VAN, "dd/MM/yyyy"); m_txt_ten_loai.Text = v_us.strTEN_LOAI_VA_TRICH_YEU_ND; }
private bool save_data() { try { string v_str_file_name = m_txt_file_upload.Text.Split('\\')[m_txt_file_upload.Text.Split('\\').Length - 1]; string v_str_save_file = ConfigurationSettings.AppSettings["DOMAIN"] + "/" + "FileUpload_Vanthu" + "/" + v_str_file_name.Replace(ConfigurationSettings.AppSettings["DOMAIN"] + "/" + "FileUpload_Vanthu" + "/",""); if (!m_txt_file_upload.Text.Trim().Equals("") && !m_txt_file_upload.Text.Contains(ConfigurationSettings.AppSettings["DOMAIN"])) { if (!HelpUtils.ftpTransfer(m_txt_file_upload.Text.Replace(v_str_file_name, ""), v_str_file_name)) return false; } //HelpUtils.open_pdf_file(v_str_file_name, "..//Debug/FileScan"); US_GD_VAN_THU v_us_gd_van_thu = new US_GD_VAN_THU(); v_us_gd_van_thu.dcID = m_dc_id_cong_van; v_us_gd_van_thu.dcID_PHAP_NHAN = CIPConvert.ToDecimal(m_cbx_phap_nhan.SelectedValue); if (m_tcd_ngay_nhap.getValue()==null) { v_us_gd_van_thu.SetNGAY_LAPNull(); } else v_us_gd_van_thu.datNGAY_LAP = CIPConvert.ToDatetime(m_tcd_ngay_nhap.Text,"dd/MM/yyyy"); if (m_tcd_ngay_tren_cv.getValue()==null) { v_us_gd_van_thu.SetNGAY_THANG_TREN_CONG_VANNull(); } else v_us_gd_van_thu.datNGAY_THANG_TREN_CONG_VAN=CIPConvert.ToDatetime(m_tcd_ngay_tren_cv.Text,"dd/MM/yyyy"); v_us_gd_van_thu.strSO_VA_KY_HIEU = new StringBuilder(m_txt_so.Text.Trim()).Append(m_cbx_ky_hieu.Text.Trim()).ToString(); v_us_gd_van_thu.strNGUOI_KY = m_txt_nguoi_ky.Text; v_us_gd_van_thu.strTEN_LOAI_VA_TRICH_YEU_ND = m_txt_ten_loai.Text.Trim(); v_us_gd_van_thu.strNOI_NHAN = m_txt_noi_nhan.Text.Trim(); v_us_gd_van_thu.dcID_NGUOI_NHAN_BAN_LUU = CIPConvert.ToDecimal(m_cbx_ban_luu.SelectedValue); if (m_cbx_ban_luu.Text.Trim() == string.Empty) { MessageBox.Show("Bạn phải chọn Người nhận/Nơi nhận bản lưu", "Cảnh báo"); return false; } if (m_cbx_ban_luu.SelectedValue != null) { v_us_gd_van_thu.dcID_NOI_NGUOI_NHAN = CIPConvert.ToDecimal(m_cbx_ban_luu.SelectedValue); v_us_gd_van_thu.dcID_NGUOI_NHAN_BAN_LUU = CIPConvert.ToDecimal(m_cbx_ban_luu.SelectedValue); } else { v_us_gd_van_thu.SetID_NOI_NGUOI_NHANNull(); v_us_gd_van_thu.SetID_NGUOI_NHAN_BAN_LUUNull(); } v_us_gd_van_thu.strGHI_CHU = m_txt_ghi_chu.Text.Trim(); v_us_gd_van_thu.dcID_TRANG_THAI = CIPConvert.ToDecimal(m_cbx_trang_thai.SelectedValue); v_us_gd_van_thu.strNGUOI_LAP = m_txt_nguoi_nhap.Text.Trim(); if (!m_txt_file_upload.Text.Trim().Equals("")) v_us_gd_van_thu.strLINK_SCAN = v_str_save_file; else v_us_gd_van_thu.strLINK_SCAN = ""; v_us_gd_van_thu.dcID_LOAI_CONG_VAN = (m_rdb_noi_bo.Checked) ? ID_LOAI_VAN_THU.CONG_VAN_DI_NOI_BO : ID_LOAI_VAN_THU.CONG_VAN_DI_BEN_NGOAI; v_us_gd_van_thu.dcID_PHAP_NHAN = CIPConvert.ToDecimal(m_cbx_phap_nhan.SelectedValue); //Tu Dong nhay so cong van if (m_dc_id_cong_van == 0) { v_us_gd_van_thu.Insert(); //US_CM_DM_TU_DIEN v_us = new US_CM_DM_TU_DIEN(); //DS_CM_DM_TU_DIEN v_ds = new DS_CM_DM_TU_DIEN(); //v_us.FillDataset(v_ds, "where ma_tu_dien='" + m_cbx_phap_nhan.Text + "'"); //if (v_ds.CM_DM_TU_DIEN.Count > 0) //{ // string v_str_so = v_ds.Tables[0].Rows[0][CM_DM_TU_DIEN.TEN_NGAN].ToString(); // string v_str_nam = v_ds.Tables[0].Rows[0][CM_DM_TU_DIEN.TEN].ToString(); // v_str_so = CIPConvert.ToStr((CIPConvert.ToDecimal(v_str_so) + 1), "0#"); // v_us.DataRow2Me(v_ds.Tables[0].Rows[0]); // v_us.strTEN = v_str_nam; // v_us.strTEN_NGAN = v_str_so; // v_us.Update(); //} } else v_us_gd_van_thu.Update(); return true; } catch (Exception v_e) { CSystemLog_301.ExceptionHandle(v_e); return false; } }
private void m_cmd_save_Click(object sender, EventArgs e) { try { US_GD_VAN_THU v_us = new US_GD_VAN_THU(); if (!check_data_is_ok()) return; if (save_data()) { MessageBox.Show("Đã cập nhật văn bản thành công", "Thông báo"); clear_form_data(); } else { MessageBox.Show("Đã xảy lỗi trong quá trình xử lý!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception v_e) { CSystemLog_301.ExceptionHandle(v_e); } }
private void form_to_us_object(US_GD_VAN_THU op_us) { op_us.dcID = m_dc_id_cong_van; op_us.dcID_LOAI_CONG_VAN = ID_LOAI_VAN_THU.CONG_VAN_DEN; op_us.dcID_PHAP_NHAN=CIPConvert.ToDecimal(m_cbx_phap_nhan.SelectedValue); op_us.dcID_TRANG_THAI = CIPConvert.ToDecimal(m_cbx_trang_thai.SelectedValue); op_us.dcID_NOI_NGUOI_NHAN = CIPConvert.ToDecimal(m_cbx_ban_luu.SelectedValue); op_us.strGHI_CHU = m_txt_ghi_chu.Text; op_us.strLINK_SCAN = m_txt_file_upload.Text; op_us.strNGUOI_KY = m_txt_nguoi_ky.Text; op_us.strNGUOI_LAP = m_txt_nguoi_nhap.Text; op_us.strNOI_NHAN = m_txt_noi_nhan.Text; if (m_tcd_ngay_nhap.getValue()==null) { op_us.SetNGAY_LAPNull(); } else op_us.datNGAY_LAP = CIPConvert.ToDatetime(m_tcd_ngay_nhap.Text, "dd/MM/yyyy"); if (m_tcd_ngay_tren_cv.getValue() == null) { op_us.SetNGAY_THANG_TREN_CONG_VANNull(); } else op_us.datNGAY_THANG_TREN_CONG_VAN = CIPConvert.ToDatetime(m_tcd_ngay_tren_cv.Text, "dd/MM/yyyy"); }