void RefreshDataGridView() { DataTable source = _ServiceMonth.GetDetailInfo(_LnqBillInfo); if (source != null) { customDataGridView1.Rows.Clear(); foreach (DataRow dr in source.Rows) { customDataGridView1.Rows.Add(new object[] { dr["父级科目"].ToString(), dr["预算科目"].ToString(), Convert.ToDecimal(dr["年度预算"]), Convert.ToDecimal(dr["月度预算"]), dr["差异说明(年)"], Convert.ToDecimal(dr["实际金额"]), dr["差异说明(月)"], dr["科目ID"].ToString() }); } foreach (DataGridViewRow dgvr in customDataGridView1.Rows) { decimal yeardec = Convert.ToDecimal(dgvr.Cells["年度预算"].Value); decimal monthdec = Convert.ToDecimal(dgvr.Cells["月度预算"].Value); decimal actarldec = Convert.ToDecimal(dgvr.Cells["实际金额"].Value); if (monthdec > 0 && monthdec >= yeardec * (decimal)1.2) { dgvr.Cells["月度预算"].Style.BackColor = Color.Red; } if (actarldec > 0 && actarldec >= monthdec * (decimal)1.2) { dgvr.Cells["实际金额"].Style.BackColor = Color.Red; } } } }
private void 月度预算申请表_Form_btnPrint(object sender, EventArgs e) { IBudgetMonth serviceBudgetMonth = Service_Economic_Financial.ServerModuleFactory.GetServerModule <IBudgetMonth>(); if (tabControl1.SelectedTab.Text == "全部") { MessageDialog.ShowPromptMessage("请选择【已处理】或【待处理】中的记录"); return; } string billNo = ""; if (tabControl1.SelectedTab.Text == "已处理") { if (dataGridView2.Rows.Count > 0) { billNo = dataGridView2.CurrentRow.Cells["业务编号"].Value.ToString(); } } else if (tabControl1.SelectedTab.Text == "待处理") { if (dataGridView1.Rows.Count > 0) { billNo = dataGridView1.CurrentRow.Cells["业务编号"].Value.ToString(); } } Business_Finance_Budget_Month billInfo = serviceBudgetMonth.GetBillSingleInfo(billNo); DataTable tempTable = serviceBudgetMonth.GetDetailInfo(billInfo); ExcelHelperP.DataTableToExcel(saveFileDialog1, tempTable, null); }