/// <summary> /// 异步 开始事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void worker_DoWork(object sender, DoWorkEventArgs e) { //需要执行的代码 worker.ReportProgress(5, "开始导入代理商类型...\r\n"); //导入代理商类型 AgentTypeDao agentTypeDao = new AgentTypeDao(); for (int i = 0; i < dgAgentType.RowCount; i++) { AgentType agentType = new AgentType(); agentType.agentNo = dgAgentType[0, i].Value.ToString(); agentType.agentType = dgAgentType[1, i].Value.ToString(); agentType.agentFeeMonth = this.dtFeeMonth.Value.ToString("yyyy-MM"); agentTypeDao.Delete(agentType); agentTypeDao.Add(agentType); } worker.ReportProgress(6, "导入代理商类型完成...\r\n"); worker.ReportProgress(7, "开始导入代理商类型说明...\r\n"); //导入代理商类型说明 AgentTypeCommentDao agentTypeCommentDao = new AgentTypeCommentDao(); for (int i = 0; i < dgAgentTypeComment.RowCount; i++) { AgentTypeComment agentTypeComment = new AgentTypeComment(); agentTypeComment.agentType = dgAgentTypeComment[0, i].Value.ToString(); agentTypeComment.agentTypeComment = dgAgentTypeComment[1, i].Value.ToString(); agentTypeComment.agentFeeMonth = this.dtFeeMonth.Value.ToString("yyyy-MM"); agentTypeCommentDao.Delete(agentTypeComment); agentTypeCommentDao.Add(agentTypeComment); } ImportLog importLog = new ChinaUnion_BO.ImportLog(); importLog.type="Agent"; importLog.import_month = this.dtFeeMonth.Value.ToString("yyyy-MM"); ImportLogDao importLogDao = new ChinaUnion_DataAccess.ImportLogDao(); importLogDao.Delete(importLog); importLogDao.Add(importLog); worker.ReportProgress(8, "导入代理商类型完成...\r\n"); //MessageBox.Show("数据上传完毕"); }
private void btnQuery_Click(object sender, EventArgs e) { this.Cursor = Cursors.WaitCursor; // 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; } } dgAgentType.ColumnHeadersDefaultCellStyle.WrapMode = DataGridViewTriState.False; this.dgAgentType.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None; dgAgentType.AutoResizeColumns(); dgAgentTypeComment.ColumnHeadersDefaultCellStyle.WrapMode = DataGridViewTriState.False; this.dgAgentTypeComment.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None; dgAgentTypeComment.AutoResizeColumns(); 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; }