private void button9_Click(object sender, EventArgs e)
{
string tbname = comboBox2.Text.ToString();
string colname = comboBox5.Text.ToString();
string csql = " select distinct " + "[" + colname + "]" + " from " + "[" + tbname + "]";
string sql = " select * from " + "[" + tbname + "]" + " where " + "[" + colname + "]" + " = ";
IList <string> clums = new List <string>();
DataTable dt = UiServices.GetDataTableFromSQL(csql);
int num = dt.Rows.Count;
if (dt.Rows.Count > 0)
{
foreach (DataRow _DataRowItem in dt.Rows)
{
clums.Add(_DataRowItem[colname].ToString());
}
}
string filename = UiServices.ShowFileDialog(tbname);
Stopwatch watch = Stopwatch.StartNew();
watch.Start();
foreach (var a in clums)
{
string savepath = filename.Remove(filename.LastIndexOf('.')) + '_' + a + ".xlsx";
DataTable dt1 = UiServices.GetDataTableFromSQL(sql + "'" + a + "'");
UiServices.SaveExcel(savepath, dt1, "sheet1");
}
watch.Stop();
toolStripStatusLabel1.Text = string.Format("导出的时间为:{0}秒", watch.ElapsedMilliseconds / 1000);
toolStripStatusLabel1.ForeColor = Color.Red;
MessageBox.Show("导出成功");
GC.Collect();
}
/// <summary>
/// 单excel，openXML
/// </summary>
private void button6_Click(object sender, EventArgs e)
{
string TableName = comboBox4.Text.ToString();
string filename = UiServices.ShowFileDialog(TableName);
toolStripStatusLabel1.Text = "导数中…";
toolStripStatusLabel1.ForeColor = Color.Red;
if (filename != null)
{
Task t = TaskExport(TableName, filename);
}
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
try
{
string filename = UiServices.ShowFileDialog("Sheet1");
toolStripStatusLabel1.Text = "导数中…";
toolStripStatusLabel1.ForeColor = Color.Red;
Task t = TaskExport("Sheet1", sqlText.Text.ToString(), filename);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void button3_Click(object sender, EventArgs e)
{
if (textBox2.Text.ToString() == "")
{
MessageBox.Show("请选择需要导入的文件夹！");
}
DataTable[] ds = UiServices.GetDataTableFromCSV(this.textBox2.Text.ToString(), true);
string filename = UiServices.ShowFileDialog("Book1");
int time = UiServices.ExportExcel(ds, filename);
GC.Collect();
toolStripStatusLabel1.Text = string.Format("执行操作时间为:{0}秒", time);
toolStripStatusLabel1.ForeColor = Color.Red;
}
//导出EXCEL模板文件
private void btnTP_Click(object sender, EventArgs e)
{
if (comboBox1.Text.ToString() == "")
{
MessageBox.Show("请选择需要导出模板的表名！");
}
else
{
string TableName = comboBox1.Text.ToString();
string filename = UiServices.ShowFileDialog(TableName);
int time = UiServices.ExportTemplate(TableName, filename);
toolStripStatusLabel1.Text = string.Format("导出的时间为:{0}秒", time);
toolStripStatusLabel1.ForeColor = Color.Red;
MessageBox.Show("导出成功！");
}
}
//导出数据
private void btnDtout_Click(object sender, EventArgs e)
{
if (listBox1.Items.Count < 1)
{
MessageBox.Show("请选择需要导入的表名！");
}
else
{
IList <string> SheetNames = new List <string>();
foreach (var item in listBox1.Items)
{
SheetNames.Add(item.ToString());
}
string filename = UiServices.ShowFileDialog(SheetNames[0]);
toolStripStatusLabel1.Text = "导数中…";
toolStripStatusLabel1.ForeColor = Color.Red;
if (filename != null)
{
Task t = TaskExport(SheetNames, filename);
}
}
}
