private void btnSend_Click(object sender, EventArgs e) { if (this.txtContent.Text.Trim() == "") { MessageBox.Show("请输入公告内容"); return; } this.Cursor = Cursors.WaitCursor; WechatAction wechatAction = new WechatAction(); HttpResult result = wechatAction.sendTextMessageToWechat("@all", this.txtContent.Text.Trim(), Wechat_secretId, Wechar_AppId); this.Cursor = Cursors.Default; if (result.StatusCode == System.Net.HttpStatusCode.OK) { //表示访问成功,具体的大家就参考HttpStatusCode类 MessageBox.Show("发送成功"); this.Close(); } else { MessageBox.Show(result.StatusDescription); } }
private void btnSave_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(this.txtReplyContent.Text.Trim())) { MessageBox.Show("请输入回复内容!"); this.txtSubject.Focus(); return; } this.Cursor = Cursors.WaitCursor; AgentComplianSuggestionDao agentComplianSuggestionDao = new ChinaUnion_DataAccess.AgentComplianSuggestionDao(); AgentComplianSuggestion agentComplianSuggestion = new AgentComplianSuggestion(); agentComplianSuggestion.subject = this.txtSubject.Text; agentComplianSuggestion.content = this.txtContent.Text; agentComplianSuggestion.sequence = Int32.Parse(this.txtSequence.Text); agentComplianSuggestion.type = this.txtType.Text; agentComplianSuggestion.userId = this.txtUserId.Text; agentComplianSuggestion.agentNo = this.txtAgent.Text; agentComplianSuggestion.createTime = this.txtCreatetime.Text; agentComplianSuggestion.agentReadtime = this.txtReadtime.Text; agentComplianSuggestion.ownerDepartment = this.txtOnwerDepartment.Text; agentComplianSuggestion.ownerReplyContent = this.txtOwnerReply.Text; agentComplianSuggestion.checkStatus = this.txtCheckStatus.Text; agentComplianSuggestion.replyContent = this.txtReplyContent.Text; agentComplianSuggestion.replyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); agentComplianSuggestionDao.update(agentComplianSuggestion); WechatAction wechatAction = new WechatAction(); wechatAction.sendTextMessageToWechat(agentComplianSuggestion.userId, "针对您" + agentComplianSuggestion.type + "的:[" + agentComplianSuggestion.subject + "],反馈如下:\n" + agentComplianSuggestion.replyContent + " \n\n<a href=\"http://112.64.17.80/Wechat/OnlineComplainSuggestionDetail.aspx?seq=" + agentComplianSuggestion.sequence + "&from=OIC\">点击查询详情</a>", Settings.Default.Wechat_Secret, MyConstant.APP_Service_Monitor); prepareGrid(this.txtSearchCondition.Text.Trim(), this.cboType.Text, this.txtAgentNoSearch.Text.Trim()); MessageBox.Show("操作完成"); this.Cursor = Cursors.Default; }
/// <summary> /// 异步 开始事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void worker_DoWork(object sender, DoWorkEventArgs e) { //需要执行的代码 worker.ReportProgress(1, "开始导入代理商佣金...\r\n"); //导入代理商佣金 AgentFeeDao agentFeeDao = new AgentFeeDao(); for (int i = 0; i < dgAgentFee.RowCount; i++) { AgentFee agentFee = new AgentFee(); agentFee.agentFeeMonth = this.dtFeeMonth.Value.ToString("yyyy-MM"); agentFee.agentNo = dgAgentFee[0, i].Value.ToString(); agentFee.agentName= dgAgentFee[1, i].Value.ToString(); agentFee.agentFeeSeq = agentFee.agentNo + this.dtFeeMonth.Value.ToString("yyyyMM") + String.Format("{0:D5}", i+1); agentFee.feeTotal = dgAgentFee[dgAgentFee.Columns.Count - 3, i].Value.ToString(); agentFee.invoiceFee = dgAgentFee[dgAgentFee.Columns.Count - 2, i].Value.ToString(); agentFee.preInvoiceFee = dgAgentFee[dgAgentFee.Columns.Count - 1, i].Value.ToString(); for (int j = 2; j <= 101 && j < dgAgentFee.Columns.Count-3; j++) { FieldInfo feeNameField = agentFee.GetType().GetField("feeName" + (j-1)); FieldInfo feeField = agentFee.GetType().GetField("fee" + (j-1)); String feeNameFieldValue = dgAgentFee.Columns[j].HeaderCell.Value.ToString(); String feeFieldValue = dgAgentFee[j, i].Value.ToString(); if (feeFieldValue.Trim().Equals("0") || String.IsNullOrWhiteSpace(feeFieldValue)) { feeFieldValue = null; } feeNameField.SetValue(agentFee, feeNameFieldValue); feeField.SetValue(agentFee, feeFieldValue); } agentFeeDao.Delete(agentFee); agentFeeDao.Add(agentFee); } WechatAction wechatAction = new WechatAction(); wechatAction.sendTextMessageToWechat("@all", this.dtFeeMonth.Value.ToString("yyyy年MM月") + "佣金已发布,请通过底部菜单查询佣金详情", Settings.Default.Wechat_Secret, MyConstant.APP_Payment); worker.ReportProgress(2, "导入代理商佣金完成...\r\n"); //MessageBox.Show("数据上传完毕"); }
/// <summary> /// 异步 开始事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void worker_DoWork(object sender, DoWorkEventArgs e) { //需要执行的代码 Cursor.Current = Cursors.WaitCursor; if (dgAgentFee.RowCount <= 0) { return; } try{ MailData mailData = new MailData(); StringBuilder sbAgent = new StringBuilder(); worker.ReportProgress(1, "准备数据...\r\n"); WechatAction wechatAction = new WechatAction(); for (int i = 0; i < dgAgentFee.RowCount; i++) { if (dgAgentFee[4, i].Value == null) { continue; } if (String.IsNullOrEmpty(dgAgentFee[4, i].Value.ToString())) { continue; } StringBuilder sb = new StringBuilder(); String url = String.Format(Settings.Default.Wechat_Message, dgAgentFee[0, i].Value.ToString(), feeMonth); wechatAction.sendTextMessageToWechat(dgAgentFee[0, i].Value.ToString(), feeMonth + url, Settings.Default.Wechat_Secret, Settings.Default.Wechat_Agent_AppId); sb.Append("agent_no#").Append(dgAgentFee[0, i].Value == null ? "" : dgAgentFee[0, i].Value.ToString()).Append(","); sb.Append("agent_name#").Append(dgAgentFee[1, i].Value == null ? "" : dgAgentFee[1, i].Value.ToString().Replace(",", "、").Replace("#", "%")).Append(","); sb.Append("agent_type#").Append(dgAgentFee[2, i].Value == null ? "" : dgAgentFee[2, i].Value.ToString().Replace(",", "、").Replace("#", "%")).Append(","); sb.Append("agent_type_comment#").Append(dgAgentFee[3, i].Value == null ? "" : dgAgentFee[3, i].Value.ToString().Replace(",", "、").Replace("#", "%")).Append(","); sb.Append("email#").Append(dgAgentFee[4, i].Value == null ? "" : dgAgentFee[4, i].Value.ToString()); mailData.ContactJsonList.Add(sb.ToString()); } String client = Settings.Default.TripolisClient; String userName = Settings.Default.TripoisUserName; String password = Settings.Default.TripolisPassword; mailData.fromAddress = Settings.Default.MailFromAddress; mailData.replyAddress = Settings.Default.MailReplyAddress; mailData.sender = Settings.Default.MailSender; mailData.subject = this.subject; ChinaUnionAdapter mailAdapter = new ChinaUnionAdapter(client, userName, password, null); String databaseId = Settings.Default.TripolisDBId; String workspaceId = Settings.Default.TripolisWorkspaceId; String emailId = Settings.Default.TripolisDirectEmailId; worker.ReportProgress(1, "发送邮件...\r\n"); String message = mailAdapter.sendBatchMail(databaseId, workspaceId, emailId, mailData, this.dtFeeMonth.Value); if (message.Contains("OK:")) { String mailJobId = message.Substring(3); MailJob mailJob = new MailJob(); mailJob.feeMonth = feeMonth; mailJob.mailJobId = mailJobId; mailJob.subject = mailData.subject; mailJob.sendTime = this.dtFeeMonth.Value.ToString("yyyy-MM-dd hh:mm:ss"); MailJobDao mailJobDao = new MailJobDao(); mailJobDao.Delete(mailJob); mailJobDao.Add(mailJob); // WechatAction wechatAction = new WechatAction(); // wechatAction.sendMessageToWechat("@all",this.dtFeeMonth.Value.ToString("yyyy-MM") + Settings.Default.Wechat_Message); MessageBox.Show("邮件重新发送成功"); } else { MessageBox.Show(message); } } catch (Exception ex) { MessageBox.Show(ex.Message); } Cursor.Current = Cursors.Default; }
/// <summary> /// 异步 开始事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void worker_DoWork(object sender, DoWorkEventArgs e) { //需要执行的代码 worker.ReportProgress(1, "开始导入月度绩效...\r\n"); //导入非直供 AgentMonthPerformanceDao agentMonthPerformanceDao = new AgentMonthPerformanceDao(); for (int i = 0; i < dgAgentPerformanceNoDirect.RowCount; i++) { AgentMonthPerformance agentMonthPerformance = new AgentMonthPerformance(); agentMonthPerformance.month = this.dtMonth.Value.ToString("yyyy-MM"); agentMonthPerformance.branchNo = dgAgentPerformanceNoDirect[0, i].Value.ToString(); agentMonthPerformance.branchName = dgAgentPerformanceNoDirect[1, i].Value.ToString(); int index = 4; agentMonthPerformance.agentNo = dgAgentPerformanceNoDirect[2, i].Value.ToString(); agentMonthPerformance.agentName = dgAgentPerformanceNoDirect[3, i].Value.ToString(); agentMonthPerformance.type = "非直供渠道"; for (int j = index; j <= 101 && j < dgAgentPerformanceNoDirect.Columns.Count; j++) { FieldInfo feeNameField = agentMonthPerformance.GetType().GetField("feeName" + (j - index + 1)); FieldInfo feeField = agentMonthPerformance.GetType().GetField("fee" + (j - index + 1)); String feeNameFieldValue = dgAgentPerformanceNoDirect.Columns[j].HeaderCell.Value.ToString(); String feeFieldValue = dgAgentPerformanceNoDirect[j, i].Value.ToString(); if (feeFieldValue.Trim().Equals("0") || String.IsNullOrWhiteSpace(feeFieldValue)) { feeFieldValue = null; } feeNameField.SetValue(agentMonthPerformance, feeNameFieldValue); feeField.SetValue(agentMonthPerformance, feeFieldValue); } agentMonthPerformanceDao.Delete(agentMonthPerformance); agentMonthPerformanceDao.Add(agentMonthPerformance); } //导入直供 //AgentMonthPerformanceDao agentMonthPerformanceDao = new AgentMonthPerformanceDao(); for (int i = 0; i < dgAgentPerformanceDirect.RowCount; i++) { AgentMonthPerformance agentMonthPerformance = new AgentMonthPerformance(); agentMonthPerformance.type = "直供渠道"; agentMonthPerformance.month = this.dtMonth.Value.ToString("yyyy-MM"); agentMonthPerformance.branchNo = dgAgentPerformanceDirect[0, i].Value.ToString(); agentMonthPerformance.branchName = dgAgentPerformanceDirect[1, i].Value.ToString(); int index = 2; // agentMonthPerformance.agentNo = dgAgentPerformanceDirect[0, i].Value.ToString(); //agentMonthPerformance.agentName = dgAgentPerformanceDirect[1, i].Value.ToString(); for (int j = index; j <= 101 && j < dgAgentPerformanceDirect.Columns.Count; j++) { FieldInfo feeNameField = agentMonthPerformance.GetType().GetField("feeName" + (j - index + 1)); FieldInfo feeField = agentMonthPerformance.GetType().GetField("fee" + (j - index + 1)); String feeNameFieldValue = dgAgentPerformanceDirect.Columns[j].HeaderCell.Value.ToString(); String feeFieldValue = dgAgentPerformanceDirect[j, i].Value.ToString(); if (feeFieldValue.Trim().Equals("0") || String.IsNullOrWhiteSpace(feeFieldValue)) { feeFieldValue = null; } feeNameField.SetValue(agentMonthPerformance, feeNameFieldValue); feeField.SetValue(agentMonthPerformance, feeFieldValue); } agentMonthPerformanceDao.Delete(agentMonthPerformance); agentMonthPerformanceDao.Add(agentMonthPerformance); } WechatAction wechatAction = new WechatAction(); wechatAction.sendTextMessageToWechat("@all", this.dtMonth.Value.ToString("yyyy年MM月") + "业绩已发布,请通过底部菜单查询业绩详情", Settings.Default.Wechat_Secret, MyConstant.APP_Performace); //MessageBox.Show("数据上传完毕"); }
private void btnPublish_Click(object sender, EventArgs e) { //this.btnSave_Click(sender, e); // this.prepareGrid(this.txtSearchCondition.Text); if (String.IsNullOrEmpty(this.txtSequence.Text)) { MessageBox.Show("请先保存,再发布"); return; } this.Cursor = Cursors.WaitCursor; int appId = 0; switch (this.cbType.Text) { case "政策": appId = MyConstant.APP_Notice; break; case "通知公告/重点关注": appId = MyConstant.APP_Notice; break; case "服务规范": appId = MyConstant.APP_Service_Monitor; break; } AgentWechatAccountDao agentWechatAccountDao = new ChinaUnion_DataAccess.AgentWechatAccountDao(); String agentType = ""; foreach (object item in this.chkAgentType.CheckedItems) { agentType = item.ToString(); IList<String> list = agentWechatAccountDao.GetListByType(agentType); List<String> userIdsBuffer1 = new List<string>(); for (int i = 1; i <= list.Count; i++) { userIdsBuffer1.Add(list[i - 1]); if (i % 500 == 0 || i == list.Count) { string userId = ""; userId = string.Join("|", userIdsBuffer1.ToArray()); userIdsBuffer1.Clear(); WechatAction wechatAction = new WechatAction(); String content = this.txtSubject.Text.Trim(); String state = this.txtSequence.Text; String url = "https://open.weixin.qq.com/connect/oauth2/authorize?appid=wx31204de5a3ae758e&redirect_uri=http%3a%2f%2f112.64.17.80%2fwechat%2fBusinessPolicyDetail.aspx&response_type=code&scope=snsapi_base&state=" + state + "#wechat_redirect"; content = "你有新的消息,主题:" + content + ", <a href=\"" + url + "\">点击查询详情</a>"; HttpResult result = wechatAction.sendTextMessageToWechat(userId, content, Settings.Default.Wechat_Secret, appId); } } } IList<String> UserIdList = policyDao.GetAllUserIdListBySeq(this.txtSequence.Text); List<String> userIdsBuffer = new List<string>(); for (int i = 1; i <= UserIdList.Count; i++) { userIdsBuffer.Add(UserIdList[i - 1]); if (i % 500 == 0 || i == UserIdList.Count) { string userId = ""; userId = string.Join("|", userIdsBuffer.ToArray()); userIdsBuffer.Clear(); WechatAction wechatAction = new WechatAction(); String content = this.txtSubject.Text.Trim(); String state = this.txtSequence.Text; String url = "https://open.weixin.qq.com/connect/oauth2/authorize?appid=wx31204de5a3ae758e&redirect_uri=http%3a%2f%2f112.64.17.80%2fwechat%2fBusinessPolicyDetail.aspx&response_type=code&scope=snsapi_base&state=" + state + "#wechat_redirect"; content = "你有新的消息,主题:" + content + ", <a href=\"" + url + "\">点击查询详情</a>"; HttpResult result = wechatAction.sendTextMessageToWechat(userId, content, Settings.Default.Wechat_Secret, appId); } } this.Cursor = Cursors.Default; }
/// <summary> /// 异步 开始事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void worker_DoWork(object sender, DoWorkEventArgs e) { //需要执行的代码 Cursor.Current = Cursors.WaitCursor; try { String client = Settings.Default.TripolisClient; String userName = Settings.Default.TripoisUserName; String password = Settings.Default.TripolisPassword; ChinaUnionAdapter mailAdapter = new ChinaUnionAdapter(client, userName, password, null); MailData mailData = new MailData(); mailData.fromAddress = Settings.Default.MailFromAddress; mailData.replyAddress = Settings.Default.MailReplyAddress; mailData.sender = Settings.Default.MailSender; mailData.subject = this.subject; String databaseId = Settings.Default.TripolisDBId; String workspaceId = Settings.Default.TripolisWorkspaceId; String emailId = Settings.Default.TripolisDirectEmailId; worker.ReportProgress(1, "准备数据...\r\n"); WechatAction wechatAction = new WechatAction(); for (int i = 0; i < dgAgentFee.RowCount; i++) { if (dgAgentFee[4, i].Value == null) { continue; } if (String.IsNullOrEmpty(dgAgentFee[4, i].Value.ToString())) { continue; } StringBuilder sb = new StringBuilder(); String url = String.Format(Settings.Default.Wechat_Message, dgAgentFee[0, i].Value.ToString(), this.dateTimePicker1.Value.ToString("yyyy-MM")); wechatAction.sendTextMessageToWechat(dgAgentFee[0, i].Value.ToString(), this.feeMonth + url, Settings.Default.Wechat_Secret, Settings.Default.Wechat_Agent_AppId); sb.Append("agent_no#").Append(dgAgentFee[0, i].Value == null ? "" : dgAgentFee[0, i].Value.ToString()).Append(","); sb.Append("agent_name#").Append(dgAgentFee[1, i].Value == null ? "" : dgAgentFee[1, i].Value.ToString().Replace(",", "、").Replace("#", "%")).Append(","); sb.Append("agent_type#").Append(dgAgentFee[2, i].Value == null ? "" : dgAgentFee[2, i].Value.ToString().Replace(",", "、").Replace("#", "%")).Append(","); sb.Append("agent_type_comment#").Append(dgAgentFee[3, i].Value == null ? "" : dgAgentFee[3, i].Value.ToString().Replace(",","、").Replace("#","%")).Append(","); sb.Append("email#").Append(dgAgentFee[4, i].Value == null ? "" : dgAgentFee[4, i].Value.ToString()).Append(","); sb.Append("contact_name#").Append(dgAgentFee[5, i].Value == null ? "" : dgAgentFee[5, i].Value.ToString().Replace(",", "、").Replace("#", "%")).Append(","); sb.Append("agent_fee_seq#").Append(dgAgentFee[6, i].Value == null ? "" : dgAgentFee[6, i].Value.ToString()).Append(","); sb.Append("feemonth#").Append(this.feeMonth).Append(","); /// Dictionary<String, Dictionary<String, String>> CategoryMap = new Dictionary<string, Dictionary<String, String>>(); //按结账科目分类 int rowIndex = i; for (int j = 7; j < dgAgentFee.ColumnCount - 3; j++) { String headText = dgAgentFee.Columns[j].HeaderText; int locationIndex = headText.IndexOf("-"); int endIndex = headText.IndexOf("("); if (locationIndex == -1) { locationIndex = headText.IndexOf("-"); } if (endIndex == -1) { endIndex = headText.IndexOf("("); } String key = dgAgentFee.Columns[j].HeaderText.Substring(locationIndex + 1); if (endIndex != -1) { key = dgAgentFee.Columns[j].HeaderText.Substring(locationIndex + 1, endIndex - locationIndex - 1); } String value = dgAgentFee[j, rowIndex].Value == null ? "" : dgAgentFee[j, rowIndex].Value.ToString(); if (!CategoryMap.ContainsKey(key)) { Dictionary<String, String> valueMap = new Dictionary<string, string>(); valueMap.Add(headText, value); CategoryMap.Add(key, valueMap); } else { Dictionary<String, String> valueMap = CategoryMap[key]; valueMap.Add(headText, value); } } //int index = 1; int feeSeq = 1; int seq = 1; foreach (String itemKey in CategoryMap.Keys) { Dictionary<String, String> valueMap = CategoryMap[itemKey]; float subTotal = 0; foreach (String value in valueMap.Values) { if (!String.IsNullOrEmpty(value)) { subTotal = subTotal + float.Parse(value); } } sb.Append("fee_seq").Append(feeSeq.ToString()).Append("#").Append("").Append(","); sb.Append("fee_name").Append(feeSeq.ToString()).Append("#<b>").Append(itemKey.Replace(",", "、").Replace("#", "%")).Append("</b>,"); if (subTotal<=0) { sb.Append("fee").Append(feeSeq.ToString()).Append("#").Append("").Append(","); } else { sb.Append("fee").Append(feeSeq.ToString()).Append("#<b>").Append(subTotal).Append("</b>,"); } feeSeq++; foreach (String subKey in valueMap.Keys) { sb.Append("fee_name").Append(feeSeq.ToString()).Append("#").Append(subKey.Replace(",", "、").Replace("#", "%")).Append(","); if (String.IsNullOrEmpty(valueMap[subKey]) ||(!String.IsNullOrEmpty(valueMap[subKey]) && valueMap[subKey].Equals("0"))) { sb.Append("fee_seq").Append(feeSeq.ToString()).Append("#").Append("").Append(","); sb.Append("fee").Append(feeSeq.ToString()).Append("#").Append("").Append(","); } else { sb.Append("fee_seq").Append(feeSeq.ToString()).Append("#").Append(seq.ToString()).Append(","); sb.Append("fee").Append(feeSeq.ToString()).Append("#").Append(valueMap[subKey]).Append(","); seq++; } feeSeq++; } } for (int j = feeSeq; j <= 101; j++) { sb.Append("fee_seq").Append(feeSeq.ToString()).Append("#").Append("").Append(","); sb.Append("fee_name").Append(feeSeq.ToString()).Append("#").Append("").Append(","); sb.Append("fee").Append(feeSeq.ToString()).Append("#").Append("").Append(","); feeSeq++; } sb.Append("fee_total_seq").Append("#").Append(seq.ToString()).Append(","); sb.Append("fee_total#").Append(dgAgentFee[dgAgentFee.Columns.Count - 3, i].Value.ToString()).Append(","); seq++; sb.Append("invoice_fee_seq").Append("#").Append(seq.ToString()).Append(","); sb.Append("invoice_fee#").Append(dgAgentFee[dgAgentFee.Columns.Count - 2, i].Value.ToString()).Append(","); seq++; sb.Append("pre_invoice_fee_seq").Append("#").Append(seq.ToString()).Append(","); sb.Append("pre_invoice_fee#").Append(dgAgentFee[dgAgentFee.Columns.Count - 1, i].Value.ToString()); mailData.ContactJsonList.Add(sb.ToString()); Cursor.Current = Cursors.Default; } worker.ReportProgress(2, "发送邮件...\r\n"); String message = mailAdapter.sendBatchMail(databaseId, workspaceId, emailId, mailData, dateTimePicker1.Value); if (message.Contains("OK:")) { String mailJobId = message.Substring(3); MailJob mailJob = new MailJob(); mailJob.feeMonth = this.feeMonth; mailJob.mailJobId = mailJobId; mailJob.subject = mailData.subject; if (dateTimePicker1.Value != null) { mailJob.sendTime = dateTimePicker1.Value.ToString("yyyy-MM-dd hh:mm:ss"); } MailJobDao mailJobDao = new MailJobDao(); mailJobDao.Delete(mailJob); mailJobDao.Add(mailJob); MessageBox.Show("邮件发送成功"); } else { MessageBox.Show(message); } } catch (Exception ex) { MessageBox.Show(ex.Message); } //this.Close(); }
/// <summary> /// 异步 开始事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void worker_DoWork(object sender, DoWorkEventArgs e) { //需要执行的代码 worker.ReportProgress(1, "开始导入红包...\r\n"); AgentBonusDao agentBonusDao = new AgentBonusDao(); for (int i = 0; i < dgAgentBonus.RowCount; i++) { AgentBonus agentBonus = new AgentBonus(); agentBonus.month = this.dtFeeMonth.Value.ToString("yyyyMM"); agentBonus.agentNo = dgAgentBonus[0, i].Value.ToString(); agentBonus.agentName = dgAgentBonus[1, i].Value.ToString(); int index = 2; for (int j = index; j <= 101 && j < dgAgentBonus.Columns.Count; j++) { FieldInfo feeNameField = agentBonus.GetType().GetField("feeName" + (j - index + 1)); FieldInfo feeField = agentBonus.GetType().GetField("fee" + (j - index + 1)); String feeNameFieldValue = dgAgentBonus.Columns[j].HeaderCell.Value.ToString(); String feeFieldValue = dgAgentBonus[j, i].Value.ToString(); if (feeFieldValue.Trim().Equals("0") || String.IsNullOrWhiteSpace(feeFieldValue)) { feeFieldValue = null; } feeNameField.SetValue(agentBonus, feeNameFieldValue); feeField.SetValue(agentBonus, feeFieldValue); } agentBonusDao.Delete(agentBonus); agentBonusDao.Add(agentBonus); } worker.ReportProgress(4, "导入红包完成...\r\n"); WechatAction wechatAction = new WechatAction(); wechatAction.sendTextMessageToWechat("@all", this.dtFeeMonth.Value.ToString("yyyy年MM月") + "红包已发布,请通过底部菜单查询红包详情", Settings.Default.Wechat_Secret, MyConstant.APP_Payment); //MessageBox.Show("数据上传完毕"); }
private void btnPublish_Click(object sender, EventArgs e) { //this.btnSave_Click(sender, e); // this.prepareGrid(this.txtSearchCondition.Text); if (String.IsNullOrEmpty(this.txtSequence.Text)) { MessageBox.Show("请先保存,再发布"); return; } this.Cursor = Cursors.WaitCursor; int appId = 0; IList<String> UserIdList = new List<String>();//agentComplainDao.GetAllAgentNoListBySeq(this.txtSequence.Text); List<String> userIdsBuffer = new List<string>(); for (int i = 1; i <= UserIdList.Count; i++) { userIdsBuffer.Add(UserIdList[i - 1]); if (i % 500 == 0 || i == UserIdList.Count) { string userId = ""; userId = string.Join("|", userIdsBuffer.ToArray()); userIdsBuffer.Clear(); WechatAction wechatAction = new WechatAction(); String content = this.txtJoinTime.Text.Trim(); String state = this.txtSequence.Text; String url = "https://open.weixin.qq.com/connect/oauth2/authorize?appid=wx31204de5a3ae758e&redirect_uri=http%3a%2f%2f112.64.17.80%2fwechat%2fBusinessAgentComplainDetail.aspx&response_type=code&scope=snsapi_base&state=" + state + "#wechat_redirect"; content = "你有新的消息,主题:" + content + ", <a href=\"" + url + "\">点击查询详情</a>"; HttpResult result = wechatAction.sendTextMessageToWechat(userId, content, Settings.Default.Wechat_Secret, appId); } } 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="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("数据上传完毕"); }
private void sendMessage(int agentId, IList<String> recieveList) { WechatAction wechatAction = new WechatAction(); if (recieveList == null || recieveList.Count <= 0) { HttpResult result = wechatAction.sendTextMessageToWechat("@all", this.txtContent.Text.Trim(), Wechat_secretId, agentId); } else { //var result1 = recieveList.GroupBy(i => int.Parse(i) % 10).Select(g => g.ToList()).ToList(); List<String> userIdsBuffer = new List<string>(); for (int i = 1; i <= recieveList.Count; i++) { userIdsBuffer.Add(recieveList[i - 1]); if (i % 500 == 0 || i == recieveList.Count) { string userId = ""; userId = string.Join("|", userIdsBuffer.ToArray()); userIdsBuffer.Clear(); HttpResult result = wechatAction.sendTextMessageToWechat(userId, this.txtContent.Text.Trim(), Wechat_secretId, agentId); } } } 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"); //导入代理商 WechatAction wechatAction = new WechatAction(); AgentInvoiceDao agentInvoiceDao = new AgentInvoiceDao(); AgentDao agentDao = new AgentDao(); for (int i = 0; i < dgInvoice.RowCount; i++) { AgentInvoice agentInvoice = new AgentInvoice(); agentInvoice.invoiceMonth = dgInvoice[0, i].Value.ToString(); agentInvoice.invoiceDate = DateTime.Parse( dgInvoice[1, i].Value.ToString()).ToString("yyyy-MM-dd"); agentInvoice.agentNo = dgInvoice[2, i].Value.ToString(); agentInvoice.agentName = dgInvoice[3, i].Value.ToString(); agentInvoice.invoiceContent = dgInvoice[4, i].Value.ToString(); agentInvoice.invoiceFee = dgInvoice[5, i].Value.ToString(); agentInvoice.invoiceType = dgInvoice[6, i].Value.ToString(); agentInvoice.invoiceNo = dgInvoice[7, i].Value.ToString(); agentInvoice.comment = dgInvoice[8, i].Value.ToString(); Agent agent = agentDao.Get(agentInvoice.agentNo); if (agent != null && !String.IsNullOrEmpty(agent.agentName)) { agentInvoiceDao.Delete(agentInvoice); agentInvoiceDao.Add(agentInvoice); dgInvoice["result", i].Value = "导入成功"; String message = String.Format(Settings.Default.Invoice_Wechat_Message, agentInvoice.invoiceDate, agentInvoice.invoiceContent, agentInvoice.invoiceFee, agentInvoice.invoiceType, agentInvoice.invoiceNo,agentInvoice.comment); wechatAction.sendTextMessageToWechat(agentInvoice.agentNo, message, Settings.Default.Wechat_Secret, Settings.Default.Wechar_Invoice_AppId); } else { dgInvoice["result", i].Value = "导入失败,代理商编号:" + agentInvoice.agentNo+"不存在,请先导入代理商."; } } //dgInvoice.AutoResizeColumns(); worker.ReportProgress(4, "导入发票信息完成...\r\n"); //MessageBox.Show("数据上传完毕"); }
/// <summary> /// 异步 开始事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void worker_DoWork(object sender, DoWorkEventArgs e) { //需要执行的代码 worker.ReportProgress(3, "开始导入支付记录...\r\n"); //导入代理商 AgentInvoicePaymentDao agentInvoicePaymentDao = new AgentInvoicePaymentDao(); AgentDao agentDao = new AgentDao(); WechatAction wechatAction = new WechatAction(); for (int i = 0; i < dgInvoicePayment.RowCount; i++) { AgentInvoicePayment agentInvoicePayment = new AgentInvoicePayment(); agentInvoicePayment.agentNo = dgInvoicePayment[0, i].Value.ToString(); agentInvoicePayment.agentName = dgInvoicePayment[1, i].Value.ToString(); agentInvoicePayment.processTime = dgInvoicePayment[2, i].Value.ToString(); agentInvoicePayment.invoiceFee = dgInvoicePayment[3, i].Value.ToString(); agentInvoicePayment.payFee = dgInvoicePayment[4, i].Value.ToString(); agentInvoicePayment.summary = dgInvoicePayment[5, i].Value.ToString(); agentInvoicePayment.payStatus = dgInvoicePayment[6, i].Value.ToString(); Agent agent = agentDao.Get(agentInvoicePayment.agentNo); if (agent != null && !String.IsNullOrEmpty(agent.agentName)) { agentInvoicePaymentDao.Delete(agentInvoicePayment); agentInvoicePaymentDao.Add(agentInvoicePayment); dgInvoicePayment["result", i].Value = "导入成功"; String message = String.Format(Settings.Default.InvoicePayment_Wechat_Message, agentInvoicePayment.processTime, agentInvoicePayment.invoiceFee, agentInvoicePayment.payFee, agentInvoicePayment.summary, agentInvoicePayment.payStatus); wechatAction.sendTextMessageToWechat(agentInvoicePayment.agentNo, message, Settings.Default.Wechat_Secret, Settings.Default.Wechar_Invoice_AppId); } else { dgInvoicePayment["result", i].Value = "导入失败,代理商编号:" + agentInvoicePayment.agentNo + "不存在,请先导入代理商."; } } worker.ReportProgress(4, "导入支付记录完成...\r\n"); //MessageBox.Show("数据上传完毕"); }