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("数据上传完毕");
}
