private void Form2_Load(object sender, EventArgs e)
{
string sql = "select distinct cycle from db2admin.view_quantities where year>'2019年' order by cycle desc";
ExcelTodb2 dt = new ExcelTodb2();
string [][] item2 = dt.DataTableToArray(sql);
comboBox1.DataSource = dt.ArrayToItem(item2);
}
/* public string[] getxiaxia(string[][] st1)
* {
*
* Datatabletoarr sp = new Datatabletoarr();
* string[] st2 = new string[st1.Length ];
* st2=sp.Toarr1(st1);
* if (st2.Length == 0 || st2 == null)
* {
* return null;
* }
* else
* {
* return st2;
* }
* }
* /* public string[][] Getdd(string sql)
* {
* DataTable dl = new DataTable();
* Getdata gt = new Getdata();
* dl = gt.Getdat_db2(sql);
* string[][] st = null;
* Datatabletoarr st1 = new Datatabletoarr();
* st = st1.Toarry(dl);
* return st;
*
*
* }*/
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
string sql = "select distinct productdesc,productcode from db2admin.view_quantities where cycle='" + comboBox1.Text + "' order by productcode";
ExcelTodb2 dt = new ExcelTodb2();
DataTable tb = new DataTable();
Item1 = dt.DataTableToArray(sql);
Item = dt.ArrayToItem(Item1);
comboBox2.DataSource = Item;
}
private void button1_Click(object sender, EventArgs e)
{
//向父窗体传递新增周期参数
weituo2(pam);
// _ = new DataSet();
//ds = ExcelTodb2.ReadExcel(label2.Text);
//查询是否已经导入过文件周期的数据
ExcelTodb2 tt = new ExcelTodb2();
string sql = string.Format("select distinct cyclname,cyclcode from db2admin.sales_cycle where cyclcode='{0}'", label9.Text);
// DataSet ds = tt.UpToDb2(sql);
string[] st = tt.ArrayToItem(tt.DataTableToArray(sql));
if (st == null)
{
MessageBox.Show("数据库查询错误，请联系管理员");
}
else if (st.Length > 0)
{
MessageBox.Show("数据库已有相关记录");
}
else
{
foreach (string tex in path)
{
tt.UpToDb2(tex);
}
}
//MessageBox.Show(ds.Tables.Count.ToString ());
//dataGridView1.DataSource =ds.Tables ["pam"];
// dataGridView1 .
// DataRow [] dr = ds.Tables[0].Select("F5 like '%标准%'");
this.Dispose();
}
