private void btnSave_Click(object sender, EventArgs e) { outputAgentInvoicePayment.month = this.txtMonth.Text.Trim(); outputAgentInvoicePayment.receivedTime = this.txtReceiveDate.Text.Trim(); outputAgentInvoicePayment.processTime = this.txtProcessTime.Text.Trim(); outputAgentInvoicePayment.agentName = this.txtAgentName.Text.Trim(); outputAgentInvoicePayment.agentNo = this.txtAgentNo.Text.Trim(); outputAgentInvoicePayment.content = this.txtContent.Text.Trim(); outputAgentInvoicePayment.invoiceFee = this.txtInvoiceFee.Text.Trim(); outputAgentInvoicePayment.invoiceType = this.txtInvoiceType.Text.Trim(); outputAgentInvoicePayment.invoiceNo = this.txtInvoiceNo.Text.Trim(); outputAgentInvoicePayment.payStatus = this.txtPayStatus.Text.Trim(); InvoicePaymentDao agentInvoicePaymenDao = new InvoicePaymentDao(); int i = agentInvoicePaymenDao.Update(outputAgentInvoicePayment); if (i >= 0) { MessageBox.Show("修改完成"); this.DialogResult = System.Windows.Forms.DialogResult.OK; } else { MessageBox.Show("修改失败"); } }
private void prepareGrid(string agentNo,string agentName, string invoiceNo) { this.Cursor = Cursors.WaitCursor; InvoicePaymentDao agentInvoicePaymentDao = new InvoicePaymentDao(); IList<InvoicePayment> agentInvoiceList = new List<InvoicePayment>(); agentInvoiceList = agentInvoicePaymentDao.GetList(agentNo, agentName, null, invoiceNo); if (agentInvoiceList != null && agentInvoiceList.Count > 0) { this.grpList.Text = "发票支付记录列表(" + agentInvoiceList.Count + ")"; this.dgInvoicePayment.Rows.Clear(); dgInvoicePayment.Columns.Clear(); dgInvoicePayment.Columns.Add("月份", "月份"); dgInvoicePayment.Columns.Add("收票日期", "收票日期"); dgInvoicePayment.Columns.Add("处理时间", "处理时间"); dgInvoicePayment.Columns.Add("代理商编号", "代理商编号"); dgInvoicePayment.Columns.Add("代理商全称", "代理商全称"); dgInvoicePayment.Columns.Add("内容", "内容"); dgInvoicePayment.Columns.Add("金额", "金额"); dgInvoicePayment.Columns.Add("发票类型", "发票类型"); dgInvoicePayment.Columns.Add("发票号", "发票号"); dgInvoicePayment.Columns.Add("票据状态", "票据状态"); for (int i = 0; i < agentInvoiceList.Count; i++) { dgInvoicePayment.Rows.Add(); DataGridViewRow row = dgInvoicePayment.Rows[i]; row.Cells[0].Value = agentInvoiceList[i].month ; row.Cells[1].Value = agentInvoiceList[i].receivedTime; row.Cells[2].Value = agentInvoiceList[i].processTime; row.Cells[3].Value = agentInvoiceList[i].agentNo; row.Cells[4].Value = agentInvoiceList[i].agentName; row.Cells[5].Value = agentInvoiceList[i].content; row.Cells[6].Value = agentInvoiceList[i].invoiceFee; row.Cells[7].Value = agentInvoiceList[i].invoiceType; row.Cells[8].Value = agentInvoiceList[i].invoiceNo; row.Cells[9].Value = agentInvoiceList[i].payStatus; } dgInvoicePayment.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgInvoicePayment.AutoResizeColumns(); } this.Cursor = Cursors.Default; }
/// <summary> /// 异步 开始事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void worker_DoWork(object sender, DoWorkEventArgs e) { //需要执行的代码 worker.ReportProgress(3, "开始导入支付记录...\r\n"); //导入代理商 InvoicePaymentDao agentInvoicePaymentDao = new InvoicePaymentDao(); AgentDao agentDao = new AgentDao(); WechatAction wechatAction = new WechatAction(); for (int i = 0; i < dgInvoicePayment.RowCount; i++) { InvoicePayment agentInvoicePayment = new InvoicePayment(); agentInvoicePayment.month = dgInvoicePayment[0, i].Value.ToString(); agentInvoicePayment.receivedTime = dgInvoicePayment[1, i].Value.ToString(); agentInvoicePayment.processTime = dgInvoicePayment[2, i].Value.ToString(); agentInvoicePayment.agentNo = dgInvoicePayment[3, i].Value.ToString(); agentInvoicePayment.agentName = dgInvoicePayment[4, i].Value.ToString(); agentInvoicePayment.content = dgInvoicePayment[5, i].Value.ToString(); agentInvoicePayment.invoiceFee = dgInvoicePayment[6, i].Value.ToString(); agentInvoicePayment.invoiceType = dgInvoicePayment[7, i].Value.ToString(); agentInvoicePayment.invoiceNo = dgInvoicePayment[8, i].Value.ToString(); agentInvoicePayment.payStatus = dgInvoicePayment[9, i].Value.ToString(); agentInvoicePaymentDao.Delete(agentInvoicePayment); agentInvoicePaymentDao.Add(agentInvoicePayment); dgInvoicePayment["result", i].Value = "导入成功"; } worker.ReportProgress(4, "导入支付记录完成...\r\n"); wechatAction.sendTextMessageToWechat("@all", "结算支付信息已发布,请通过底部菜单查询结算支付详情", Settings.Default.Wechat_Secret, MyConstant.APP_Payment); //MessageBox.Show("数据上传完毕"); }
/// <summary> /// 处理企业号的信息 /// </summary> /// <param name="context"></param> public void ProcessRequest(HttpContext context) { logger.Info(context.Request.Url.AbsoluteUri); // string sToken = "AgentFee"; // string sCorpID = "wx4fe8b74e01fffcbb"; // string sEncodingAESKey = "gvGJnhpjeljcKzvfe8B8vnmMBBLkJFuzUYSjsGcDQFE"; string sToken ="AgentFeeAndInvoicePaymentHandler";//"AgentFee"; string sCorpID = Properties.Settings.Default.Wechat_CorpId;// "wx31204de5a3ae758e"; string sEncodingAESKey = "4m6avCYhQ2p4IwjtMpFWNHRd46k2uIgdLbHSAlyCQsJ";// "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_Commission; 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; } switch (actionType) { case "FeeQueryHelp": sb.AppendFormat("<MsgType><![CDATA[text]]></MsgType>"); sb.AppendFormat("<Content><![CDATA[{0}]]></Content>", "佣金查询说明\n\n"); break; case "last6MonthBonus": String strBonusList = "最近6月红包查询\n\n"; for (int i = 1; i <= 6; i++) { String tempFeeMonth = DateTime.Now.AddMonths(0 - i).ToString("yyyyMM"); String url1 = String.Format("http://{0}/Wechat/AgentBonusDetailQuery.aspx?agentNo={1}&feeMonth={2}", Properties.Settings.Default.Host, QueryStringEncryption.Encode(agentNo, QueryStringEncryption.key), QueryStringEncryption.Encode(tempFeeMonth, QueryStringEncryption.key)); strBonusList = strBonusList + "<a href=\"" + url1 + "\">" + i + ":" + tempFeeMonth + "</a>"; strBonusList = strBonusList + "\n\n"; } sb.AppendFormat("<MsgType><![CDATA[text]]></MsgType>"); sb.AppendFormat("<Content><![CDATA[{0}]]></Content>", strBonusList); break; case "preMonthBonus": case "curMonthBonus": String feeMonthBonus = DateTime.Now.AddMonths(-1).ToString("yyyyMM"); if (actionType.Equals("preMonthBonus")) { feeMonthBonus = DateTime.Now.AddMonths(-2).ToString("yyyyMM"); } AgentBonusDao agentBonusDao = new AgentBonusDao(); AgentBonus agentBonus = agentBonusDao.GetByKey(feeMonthBonus, agentNo); if (agentBonus != null && !String.IsNullOrEmpty(agentBonus.agentNo)) { sb.Append(this.createAgentBonusNewsMessages(feeMonthBonus, agentBonus, agentNo)); } else { sb.AppendFormat("<MsgType><![CDATA[text]]></MsgType>"); sb.AppendFormat("<Content><![CDATA[{0}]]></Content>", "本月无红包或者红包尚未发布!\n\n"); } break; case "Latest6MonthFeeQuery": String strList = "最近6月佣金查询\n\n"; for (int i = 1; i <= 6; i++) { String tempFeeMonth = DateTime.Now.AddMonths(0 - i).ToString("yyyy-MM"); String url1 = String.Format("http://{0}/Wechat/AgentFeeQuery.aspx?agentNo={1}&feeMonth={2}", Properties.Settings.Default.Host, QueryStringEncryption.Encode(agentNo, QueryStringEncryption.key), QueryStringEncryption.Encode(tempFeeMonth, QueryStringEncryption.key)); strList = strList + "<a href=\"" + url1 + "\">" + i + ":" + tempFeeMonth + "</a>"; strList = strList + "\n\n"; } sb.AppendFormat("<MsgType><![CDATA[text]]></MsgType>"); sb.AppendFormat("<Content><![CDATA[{0}]]></Content>", strList); break; case "PreMonthFeeQuery": case "CurMonthFeeQuery": String feeMonth = DateTime.Now.AddMonths(-1).ToString("yyyy-MM"); if (actionType.Equals("PreMonthFeeQuery")) { feeMonth = DateTime.Now.AddMonths(-2).ToString("yyyy-MM"); } AgentFeeDao agentFeeDao = new AgentFeeDao(); AgentFee agentFee = agentFeeDao.GetByKey(feeMonth, agentNo); if (agentFee != null && !String.IsNullOrEmpty(agentFee.agentFeeSeq)) { sb.Append(this.createAgentFeeNewsMessages(feeMonth, agentFee, agentNo)); } else { sb.AppendFormat("<MsgType><![CDATA[text]]></MsgType>"); sb.AppendFormat("<Content><![CDATA[{0}]]></Content>", "本月无佣金或者佣金尚未发布\n\n"); } break; case "PaymentQueryHelp": sb.AppendFormat("<MsgType><![CDATA[text]]></MsgType>"); sb.AppendFormat("<Content><![CDATA[{0}]]></Content>", "发票支付查询说明\n\n"); break; case "Latest6MonthPaymentQuery": String strList1 = "最近6月发票支付查询\n\n"; for (int i = 1; i <= 6; i++) { String tempFeeMonth = DateTime.Now.AddMonths(0 - i).ToString("yyyyMM"); String url1 = String.Format("http://{0}/Wechat/InvoicePaymentQuery.aspx?agentNo={1}&feeMonth={2}", Properties.Settings.Default.Host, QueryStringEncryption.Encode(agentNo, QueryStringEncryption.key), QueryStringEncryption.Encode(tempFeeMonth, QueryStringEncryption.key)); strList1 = strList1 + "<a href=\"" + url1 + "\">" + i + ":" + tempFeeMonth + "</a>"; strList1 = strList1 + "\n\n"; } sb.AppendFormat("<MsgType><![CDATA[text]]></MsgType>"); sb.AppendFormat("<Content><![CDATA[{0}]]></Content>", strList1); break; case "PreMonthPaymentQuery": case "CurMonthPaymentQuery": feeMonth = DateTime.Now.AddMonths(-1).ToString("yyyyMM"); if (actionType.Equals("PreMonthPaymentQuery")) { feeMonth = DateTime.Now.AddMonths(-2).ToString("yyyyMM"); } InvoicePaymentDao agentInvoicePaymentDao = new InvoicePaymentDao(); IList<InvoicePayment> agentInvoicePaymentList = new List<InvoicePayment>(); // agentNo = "";//"DL224049"; // feeMonth = "201412"; logger.Info("1.feeMonth=" + feeMonth); logger.Info("2.agentNo=" + agentNo); agentInvoicePaymentList = agentInvoicePaymentDao.GetList(agentNo, null, feeMonth, null); if (agentInvoicePaymentList != null && agentInvoicePaymentList.Count > 0) { sb.Append(this.createPaymentNewsMessages(feeMonth, agentNo, agentInvoicePaymentList)); } else { sb.AppendFormat("<MsgType><![CDATA[text]]></MsgType>"); sb.AppendFormat("<Content><![CDATA[{0}]]></Content>", feeMonth.Substring(0, 4) + "年" + feeMonth.Substring(4, 2) + "月" + "无发票受理记录或尚未完成,请耐心等候!\n\n"); } break; default: if (!Regex.IsMatch(wechatMessage.Content, "((20[0-9][0-9])|(19[0-9][0-9]))-((0[1-9])|(1[0-2]))")) { sb.AppendFormat("<MsgType><![CDATA[text]]></MsgType>"); sb.AppendFormat("<Content><![CDATA[{0}]]></Content>", "请输入\"yyyy-mm\"查询某月佣金,支付结算和红包,例如:\"" + DateTime.Now.ToString("yyyy-MM") + "\"查询" + DateTime.Now.ToString("yyyy年MM月") + "佣金\n\n"); } else { feeMonth = wechatMessage.Content; agentFeeDao = new AgentFeeDao(); agentFee = agentFeeDao.GetByKey(feeMonth, wechatMessage.FromUserName); agentBonusDao = new AgentBonusDao(); feeMonthBonus = feeMonth.Replace("-", ""); agentBonus = agentBonusDao.GetByKey(feeMonthBonus, agentNo); agentInvoicePaymentDao = new InvoicePaymentDao(); String feeMonthInvoice = feeMonth.Replace("-", ""); agentInvoicePaymentList = agentInvoicePaymentDao.GetList(agentNo, null, feeMonthInvoice, null); sb.Append(this.createAllNewsMessages(feeMonth, wechatMessage.FromUserName, agentFee, agentBonus, agentInvoicePaymentList)); } 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); }
protected void Page_Load(object sender, EventArgs e) { string feeMonth = Request.QueryString["feeMonth"]; string agentNo = Request.QueryString["agentNo"]; string invoiceNo = Request.QueryString["invoiceNo"]; logger.Info("feeMonth=" + Request.QueryString["feeMonth"]); logger.Info("agentNo=" + Request.QueryString["agentNo"]); logger.Info("invoiceNo=" + Request.QueryString["invoiceNo"]); try { Request.ContentEncoding = Encoding.UTF8; feeMonth = QueryStringEncryption.Decode(feeMonth, QueryStringEncryption.key); agentNo = QueryStringEncryption.Decode(agentNo, QueryStringEncryption.key); // invoiceNo = QueryStringEncryption.Decode(invoiceNo, QueryStringEncryption.key); logger.Info("feeMonth=" + feeMonth); logger.Info("agentNo=" + agentNo); logger.Info("invoiceNo=" + invoiceNo); } catch (Exception) { // return; } WechatQueryLog wechatQueryLog = new ChinaUnion_BO.WechatQueryLog(); wechatQueryLog.agentName = ""; wechatQueryLog.module = Util.MyConstant.module_Commission; wechatQueryLog.subSystem = "支付结算查询"; wechatQueryLog.queryTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); wechatQueryLog.queryString = feeMonth; wechatQueryLog.wechatId = agentNo; WechatQueryLogDao wechatQueryLogDao = new WechatQueryLogDao(); try { wechatQueryLogDao.Add(wechatQueryLog); } catch { } DataTable dt = new DataTable(); DataRow row = null; dt.Columns.Add("result"); //dt.Columns.Add("processTime"); //dt.Columns.Add("invoiceFee"); //dt.Columns.Add("payFee"); //dt.Columns.Add("summary"); //dt.Columns.Add("payStatus"); // agentNo = "";// "DL224049"; // feeMonth = "201501"; InvoicePaymentDao agentInvoicePaymentDao = new InvoicePaymentDao(); IList<InvoicePayment> agentInvoicePaymentList = new List<InvoicePayment>(); agentInvoicePaymentList = agentInvoicePaymentDao.GetList(agentNo, null, feeMonth,null); if (agentInvoicePaymentList != null && agentInvoicePaymentList.Count > 0) { foreach (InvoicePayment agentInvoicePayment in agentInvoicePaymentList) { row = dt.NewRow(); row["result"] = "<b>收票日期</b>:" + agentInvoicePayment.receivedTime + "<br/><b>处理时间</b>:" + agentInvoicePayment.processTime + "<br/><b>内容</b>:" + agentInvoicePayment.content + "<br/><b>金额</b>:" + agentInvoicePayment.invoiceFee + "<br/><b>发票类型</b>:" + agentInvoicePayment.invoiceType + "<br/><b>发票号</b>:" + "***" + agentInvoicePayment.invoiceNo.Substring(3) + "<br/><b>付款状态</b>:" + agentInvoicePayment.payStatus; //row["processTime"] = agentInvoicePayment.processTime; //row["invoiceFee"] = agentInvoicePayment.invoiceFee; //row["payFee"] = agentInvoicePayment.payFee; //row["summary"] = agentInvoicePayment.summary; //row["payStatus"] = agentInvoicePayment.payStatus; dt.Rows.Add(row); } } else { row = dt.NewRow(); row["result"] = feeMonth + "无发票受理记录或尚未完成,请耐心等候。"; dt.Rows.Add(row); } //this.lblFeeMonth.Text = feeMonth + "支付查询结果"; GridView1.DataSource = dt.DefaultView; GridView1.DataBind(); }