private void frmMailReSend_Load(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
worker = new BackgroundWorker();
worker.WorkerReportsProgress = true;
worker.DoWork += new DoWorkEventHandler(worker_DoWork);
worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(worker_RunWorkerCompleted);
AgentFeeDao agentFeeDao = new AgentFeeDao();
IList<AgentFee> agentFeeList = agentFeeDao.GetList(this.feeMonth);
if (agentFeeList != null && agentFeeList.Count > 0)
{
dgAgentFee.Rows.Clear();
dgAgentFee.Columns.Clear();
this.dgAgentFee.Columns.Add("代理商编号", "代理商编号");
this.dgAgentFee.Columns.Add("代理商名称", "代理商名称");
this.dgAgentFee.Columns.Add("代理商类型", "代理商类型");
this.dgAgentFee.Columns.Add("代理商类型说明", "代理商类型说明");
this.dgAgentFee.Columns.Add("联系人邮件", "联系人邮件");
this.dgAgentFee.Columns.Add("联系人名称", "联系人名称");
this.dgAgentFee.Columns.Add("告知单编号", "告知单编号");
dgAgentFee.Columns["联系人邮件"].Visible = false;
dgAgentFee.Columns["联系人名称"].Visible = false;
for (int i = 0; i < agentFeeList.Count; i++)
{
if (i == 0)
{
for (int j = 1; j <= 100; j++)
{
FieldInfo feeNameField = agentFeeList[i].GetType().GetField("feeName" + j);
// FieldInfo feeField = agentFeeList[i].GetType().GetField("fee" + j);
String feeNameFieldValue = feeNameField.GetValue(agentFeeList[i]) == null ? null : feeNameField.GetValue(agentFeeList[i]).ToString();
// String feeFieldValue = feeField.GetValue(agentFeeList[i]) == null ? null : feeField.GetValue(agentFeeList[i]).ToString(); ;
if (!String.IsNullOrEmpty(feeNameFieldValue) && !String.IsNullOrWhiteSpace(feeNameFieldValue))
{
dgAgentFee.Columns.Add(feeNameFieldValue, feeNameFieldValue);
}
}
this.dgAgentFee.Columns.Add("总计", "总计");
this.dgAgentFee.Columns.Add("开票金额", "开票金额");
this.dgAgentFee.Columns.Add("过网开票金额", "过网开票金额");
}
if (!htReSendMail.Contains(agentFeeList[i].agent.agentName))
{
continue;
}
dgAgentFee.Rows.Add();
DataGridViewRow row = dgAgentFee.Rows[dgAgentFee.RowCount-1];
row.Cells[0].Value = agentFeeList[i].agentNo;
row.Cells[1].Value = agentFeeList[i].agent.agentName;
row.Cells[2].Value = agentFeeList[i].agent.agentType;
row.Cells[3].Value = agentFeeList[i].agent.agentTypeComment.Replace(",","、").Replace("#","%");
row.Cells[4].Value = agentFeeList[i].agent.contactEmail;
row.Cells[5].Value = agentFeeList[i].agent.contactName;
row.Cells[6].Value = agentFeeList[i].agentFeeSeq;
int feeColIndex = 6;
int fixColCount = 7;
for (int j = 1; j <= 100; j++)
{
// FieldInfo feeNameField = agentFeeList[i].GetType().GetField("feeName" + j);
FieldInfo feeField = agentFeeList[i].GetType().GetField("fee" + j);
// String feeNameFieldValue = feeNameField.GetValue(agentFeeList[i]) == null ? null : feeNameField.GetValue(agentFeeList[i]).ToString();
String feeFieldValue = feeField.GetValue(agentFeeList[i]) == null ? null : feeField.GetValue(agentFeeList[i]).ToString(); ;
if (dgAgentFee.Columns.Count >= fixColCount + j)
{
row.Cells[feeColIndex + j].Value = feeFieldValue;
}
}
row.Cells[dgAgentFee.Columns.Count - 3].Value = agentFeeList[i].feeTotal;
row.Cells[dgAgentFee.Columns.Count - 2].Value = agentFeeList[i].invoiceFee;
row.Cells[dgAgentFee.Columns.Count - 1].Value = agentFeeList[i].preInvoiceFee;
}
}
showHtml(0);
this.Cursor = Cursors.Default;
}
private void btnQuery_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
//代理商信息
// Queryworker.ReportProgress(1, "代理商信息...\r\n");
// Queryworker.ReportProgress(2, "代理商渠道类型...\r\n");
//代理商渠道类型
AgentTypeDao agentTypeDao = new AgentTypeDao();
IList<AgentType> agentTypeList = agentTypeDao.GetList(dtFeeMonth.Value.ToString("yyyy-MM"));
dgAgentType.Rows.Clear();
dgAgentType.Columns.Clear();
if (agentTypeList != null && agentTypeList.Count > 0)
{
dgAgentType.Columns.Add("代理商编号", "代理商编号");
dgAgentType.Columns.Add("渠道类型", "渠道类型");
for (int i = 0; i < agentTypeList.Count; i++)
{
dgAgentType.Rows.Add();
DataGridViewRow row = dgAgentType.Rows[i];
row.Cells[0].Value = agentTypeList[i].agentNo;
row.Cells[1].Value = agentTypeList[i].agentType;
}
}
// Queryworker.ReportProgress(3, "代理商渠道类型说明...\r\n");
//代理商渠道类型说明
AgentTypeCommentDao agentTypeCommentDao = new AgentTypeCommentDao();
IList<AgentTypeComment> agentTypeCommentList = agentTypeCommentDao.GetList(dtFeeMonth.Value.ToString("yyyy-MM"));
dgAgentTypeComment.Rows.Clear();
dgAgentTypeComment.Columns.Clear();
if (agentTypeCommentList != null && agentTypeCommentList.Count > 0)
{
dgAgentTypeComment.Columns.Add("渠道类型", "渠道类型");
dgAgentTypeComment.Columns.Add("佣金说明", "佣金说明");
for (int i = 0; i < agentTypeCommentList.Count; i++)
{
dgAgentTypeComment.Rows.Add();
DataGridViewRow row = dgAgentTypeComment.Rows[i];
row.Cells[0].Value = agentTypeCommentList[i].agentType;
row.Cells[1].Value = agentTypeCommentList[i].agentTypeComment;
}
}
// Queryworker.ReportProgress(4, "代理商佣金...\r\n");
//代理商佣金
AgentFeeDao agentFeeDao = new AgentFeeDao();
IList<AgentFee> agentFeeList = agentFeeDao.GetList(dtFeeMonth.Value.ToString("yyyy-MM"));
AgentWechatAccount agentWechatAccount = new ChinaUnion_BO.AgentWechatAccount();
AgentWechatAccountDao agentWechatAccountDao = new ChinaUnion_DataAccess.AgentWechatAccountDao();
dgAgentFee.Rows.Clear();
dgAgentFee.Columns.Clear();
if (agentFeeList != null && agentFeeList.Count > 0)
{
this.grpAgentFee.Text = "月度佣金明细信息(" + agentFeeList.Count + ")";
dgAgentFee.Columns.Add("代理商编号", "代理商编号");
dgAgentFee.Columns.Add("代理商名称", "代理商名称");
dgAgentFee.Columns.Add("代理商类型", "代理商类型");
dgAgentFee.Columns.Add("代理商类型说明", "代理商类型说明");
dgAgentFee.Columns.Add("联系人邮件", "联系人邮件");
dgAgentFee.Columns.Add("联系人名称", "联系人名称");
dgAgentFee.Columns.Add("告知单编号", "告知单编号");
// dgAgentFee.Columns["联系人邮件"].Visible = false;
// dgAgentFee.Columns["联系人名称"].Visible = false;
for (int i = 0; i < agentFeeList.Count; i++)
{
if (i == 0)
{
for (int j = 1; j <= 100; j++)
{
FieldInfo feeNameField = agentFeeList[i].GetType().GetField("feeName" + j);
// FieldInfo feeField = agentFeeList[i].GetType().GetField("fee" + j);
String feeNameFieldValue = feeNameField.GetValue(agentFeeList[i]) == null ? null : feeNameField.GetValue(agentFeeList[i]).ToString();
// String feeFieldValue = feeField.GetValue(agentFeeList[i]) == null ? null : feeField.GetValue(agentFeeList[i]).ToString(); ;
if (!String.IsNullOrEmpty(feeNameFieldValue) && !String.IsNullOrWhiteSpace(feeNameFieldValue))
{
dgAgentFee.Columns.Add(feeNameFieldValue, feeNameFieldValue);
}
}
this.dgAgentFee.Columns.Add("总计", "总计");
this.dgAgentFee.Columns.Add("开票金额", "开票金额");
this.dgAgentFee.Columns.Add("过网开票金额", "过网开票金额");
}
dgAgentFee.Rows.Add();
DataGridViewRow row = dgAgentFee.Rows[i];
row.Cells[0].Value = agentFeeList[i].agentNo;
row.Cells[1].Value = agentFeeList[i].agent.agentName;
row.Cells[2].Value = agentFeeList[i].agent.agentType;
row.Cells[3].Value = agentFeeList[i].agent.agentTypeComment;
agentWechatAccount = agentWechatAccountDao.GetByAgentNo(agentFeeList[i].agentNo);
if (agentWechatAccount != null)
{
agentFeeList[i].agent.contactEmail = agentWechatAccount.contactEmail;
agentFeeList[i].agent.contactName = agentWechatAccount.contactName;
}
row.Cells[4].Value = agentFeeList[i].agent.contactEmail;
row.Cells[5].Value = agentFeeList[i].agent.contactName;
row.Cells[6].Value = agentFeeList[i].agentFeeSeq;
int feeColIndex = 6;
int fixColCount = 7;
for (int j = 1; j <= 100 ; j++)
{
// FieldInfo feeNameField = agentFeeList[i].GetType().GetField("feeName" + j);
FieldInfo feeField = agentFeeList[i].GetType().GetField("fee" + j);
// String feeNameFieldValue = feeNameField.GetValue(agentFeeList[i]) == null ? null : feeNameField.GetValue(agentFeeList[i]).ToString();
String feeFieldValue = feeField.GetValue(agentFeeList[i]) == null ? null : feeField.GetValue(agentFeeList[i]).ToString(); ;
if (dgAgentFee.Columns.Count >= fixColCount + j)
{
row.Cells[feeColIndex + j].Value = feeFieldValue;
}
}
row.Cells[dgAgentFee.Columns.Count - 3].Value = agentFeeList[i].feeTotal;
row.Cells[dgAgentFee.Columns.Count - 2].Value = agentFeeList[i].invoiceFee;
row.Cells[dgAgentFee.Columns.Count - 1].Value = agentFeeList[i].preInvoiceFee;
}
}
this.dgAgentType.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
dgAgentType.AutoResizeColumns();
this.dgAgentTypeComment.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
dgAgentTypeComment.AutoResizeColumns();
//this.dgAgent.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
//dgAgent.AutoResizeColumns();
if (dgAgentFee.RowCount > 0)
{
this.btnMail.Visible = true;
}
else
{
this.btnMail.Visible = false;
}
this.Cursor = Cursors.Default;
}