/// <summary>
/// 全部导出
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void AllExportToolStripMenuItem_Click(object sender, EventArgs e)
{
OleDbConnection oc = GlobalInfo.GlobalConnection;
oc.Open();
string sql = "select topic as 会议主题,department as 办会部门,creater as 办会人, createtime as 会议开始时间, endtime as 会议结束时间,uuid as 标识 from meetingtable";
OleDbCommand ocmd = new OleDbCommand(sql, oc);
OleDbDataAdapter oda = new OleDbDataAdapter(ocmd);
DataTable dt = new DataTable("meetinghistory");
oda.Fill(dt);
if (dt.Rows.Count == 0)
{
MessageBox.Show("未查到有效数据！");
return;
}
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = readValueFromConfigByNode("backup").ToString() == "0"?"(*.xml)|*.xml":"(*.xls)|*.xls";
if (sfd.ShowDialog() == DialogResult.OK)
{
if (File.Exists(sfd.FileName))
{
DialogResult dr = MessageBox.Show("文件已存在，是否覆盖？", "提示！", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
File.Delete(sfd.FileName);//先删除
}
else
{
return;
}
}
if (readValueFromConfigByNode("backup").ToString() == "0")
{
GlobalInfo.DataTableToXml(dt, sfd.FileName);
}
else
{
GlobalInfo.DataTableToExcel(dt, sfd.FileName);
}
MessageBox.Show("导出完毕！", "提示！");
}
}
/// <summary>
/// 确定
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void okBtn_Click(object sender, EventArgs e)
{
OleDbConnection oc = GlobalInfo.GlobalConnection;
oc.Open();
//根据条件进行添加
string createTimeStr = "";
bool createTimeFlag = false;
string topicStr = "";
string departStr = "";
string createrStr = "";
if (radioButton2.Checked)
{
if (dateTimePicker2.Value < dateTimePicker1.Value)
{
MessageBox.Show("时间配置错误，结束时间不能小于开始时间！");
return;
}
createTimeStr = " and createtime>@time1 and createtime<@time2 ";
createTimeFlag = true;
}
if (radioButton4.Checked)
{
if (topicKey.Text.Trim() == String.Empty)
{
MessageBox.Show("请输入关键字！");
return;
}
string[] tmp = topicKey.Text.Trim().Split('；');//使用中文分号
string list = "";
foreach (string str in tmp)
{
list = list + "topic like '%" + str + "%'" + " or ";
}
list = "(" + list.Substring(0, list.Length - 3) + ")";
topicStr = " and " + list;
}
if (radioButton6.Checked)
{
if (depart.Text.Trim() == String.Empty)
{
MessageBox.Show("请输入关键字！");
return;
}
string[] tmp = depart.Text.Trim().Split('；');
string list = "";
foreach (string str in tmp)
{
list = list + "department like '%" + str + "%'" + " or ";
}
list = "(" + list.Substring(0, list.Length - 3) + ")";
departStr = " and " + list;
}
if (radioButton8.Checked)
{
if (creater.Text.Trim() == String.Empty)
{
MessageBox.Show("请输入关键字！");
return;
}
string[] tmp = creater.Text.Trim().Split('；');
string list = "";
foreach (string str in tmp)
{
list = list + "creater like '%" + str + "%'" + " or ";
}
list = "(" + list.Substring(0, list.Length - 3) + ")";
createrStr = " and " + list;
}
string sql = "select topic as 会议主题,department as 办会部门,creater as 办会人, createtime as 会议开始时间, endtime as 会议结束时间,uuid as 标识 from meetingtable where 1=1 " + createTimeStr + topicStr + departStr + createrStr;
OleDbCommand ocmd = new OleDbCommand(sql, oc);
if (createTimeFlag)
{
ocmd.Parameters.Add("time1", OleDbType.Date);
ocmd.Parameters.Add("time2", OleDbType.Date);
ocmd.Parameters["time1"].Value = dateTimePicker1.Value;
ocmd.Parameters["time2"].Value = dateTimePicker2.Value;
}
OleDbDataAdapter oda = new OleDbDataAdapter(ocmd);
DataTable dt = new DataTable("meetinghistory");
oda.Fill(dt);
if (dt.Rows.Count == 0)
{
MessageBox.Show("未查到有效数据！");
return;
}
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = readValueFromConfigByNode("backup").ToString() == "0" ? "(*.xml)|*.xml" : "(*.xls)|*.xls";
if (sfd.ShowDialog() == DialogResult.OK)
{
if (File.Exists(sfd.FileName))
{
DialogResult dr = MessageBox.Show("文件已存在，是否覆盖？", "提示！", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dr == DialogResult.Yes)
{
File.Delete(sfd.FileName);//先删除
}
else
{
return;
}
}
if (readValueFromConfigByNode("backup").ToString() == "0")
{
GlobalInfo.DataTableToXml(dt, sfd.FileName);
}
else
{
GlobalInfo.DataTableToExcel(dt, sfd.FileName);
}
MessageBox.Show("导出完毕！", "提示！");
}
}