private void btnOutput_Click(object sender, EventArgs e)
{
string strSql = "select *, b.员工姓名 AS 责任人, b.部门 AS 责任部门 from View_S_GaugeStandingBook as a " +
" left join dbo.View_HR_PersonnelArchive AS b ON a.DutyUser = b.员工编号";
ExcelHelperP.DataTableToExcel(saveFileDialog1, GlobalObject.DatabaseServer.QueryInfo(strSql), null);
}
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);
}
private void btnOutput_Click(object sender, EventArgs e)
{
try
{
ExcelHelperP.DataTableToExcel(saveFileDialog1, _Service_UnitList.GetMaxVersionNoInfo(), null);
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
}
}
private void 导出toolStripButton_Click(object sender, EventArgs e)
{
DataTable dt = GetFormatTable();
dataGridView1.DataSource = dt;
string[] hide = { "记录员", "记录时间", "备注", "部门编码", "全勤奖金" };
ExcelHelperP.DataTableToExcel(saveFileDialog1, dt, hide);
RefreshDataGridView();
}
private void btnOutDownSafeCount_Click(object sender, EventArgs e)
{
DataTable dtDate = (DataTable)dataGridView1.DataSource;
DataRow[] dr = dtDate.Select("安全库存数 > 实际库存数量");
DataTable dtPrint = dtDate.Clone();
for (int i = 0; i < dr.Length; i++)
{
dtPrint.ImportRow(dr[i]);
}
ExcelHelperP.DataTableToExcel(saveFileDialog1, dtPrint, null);
}
private void 餐补toolStripButton1_Click(object sender, EventArgs e)
{
DataTable dt = GetFormatTable();
string[] hide = { "迟到情况描述", "早退情况描述", "加班总小时数", "平时加班总小时数",
"周末加班总小时数", "法定节假日加班小时数", "加班补助总小时数", "加班调休小时数", "周末加班补助小时数",
"平时加班补助小时数", "周末加班调休小时数", "平时加班调休小时数", "未打卡次数", "旷工小时数", "事假次数",
"事假小时数", "病假次数", "病假小时数", "带薪病假次数", "带薪病假小时数", "出差次数", "出差小时数", "调休涉及天数", "允许调休小时数",
"调休次数", "调休小时数", "年假次数", "年假小时数", "婚假次数", "婚假小时数", "产假次数", "产假小时数", "清除加班小时数","年假剩余小时数",
"丧假次数", "丧假小时数", "考试假次数", "考试假小时数", "其他假次数", "其他假小时数", "记录员", "记录时间", "备注", "部门编码",
"全勤奖金" };
ExcelHelperP.DataTableToExcel(saveFileDialog1, dt, hide);
RefreshDataGridView();
}
private void 导出考勤toolStripButton_Click(object sender, EventArgs e)
{
DataTable dt = GetFormatTable();
string[] hide = { "迟到次数", "迟到情况描述", "早退次数", "早退情况描述", "加班次数", "加班总小时数", "平时加班总小时数",
"周末加班总小时数", "加班补助总小时数", "加班调休小时数", "未打卡次数", "旷工次数", "旷工小时数", "事假次数",
"事假涉及天数", "病假次数", "病假小时数", "病假涉及天数", "带薪病假次数", "带薪病假涉及天数", "出差次数",
"出差小时数", "出差假涉及天数", "清除加班小时数", "调休次数", "调休小时数", "调休涉及天数", "年假次数",
"年假小时数", "年假涉及天数", "婚假次数", "婚假小时数", "婚假涉及天数", "产假次数", "产假小时数",
"产假涉及天数", "丧假次数", "丧假小时数", "丧假涉及天数", "考试假次数", "考试假小时数", "考试假涉及天数",
"其他假次数", "其他假小时数", "其他假涉及天数", "扣餐补天数", "应考勤天数", "全勤奖金", "加班餐补", "出勤餐补",
"记录员", "记录时间", "部门编码", "备注" };
ExcelHelperP.DataTableToExcel(saveFileDialog1, dt, hide);
RefreshDataGridView();
}
private void 导出报缺项ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dataGridView1.Rows.Count > 0)
{
DataTable dt = ((DataTable)dataGridView1.DataSource).Clone();
DataRow[] dr = ((DataTable)dataGridView1.DataSource).Select("报缺数 < 0");
if (dr.Length > 0)
{
for (int a = 0; a <= dr.Length - 1; a++)
{
dt.ImportRow(dr[a]);
}
}
string[] hideColumns = { "物品ID" };
ExcelHelperP.DataTableToExcel(saveFileDialog1, dt, hideColumns);
}
}
private void 导出各部门在职人数ToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
if (!m_personnerServer.ExcelOnjob(out dt, out error))
{
MessageDialog.ShowPromptMessage(error);
return;
}
else
{
string[] columns = { };
ExcelHelperP.DataTableToExcel(saveFileDialog1, dt, columns);
}
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
}
}
private void btnOK_Click(object sender, EventArgs e)
{
try
{
DataTable dt = new DataTable();
if (!m_personnerServer.ExcelDimission(dtpStartDate.Value, dtpEndDate.Value, out dt, out m_error))
{
MessageDialog.ShowPromptMessage(m_error);
}
else
{
ExcelHelperP.DataTableToExcel(saveFileDialog1, dt, null);
}
this.Close();
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
this.Close();
}
}
private void btnEXCEL_Click(object sender, EventArgs e)
{
ExcelHelperP.DataTableToExcel(saveFileDialog1, (DataTable)dgvStockInfo.DataSource, null);
}
private void btnOutput_Click(object sender, EventArgs e)
{
string strSql = " select * from View_Provider where 是否在用 = 1";
ExcelHelperP.DataTableToExcel(saveFileDialog1, GlobalObject.DatabaseServer.QueryInfo(strSql), null);
}
private void btnOutExcelInfo_Click(object sender, EventArgs e)
{
ExcelHelperP.DataTableToExcel(saveFileDialog1, m_serverCBOM.GetSynthesisInfo(), null);
}
private void btnExcleOut_Click(object sender, EventArgs e)
{
ExcelHelperP.DataTableToExcel(saveFileDialog1, (DataTable)dataGridView1.DataSource, null);
}