private void btnQuery_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
//代理商信息
// Queryworker.ReportProgress(1, "代理商信息...\r\n");
AgentContactDao agentContactDao = new AgentContactDao();
//agentDao.Get("P001");
IList<AgentContact> agentContactList = agentContactDao.GetListByKeyword(this.txtKeyword.Text.Trim());
dgAgentContact.Rows.Clear();
dgAgentContact.Columns.Clear();
if (agentContactList != null && agentContactList.Count > 0)
{
dgAgentContact.Columns.Add("代理商编号", "代理商编号");
dgAgentContact.Columns.Add("代理商名称", "代理商名称");
dgAgentContact.Columns.Add("渠道编码", "渠道编码");
dgAgentContact.Columns.Add("渠道名称", "渠道名称");
dgAgentContact.Columns.Add("所属区县", "所属区县");
dgAgentContact.Columns.Add("所属网格", "所属网格");
dgAgentContact.Columns.Add("联系人", "联系人");
dgAgentContact.Columns.Add("电话", "电话");
dgAgentContact.Columns.Add("邮箱", "邮箱");
for (int i = 0; i < agentContactList.Count; i++)
{
dgAgentContact.Rows.Add();
DataGridViewRow row = dgAgentContact.Rows[i];
row.Cells[0].Value = agentContactList[i].agentNo;
row.Cells[1].Value = agentContactList[i].agentName;
row.Cells[2].Value = agentContactList[i].branchNo;
row.Cells[3].Value = agentContactList[i].branchName;
row.Cells[4].Value = agentContactList[i].area;
row.Cells[5].Value = agentContactList[i].zone;
row.Cells[6].Value = agentContactList[i].contactName;
row.Cells[7].Value = agentContactList[i].contactTel;
row.Cells[8].Value = agentContactList[i].contactEmail;
}
}
this.dgAgentContact.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
dgAgentContact.AutoResizeColumns();
this.Cursor = Cursors.Default;
}
/// <summary>
/// 处理企业号的信息
/// </summary>
/// <param name="context"></param>
public void ProcessRequest(HttpContext context)
{
logger.Info(context.Request.Url.AbsoluteUri);
string sToken = "ContactUsHandler";
string sCorpID = Properties.Settings.Default.Wechat_CorpId;// "wx4fe8b74e01fffcbb";
string sEncodingAESKey = "Mh5NDLXhiRMu1GHitnufvEZKBdSh6c1zvOZbpdUOT2T";
// 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);
// string sRespData = "<MsgId>1234567890123456</MsgId>";
logger.Info("EventKey: " + wechatMessage.EventKey);
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_Contact;
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
{
}
}
if (agentWechatAccount != null && !String.IsNullOrEmpty(agentWechatAccount.status) && !agentWechatAccount.status.Equals("Y"))
{
sb.AppendFormat("<MsgType><![CDATA[text]]></MsgType>");
sb.AppendFormat("<Content><![CDATA[{0}]]></Content>", "对不起，你的账号已被停用，请联系联通工作人员!\n\n");
}
else if (agentWechatAccount == null)
{
sb.AppendFormat("<MsgType><![CDATA[text]]></MsgType>");
sb.AppendFormat("<Content><![CDATA[{0}]]></Content>", "用户不存在，请联系联通工作人员!\n\n");
}
else
{
String agentNo = agentWechatAccount.branchNo;
if (String.IsNullOrEmpty(agentNo))
{
agentNo = agentWechatAccount.agentNo;
}
AgentContactDao agentContactDao = new ChinaUnion_DataAccess.AgentContactDao();
switch (actionType)
{
case "CommonPhone":
sb.AppendFormat("<MsgType><![CDATA[text]]></MsgType>");
StringBuilder sbContent1 = new StringBuilder();
sbContent1.AppendFormat("1、支撑服务热线：4006186802").AppendLine();
sbContent1.AppendFormat("2、服务监督电话：61587555").AppendLine();
sbContent1.AppendFormat("3、IT服务热线：\n 18502143773\n 18502143774");
sb.AppendFormat("<Content><![CDATA[{0}]]></Content>", sbContent1.ToString());
break;
case "ContactPerson":
//AgentContact agentContact = new AgentContact();
IList<AgentContact> agentContactList = agentContactDao.GetListByNo(agentNo);
if (agentContactList != null && agentContactList.Count > 0)
{
logger.Info("Exist Record: " + agentContactList.Count);
sb.AppendFormat("<MsgType><![CDATA[text]]></MsgType>");
StringBuilder sbContent = new StringBuilder();
for (int i = 0; i < agentContactList.Count; i++)
{
AgentContact agentContact = agentContactList[i];
if (agentContactList.Count > 1)
{
sbContent.AppendFormat("第{0}联系人\n\n", i + 1);
}
if (!String.IsNullOrEmpty(agentContact.agentNo))
{
sbContent.AppendFormat("代理商编号:{0}", agentContact.agentNo).Append("\n");
sbContent.AppendFormat("代理商名称:{0}", agentContact.agentName).Append("\n");
}
if (!String.IsNullOrEmpty(agentContact.branchNo))
{
sbContent.AppendFormat("渠道编码:{0}", agentContact.branchNo).Append("\n");
sbContent.AppendFormat("渠道名称:{0}", agentContact.branchName).Append("\n");
}
sbContent.AppendFormat("所属区县:{0}", agentContact.area).Append("\n");
sbContent.AppendFormat("所属网格:{0}", agentContact.zone).Append("\n");
sbContent.AppendFormat("联系人:{0}", agentContact.contactName).Append("\n");
sbContent.AppendFormat("电话:{0}", agentContact.contactTel).Append("\n");
sbContent.AppendFormat("邮箱:{0}", agentContact.contactEmail).Append("\n").AppendLine();
}
sb.AppendFormat("<Content><![CDATA[{0}]]></Content>", sbContent.ToString());
// sb.Append(sbContent.ToString());
// sb.Append(this.createNewsMessages(feeDate, wechatMessage.FromUserName, agentDailyPerformance));
}
else
{
logger.Info("is not Existed Record: ");
sb.AppendFormat("<MsgType><![CDATA[text]]></MsgType>");
sb.AppendFormat("<Content><![CDATA[{0}]]></Content>", "没有找到对应的联系人，请直接与上海联通确认!\n\n");
}
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);
}
/// <summary>
/// 处理企业号的信息
/// </summary>
/// <param name="context"></param>
public void ProcessRequest(HttpContext context)
{
logger.Info(context.Request.Url.AbsoluteUri);
string sToken = "ServiceComplainHandler";
string sCorpID = Properties.Settings.Default.Wechat_CorpId;// "wx4fe8b74e01fffcbb";
string sEncodingAESKey = "1cKOgDDDPDBp2yveG55gootenlqivqTcX2K0wz804x5";
// 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);
// string sRespData = "<MsgId>1234567890123456</MsgId>";
logger.Info("EventKey: " + wechatMessage.EventKey);
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_Complain;
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
{
}
}
if (agentWechatAccount != null && !String.IsNullOrEmpty(agentWechatAccount.status) && !agentWechatAccount.status.Equals("Y"))
{
sb.AppendFormat("<MsgType><![CDATA[text]]></MsgType>");
sb.AppendFormat("<Content><![CDATA[{0}]]></Content>", "对不起，你的账号已被停用，请联系联通工作人员!\n\n");
}
else if (agentWechatAccount == null)
{
sb.AppendFormat("<MsgType><![CDATA[text]]></MsgType>");
sb.AppendFormat("<Content><![CDATA[{0}]]></Content>", "用户不存在，请联系联通工作人员!\n\n");
}
else
{
String agentNo = agentWechatAccount.branchNo;
if (String.IsNullOrEmpty(agentNo))
{
agentNo = agentWechatAccount.agentNo;
}
AgentContactDao agentContactDao = new ChinaUnion_DataAccess.AgentContactDao();
switch (actionType)
{
case "ContactPerson":
logger.Info("is not Existed Record: ");
sb.AppendFormat("<MsgType><![CDATA[text]]></MsgType>");
sb.AppendFormat("<Content><![CDATA[{0}]]></Content>", "没有找到对应的联系人，请直接与上海联通确认!\n\n");
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);
}
/// <summary>
/// 异步 开始事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void worker_DoWork(object sender, DoWorkEventArgs e)
{
//需要执行的代码
worker.ReportProgress(1, "开始导入代理商联系人...\r\n");
//导入代理商
AgentContactDao agentContactDao = new AgentContactDao();
for (int i = 0; i < dgAgentContact.RowCount; i++)
{
AgentContact agentContact = new AgentContact();
agentContact.agentNo = dgAgentContact[0, i].Value.ToString();
agentContact.agentName = dgAgentContact[1, i].Value.ToString();
agentContact.branchNo = dgAgentContact[2, i].Value.ToString();
agentContact.branchName = dgAgentContact[3, i].Value.ToString();
agentContact.area = dgAgentContact[4, i].Value.ToString();
agentContact.zone = dgAgentContact[5, i].Value.ToString();
agentContact.contactName = dgAgentContact[6, i].Value.ToString().Replace("；",";");
agentContact.contactTel = dgAgentContact[7, i].Value.ToString().Replace("；", ";");
agentContact.contactEmail = dgAgentContact[8, i].Value.ToString().Replace("；", ";");
String[] contactNames = agentContact.contactName.Split(';');
String[] contactTels = agentContact.contactTel.Split(';');
String[] contactEmails = agentContact.contactEmail.Split(';');
for (int j = 0; j < contactNames.Length; j++)
{
String contactName = contactNames[j];
agentContactDao.Delete(agentContact.agentNo.Trim(), agentContact.branchNo.Trim(), contactName);
agentContact.contactName = contactName;
if (contactTels.Length >= j + 1)
{
agentContact.contactTel = contactTels[j];
}
else
{
agentContact.contactTel = "";
}
if (contactEmails.Length >= j + 1)
{
agentContact.contactEmail = contactEmails[j];
}
else
{
agentContact.contactEmail = "";
}
agentContactDao.Add(agentContact);
}
}
worker.ReportProgress(4, "导入代理商联系人完成...\r\n");
WechatAction wechatAction = new WechatAction();
wechatAction.sendTextMessageToWechat("@all", "最新渠道经理信息已发布，请通过底部菜单联系最新渠道经理", Settings.Default.Wechat_Secret, MyConstant.APP_Contact);
//MessageBox.Show("数据上传完毕");
}
