N_XLXSBJ----MX/CLYLZDSQ_MAILInfo.aspx.cs

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using GThinking.N_MODEL.Page;
using GThinking.N_MISPRO.Data;
using System.Text;
using GThinking.N_MISPRO.TableCache;
using GThinking.N_MISPRO;
using GThinking.N_MISPRO.Utility;

namespace GThinking.N_XLXSBJ
{
    public partial class CLYLZDSQ_MAILInfo : SingleCardBase
    {

        CLYLZDSQ_MAIL entity = new CLYLZDSQ_MAIL();

        #region Page事件

        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 100860064;
            this.UMName = "材料用量制定申请";
            this.CurMaster = Master;
            this.CurEntity = entity;
            this.PageHeight = 400;
            this.PageWidth = 500;

            base.InitPage();
            Master.EnableInsertBtn = false;
            Master.EnableCopyBtn = false;
            Master.EnableDeleteBtn = false;
            Master.EnableEditBtn = false;
            Master.EnableSaveBtn = false;
            Master.EnableCancelBtn = false;
            Master.EnablePrintBtn = false;
            //使链接复制按钮不可用
            Master.StandardHelpButton.Nodes[0].Enabled = false;
            txtGTGC.ToolbarStartExpanded = false;
        }

        #endregion

        #region 模板事件继承

        protected override void LoadRecord()
        {
            if (!IsPostBack)
                entity.Param.Add("AFID", PageParam.GetRTrimString("AFID").Trim());
            else
                entity.Param.Add("AFID", txtAFID.Value.Trim());
            base.LoadRecord();
            GetYJXX(txtAFID.Value.Trim());
        }

        #endregion

        #region 自定义函数

        //查询邮件信息
        private void GetYJXX(string AFID)
        {
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL SQL = new TSQL(dberp);
            SQL.Clear();
            SQL.Add(" select AFFROMUSRID,AFUSRNAME,AFFROMTIME,AFTOUSERS,AFCOPYFOR,AFTITLE,AFCONTENT ");
            SQL.Add(" from AFFAIR where AFID=:pAFID ");
            SQL.ParamByName("pAFID").Value = AFID;
            DataSet ds = dberp.OpenDataSet(SQL);
            if (ds.Tables[0].Rows.Count > 0)
            {
                string sFJR = "";
                if (ds.Tables[0].Rows[0]["AFFROMUSRID"].ToString().IndexOf("@") != -1)   //外网发件人
                    sFJR = ds.Tables[0].Rows[0]["AFFROMUSRID"].ToString().Trim();
                else
                    sFJR = GetMCID(ds.Tables[0].Rows[0]["AFFROMUSRID"].ToString().Trim());
                string sFJSJ = ds.Tables[0].Rows[0]["AFFROMTIME"].ToString().Trim();
                string sSend1 = ds.Tables[0].Rows[0]["AFTOUSERS"].ToString().Trim();
                string sSend2 = ds.Tables[0].Rows[0]["AFCOPYFOR"].ToString().Trim();
                string sTitle = ds.Tables[0].Rows[0]["AFTITLE"].ToString().Trim();
                string sContent = ds.Tables[0].Rows[0]["AFCONTENT"].ToString().Trim();
                txtGTGC.Value = GetQuote("#FFFF99", sFJR, sFJSJ, sSend1, sSend2, sTitle, sContent);
            }
        }

        // 引用原邮件的内容
        private String GetQuote(string backColor, string mailUserName, string mailFromTime, string mailToUsers, string mailCopyFor, string mailTitle, string mailContent)
        {
            string style = "background-color:" + backColor + ";padding-left:5px;padding-right:5px;word-break:break-all;";
            StringBuilder sResult = new StringBuilder();
            sResult.AppendLine("<font face=宋体 size=2>");
            sResult.AppendLine("<div style='border:#000000 1px solid;width:95%'>");
            //sResult.AppendLine("<div align=center style='" + style + ";border-bottom:#000000 1px solid;padding:5px'></div>");
            sResult.AppendLine("<div style='" + style + ";padding-top:5px'><strong>" + "发件人：" + "</strong>" + mailUserName + "</div>");
            sResult.AppendLine("<div style='" + style + "'>&nbsp;&nbsp;<strong>" + "时间：" + "</strong>" + mailFromTime + "</div>");
            sResult.AppendLine("<div style='" + style + "'><strong>" + "收件人：" + "</strong>" + mailToUsers + "</div>");
            sResult.AppendLine("<div style='" + style + "'>&nbsp;&nbsp;<strong>" + "抄送：" + "</strong>" + mailCopyFor + "</div>");
            sResult.AppendLine("<div style='" + style + ";border-bottom:#000000 1px solid;padding-bottom:5px'>&nbsp;&nbsp;<strong>" + "主题：" + "</strong>" + mailTitle + "</div>");
            sResult.AppendLine("</div></font>");
            sResult.AppendLine("<div style='padding:0px'>" + "<br>" + mailContent + "</div>");
            return sResult.ToString();
        }

        private String GetMCID(string sID)
        {
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");

            TSQL sql = new TSQL(dberp);
            DataSet ds;
            sql.Add("select rtrim(RSRYJBXX_RYMC) as MAILNAME  from RSRYJBXX ");
            sql.Add("where RSRYJBXX_GH=:pGH and isnull(RSRYJBXX_USER,' ')='Y'");
            sql.ParamByName("pGH").Value = sID;
            ds = dberp.OpenDataSet(sql);
            if (ds.Tables[0].Rows.Count > 0)
            {
                return string.Format("{0}<{1}>", ds.Tables[0].Rows[0]["MAILNAME"].ToString().Trim(), sID);
            }
            else
                return "";
        }

        //是否有100232002模块新建权限
        private bool CheckYJXJ(string sGH)
        {
            UserRight UR = OpRightUtils.GetUserRight(sGH, 100232002);
            return (DSActiveModule.IsActiveModule(100232002) && UR.Insert);
        }

        #endregion

        #region 控件事件

        //邮件通知
        protected void btnYJGT_Click(object sender, EventArgs e)
        {
            if (!CheckYJXJ(tSession.UserId))
            {
                ShowMessage("无[100232002|邮件]模块权限，无法发送邮件通知！");
                return;
            }
            TPageParams tpp = new TPageParams();
            tpp.UrlPath = "CLYL_YJGTInfo.aspx";
            tpp.CallAction = TPageCallAction.pcaInsert;
            tpp.AddString("MailInfo", "Y");
            tpp.AddString("AFID", txtAFID.Value.Trim());
            OpenDialog(tpp);
        }

        #endregion
    }
}