private void btnSave_Click(object sender, EventArgs e) { outputAgentInvoicePayment.agentName = this.txtAgentName.Text; outputAgentInvoicePayment.agentNo = this.txtAgentNo.Text; outputAgentInvoicePayment.payStatus = this.txtPayStatus.Text; outputAgentInvoicePayment.processTime = this.txtProcessTime.Text; outputAgentInvoicePayment.invoiceFee = this.txtInvoiceFee.Text; outputAgentInvoicePayment.summary = this.txtSummary.Text; outputAgentInvoicePayment.payFee = this.txtPayFee.Text; AgentInvoicePaymentDao agentInvoicePaymenDao = new AgentInvoicePaymentDao(); int i = agentInvoicePaymenDao.Update(outputAgentInvoicePayment); if (i >= 0) { MessageBox.Show("修改完成"); this.DialogResult = System.Windows.Forms.DialogResult.OK; } else { MessageBox.Show("修改失败"); } }
private void prepareGrid(string agentNo,string agentName) { this.Cursor = Cursors.WaitCursor; AgentInvoicePaymentDao agentInvoicePaymentDao = new AgentInvoicePaymentDao(); IList<AgentInvoicePayment> agentInvoiceList = new List<AgentInvoicePayment>(); agentInvoiceList = agentInvoicePaymentDao.GetList(agentNo, agentName,null); if (agentInvoiceList != null && agentInvoiceList.Count > 0) { this.grpList.Text = "支付记录列表(" + agentInvoiceList.Count + ")"; this.dgInvoicePayment.Rows.Clear(); dgInvoicePayment.Columns.Clear(); dgInvoicePayment.Columns.Add("代理商编号", "代理商编号"); dgInvoicePayment.Columns.Add("代理商全称", "代理商全称"); dgInvoicePayment.Columns.Add("处理时间", "处理时间"); dgInvoicePayment.Columns.Add("发票金额", "发票金额"); dgInvoicePayment.Columns.Add("付款金额", "付款金额"); dgInvoicePayment.Columns.Add("摘要", "摘要"); dgInvoicePayment.Columns.Add("票据状态", "票据状态"); for (int i = 0; i < agentInvoiceList.Count; i++) { dgInvoicePayment.Rows.Add(); DataGridViewRow row = dgInvoicePayment.Rows[i]; row.Cells[0].Value = agentInvoiceList[i].agentNo; row.Cells[1].Value = agentInvoiceList[i].agentName; row.Cells[2].Value = agentInvoiceList[i].processTime; row.Cells[3].Value = agentInvoiceList[i].invoiceFee; row.Cells[4].Value = agentInvoiceList[i].payFee; row.Cells[5].Value = agentInvoiceList[i].summary; row.Cells[6].Value = agentInvoiceList[i].payStatus; } dgInvoicePayment.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgInvoicePayment.AutoResizeColumns(); } 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"); //导入代理商 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("数据上传完毕"); }