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