protected void Page_Load(object sender, EventArgs e)
{
string sequence = Request.QueryString["seq"];
string userId = Request.QueryString["userId"];
PolicyDao policyDao = new ChinaUnion_DataAccess.PolicyDao();
Policy policy = policyDao.Get(Int32.Parse(sequence));
if (policy != null)
{
PolicyReceiverLogDao policyReceiverLogDao = new PolicyReceiverLogDao();
PolicyReceiverLog policyReceiverLog = new PolicyReceiverLog();
policyReceiverLog.policySequence = policy.sequence;
policyReceiverLog.readtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
policyReceiverLog.userId = userId;
policyReceiverLogDao.Add(policyReceiverLog);
Response.ContentType = "Application/pdf";
this.Response.Clear();
System.IO.Stream fs = this.Response.OutputStream;
fs.Write(policy.attachment, 0, policy.attachment.Length);
fs.Close();
this.Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string sequence = Request.QueryString["seq"];
string userId = Request.QueryString["userId"];
logger.Info("sequence=" + sequence);
logger.Info("userId=" + userId);
if (!String.IsNullOrEmpty(sequence))
{
PolicyDao policyDao = new ChinaUnion_DataAccess.PolicyDao();
Policy policy = policyDao.Get(Int32.Parse(sequence));
if (policy != null)
{
this.lblSubject.Text = policy.subject;
// this.lblSendTime.Text = policy.creatTime;
if (!String.IsNullOrEmpty(policy.content))
{
this.lblContent.Text = " <br>"+policy.content.Replace("\r\n", " <br>").Replace("\n", " <br>"); ;
}
logger.Info("sequence=" + sequence);
logger.Info("userId=" + userId);
PolicyReceiverLogDao policyReceiverLogDao = new PolicyReceiverLogDao();
PolicyReceiverLog policyReceiverLog = new PolicyReceiverLog();
policyReceiverLog.policySequence = policy.sequence;
policyReceiverLog.readtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
policyReceiverLog.userId = userId;
policyReceiverLogDao.Add(policyReceiverLog);
}
}
}
void bindDataToGrid(String subject, String agentNo,String userId)
{
logger.Info("bindDataToGrid=");
logger.Info("subject=" + subject);
logger.Info("agentNo=" + agentNo);
logger.Info("userId=" + userId);
PolicyDao policyDao = new ChinaUnion_DataAccess.PolicyDao();
IList<Policy> policyList = null;
policyList = policyDao.GetAllList(subject,"案例分享");
this.lblAgentNo.Text = agentNo;
this.lblUserId.Text = userId;
// int index = 1;
DataTable dt = new DataTable();
dt.Columns.Add("seq");
dt.Columns.Add("userId");
dt.Columns.Add("subject");
dt.Columns.Add("content");
// dt.Columns.Add("attachment");
// dt.Columns.Add("validateStartTime");
// dt.Columns.Add("validateEndTime");
DataRow row = null;
if (policyList != null && policyList.Count>0)
{
foreach (Policy policy in policyList)
{
if (!policy.toAll.Equals("Y"))
{
IList<String> UserIdList = policyDao.GetAllAgentNoListBySeq(policy.sequence);
if (!UserIdList.Contains(userId))
{
logger.Info("userId=" + userId + " 没有权限范围" + policy.sequence);
continue;
}
}
row = dt.NewRow();
row["seq"] = policy.sequence;
row["userId"] = userId;
row["subject"] = policy.subject;
if (policy.content.Length > 20)
{
row["content"] =policy.subject+":"+ policy.content.Substring(0, 20) + "......";
}
else
{
row["content"] = policy.subject + ":" + policy.content;
}
dt.Rows.Add(row);
}
}
else
{
this.lblMessag.Text = "未找到" + "记录!";
}
GridView1.DataSource = dt.DefaultView;
GridView1.DataBind();
}
void bindDataToGrid(String subject, String type, String search_scope, String agentNo,String userId)
{
logger.Info("bindDataToGrid=");
logger.Info("subject=" + subject);
logger.Info("type=" + type);
logger.Info("search_scope=" + search_scope);
logger.Info("agentNo=" + agentNo);
logger.Info("userId=" + userId);
PolicyDao policyDao = new ChinaUnion_DataAccess.PolicyDao();
IList<Policy> policyList = null;
if (!String.IsNullOrEmpty(search_scope) && search_scope.Equals("validate"))
{
policyList = policyDao.GetAllValidatedList(subject, type);
logger.Info("validate=");
}
if (!String.IsNullOrEmpty(search_scope) && search_scope.Equals("all"))
{
policyList = policyDao.GetList(subject, type);
logger.Info("all=");
}
this.lblType.Text = type;
this.lblScope.Text = search_scope;
this.lblAgentNo.Text = agentNo;
this.lblUserId.Text = userId;
// int index = 1;
DataTable dt = new DataTable();
dt.Columns.Add("seq");
dt.Columns.Add("userId");
dt.Columns.Add("subject");
dt.Columns.Add("content");
dt.Columns.Add("attachment");
dt.Columns.Add("validateStartTime");
dt.Columns.Add("validateEndTime");
DataRow row = null;
if (policyList != null && policyList.Count>0)
{
foreach (Policy policy in policyList)
{
if (!policy.toAll.Equals("Y"))
{
AgentWechatAccountDao agentWechatAccountDao = new AgentWechatAccountDao();
AgentWechatAccount agentWechatAccount = agentWechatAccountDao.Get(userId);
if (!String.IsNullOrEmpty(policy.agentType) )
{
IList<String> list = policy.agentType.Split(';').ToList<String>();
if (!list.Contains(agentWechatAccount.type))
{
continue;
}
}
if (String.IsNullOrEmpty(policy.agentType))
{
IList<String> agentNoList = policyDao.GetAllAgentNoListBySeq(policy.sequence);
if (!agentNoList.Contains(agentNo))
{
logger.Info("userId=" + userId + " 没有权限范围" + policy.sequence);
continue;
}
}
}
row = dt.NewRow();
row["seq"] = policy.sequence;
row["userId"] = userId;
row["subject"] = policy.subject;
if (policy.content.Length > 10)
{
row["content"] = policy.content.Substring(0, 10) + "......";
}
else
{
row["content"] = policy.content;
}
if (!String.IsNullOrEmpty(policy.attachmentName))
{
row["attachment"] = "附件";
}
row["validateStartTime"] = policy.validateStartTime;
row["validateEndTime"] = policy.validateEndTime;
dt.Rows.Add(row);
}
}
else
{
this.lblMessag.Text = "未找到" + type + "记录!";
}
GridView1.DataSource = dt.DefaultView;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string sequence = Request.QueryString["seq"];
string userId = Request.QueryString["userId"];
logger.Info("sequence=" + sequence);
logger.Info("userId=" + userId);
if (String.IsNullOrEmpty(sequence))
{
string code = Request.QueryString["code"];
sequence = Request.QueryString["state"];
string search_scope = Request.QueryString["search_scope"];
string agentId = Request.QueryString["agentId"];
logger.Info("agentId=" + Request.QueryString["agentId"]);
logger.Info("code=" + Request.QueryString["code"]);
logger.Info("state=" + Request.QueryString["state"]);
logger.Info("search_scope=" + Request.QueryString["search_scope"]);
WechatUtil wechatUtil = new Util.WechatUtil();
HttpResult result = wechatUtil.getUserInfoFromWechat(code, agentId, MyConstant.ScretId);
logger.Info("result=" + result.Html);
if (result != null && result.Html != null && result.Html.Contains("UserId"))
{
WechatUserId returnMessage = (WechatUserId)JsonConvert.DeserializeObject(result.Html, typeof(WechatUserId));
userId = returnMessage.UserId;
}
}
if (!String.IsNullOrEmpty(sequence))
{
PolicyDao policyDao = new ChinaUnion_DataAccess.PolicyDao();
Policy policy = policyDao.Get(Int32.Parse(sequence));
if (policy != null)
{
this.lblSubject.Text = policy.subject;
this.lblSendTime.Text = policy.creatTime;
if (!String.IsNullOrEmpty(policy.content))
{
this.lblContent.Text = policy.content.Replace("\r\n"," <br>").Replace("\n"," <br>");
}
this.lblValidateStartTime.Text = policy.validateStartTime;
this.lblValidateEndTime.Text = policy.validateEndTime;
this.lblAttachment.Text = policy.attachmentName;
this.lblAttachment.NavigateUrl = "BusinessPolicyAttachmentDetail.aspx?seq=" + policy.sequence + "&userId=" + userId;
logger.Info("sequence=" + sequence);
logger.Info("userId=" + userId);
PolicyReceiverLogDao policyReceiverLogDao = new PolicyReceiverLogDao();
PolicyReceiverLog policyReceiverLog = new PolicyReceiverLog();
policyReceiverLog.policySequence = policy.sequence;
policyReceiverLog.readtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
policyReceiverLog.userId = userId;
policyReceiverLogDao.Add(policyReceiverLog);
WechatQueryLog wechatQueryLog = new ChinaUnion_BO.WechatQueryLog();
wechatQueryLog.agentName = "";
wechatQueryLog.module = Util.MyConstant.module_Notice;
wechatQueryLog.subSystem = "通知公告与促销政策";
wechatQueryLog.queryTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
wechatQueryLog.queryString = policy.type;
wechatQueryLog.wechatId = userId;
WechatQueryLogDao wechatQueryLogDao = new WechatQueryLogDao();
try
{
wechatQueryLogDao.Add(wechatQueryLog);
}
catch
{
}
}
}
}
private void btnQuery_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
// Queryworker.ReportProgress(4, "代理商佣金...\r\n");
//代理商佣金
PolicyReceiverLogDao policyReceiverLogDao = new PolicyReceiverLogDao();
PolicyDao policyDao = new PolicyDao();
AgentWechatAccountDao agentWechatAccountDao = new AgentWechatAccountDao();
IList<PolicyReceiverLog> policyReceiverLogList = policyReceiverLogDao.GetList(this.txtSubjectKeyword.Text.Trim(), this.txtUserKeyword.Text.Trim(), this.dtDay.Value.ToString("yyyy-MM-dd"));
dgPolicyReadLog.Rows.Clear();
dgPolicyReadLog.Columns.Clear();
if (policyReceiverLogList != null && policyReceiverLogList.Count > 0)
{
this.grpAgentFee.Text = "阅读日志(" + policyReceiverLogList.Count + ")";
dgPolicyReadLog.Columns.Add("渠道类型", "渠道类型");
dgPolicyReadLog.Columns.Add("渠道编码", "渠道编码");
dgPolicyReadLog.Columns.Add("渠道名称", "渠道名称");
dgPolicyReadLog.Columns.Add("代理商编号", "代理商编号");
dgPolicyReadLog.Columns.Add("代理商名称", "代理商名称");
dgPolicyReadLog.Columns.Add("用户账号", "用户账号");
dgPolicyReadLog.Columns.Add("用户名", "用户名");
dgPolicyReadLog.Columns.Add("用户微信", "用户微信");
dgPolicyReadLog.Columns.Add("阅读时间", "阅读时间");
dgPolicyReadLog.Columns.Add("主题", "主题");
dgPolicyReadLog.Columns.Add("内容", "内容");
for (int i = 0; i < policyReceiverLogList.Count; i++)
{
// Policy policy = policyDao.Get(Int32.Parse(policyReceiverLogList[i].policySequence));
//AgentWechatAccount agentWechatAccount = agentWechatAccountDao.Get(policyReceiverLogList[i].userId);
dgPolicyReadLog.Rows.Add();
DataGridViewRow row = dgPolicyReadLog.Rows[i];
if (policyReceiverLogList[i].agentContact != null)
{
row.Cells[0].Value = policyReceiverLogList[i].agentContact.type;
row.Cells[1].Value = policyReceiverLogList[i].agentContact.branchNo;
row.Cells[2].Value = policyReceiverLogList[i].agentContact.branchName;
row.Cells[3].Value = policyReceiverLogList[i].agentContact.agentNo;
row.Cells[4].Value = policyReceiverLogList[i].agentContact.agentName;
row.Cells[5].Value = policyReceiverLogList[i].agentContact.contactId;
row.Cells[6].Value = policyReceiverLogList[i].agentContact.contactName;
row.Cells[7].Value = policyReceiverLogList[i].agentContact.contactWechat;
}
row.Cells[8].Value = policyReceiverLogList[i].readtime;
if (policyReceiverLogList[i].policy != null)
{
row.Cells[9].Value = policyReceiverLogList[i].policy.subject;
row.Cells[10].Value = policyReceiverLogList[i].policy.content;
}
}
}
dgPolicyReadLog.ColumnHeadersDefaultCellStyle.WrapMode = DataGridViewTriState.False;
this.dgPolicyReadLog.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
dgPolicyReadLog.AutoResizeColumns();
this.Cursor = Cursors.Default;
}
/// <summary>
/// 处理企业号的信息
/// </summary>
/// <param name="context"></param>
public void ProcessRequest(HttpContext context)
{
logger.Info(context.Request.Url.AbsoluteUri);
string sToken = "BusinessPolicyHandler";
string sCorpID = Properties.Settings.Default.Wechat_CorpId;// "wx4fe8b74e01fffcbb";
string sEncodingAESKey = "3jJb1Xr7z6fF7LJPCESk8wX8XFf8E6mK4MYIbiOY8yt";// "omiSDTqK4GjKmsQ6eCJSWpOtmqPcz6A3B41RBcg6Ey9";
// string sToken = Properties.Settings.Default.Wechat_AgentFee_Token;//"AgentFee";
// string sCorpID = Properties.Settings.Default.Wechat_CorpId;// "wx31204de5a3ae758e";
// string sEncodingAESKey = Properties.Settings.Default.Wechat_AgentFee_EncodingAESKey;// "he8dYrZ5gLbDrDhfHVJkea1AfmHgRZQJq47kuKpQrSO";
System.Collections.Specialized.NameValueCollection queryStrings = context.Request.QueryString;
Tencent.WXBizMsgCrypt wxcpt = new Tencent.WXBizMsgCrypt(sToken, sEncodingAESKey, sCorpID);
context.Request.ContentEncoding = Encoding.UTF8;
string sReqMsgSig = queryStrings["msg_signature"];
string sReqTimeStamp = queryStrings["timestamp"];
string sReqNonce = queryStrings["nonce"];
// 获取Post请求的密文数据
StreamReader reader = new StreamReader(context.Request.InputStream, Encoding.GetEncoding("UTF-8"));
string sReqData = reader.ReadToEnd();
reader.Close();
string sMsg = ""; // 解析之后的明文
int ret = wxcpt.DecryptMsg(sReqMsgSig, sReqTimeStamp, sReqNonce, sReqData, ref sMsg);
if (ret != 0)
{
logger.Info("ERR: Decrypt Fail, ret: " + ret);
System.Console.WriteLine("ERR: Decrypt Fail, ret: " + ret);
return;
}
// ret==0表示解密成功，sMsg表示解密之后的明文xml串
XmlDocument doc = new XmlDocument();
doc.LoadXml(sMsg);
WechatMessage wechatMessage = new WechatMessage(doc.DocumentElement);
// 需要发送的明文
String actionType = wechatMessage.EventKey;
StringBuilder sb = new StringBuilder();
sb.AppendFormat("<xml>");
sb.AppendFormat("<ToUserName><![CDATA[{0}]]></ToUserName>", wechatMessage.FromUserName);
sb.AppendFormat("<FromUserName><![CDATA[{0}]]></FromUserName>", wechatMessage.ToUserName);
sb.AppendFormat("<CreateTime>{0}</CreateTime>", wechatMessage.CreateTime);
AgentWechatAccountDao agentWechatAccountDao = new AgentWechatAccountDao();
AgentWechatAccount agentWechatAccount = agentWechatAccountDao.Get(wechatMessage.FromUserName);
if (agentWechatAccount != null && wechatMessage != null && !String.IsNullOrEmpty(wechatMessage.Event) && wechatMessage.Event.Equals("enter_agent"))
{
WechatQueryLog wechatQueryLog = new ChinaUnion_BO.WechatQueryLog();
wechatQueryLog.agentName = "";
wechatQueryLog.module = Util.MyConstant.module_Notice;
wechatQueryLog.subSystem = "通知公告与促销政策";
wechatQueryLog.queryTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
wechatQueryLog.queryString = "成员进入应用";
wechatQueryLog.wechatId = agentWechatAccount.contactId;
WechatQueryLogDao wechatQueryLogDao = new WechatQueryLogDao();
try
{
wechatQueryLogDao.Add(wechatQueryLog);
}
catch
{
}
}
// string sRespData = "<MsgId>1234567890123456</MsgId>";
logger.Info("EventKey: " + wechatMessage.EventKey);
String agentNo = wechatMessage.FromUserName;
AgentDao agentDao = new AgentDao();
Agent agent = agentDao.Get(agentNo);
if (agent != null && !String.IsNullOrEmpty(agent.status) && agent.status.Equals("Y"))
{
sb.AppendFormat("<MsgType><![CDATA[text]]></MsgType>");
sb.AppendFormat("<Content><![CDATA[{0}]]></Content>", "对不起，你的账号已被停用，请联系联通工作人员!\n\n");
}
else
{
PolicyDao policyDao = new ChinaUnion_DataAccess.PolicyDao();
switch (actionType)
{
case "LatestPolicy":
case "HistoryPolicy":
case "LatestNotice":
case "HistoryNotice":
IList<Policy> policyList =null;
if (actionType.Equals("LatestNotice"))
{
policyList = policyDao.GetAllList("");
}
else
{
policyList = policyDao.GetAllList("");
}
if (policyList != null && policyList.Count > 0)
{
sb.Append(this.createNewsMessages(wechatMessage.FromUserName, policyList));
}
else
{
sb.AppendFormat("<MsgType><![CDATA[text]]></MsgType>");
sb.AppendFormat("<Content><![CDATA[{0}]]></Content>", "没有公告发布!\n\n");
}
break;
default:
break;
}
}
// sb.AppendFormat("<AgentID>{0}</AgentID>", textMessage.AgentID);
sb.AppendFormat("</xml>");
string sRespData = sb.ToString();
string sEncryptMsg = ""; //xml格式的密文
ret = wxcpt.EncryptMsg(sRespData, sReqTimeStamp, sReqNonce, ref sEncryptMsg);
logger.Info("ret=" + ret);
if (ret != 0)
{
System.Console.WriteLine("ERR: EncryptMsg Fail, ret: " + ret);
return;
}
context.Response.Write(sEncryptMsg);
}
