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);
}
