OleDbConnection con2 = new OleDbConnection("Provider=SQLOLEDB.1.Persist Security Info=False; integrated security=sspi;Initial Catalog=JK_DATA;Data Source=WWW-12E7BEEA209");
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=D:\\配件格式(车).xls;Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'");//Oledb 连接字符串
con2.Open();
con.Open();
OleDbCommand com = new OleDbCommand("select Code,名称,规格型号,计量单位,数量,含税总价 from [Sheet1$] where Code<>'#N/A'", con);
OleDbDataReader der2 = com.ExecuteReader(CommandBehavior.CloseConnection);
while (der2.Read())
{
OleDbCommand com_2 = new OleDbCommand("select count(*) from [Sheet1$] where Code='" + der2["Code"] + "'", con);
OleDbDataReader O_der = com_2.ExecuteReader(CommandBehavior.CloseConnection);
O_der.Read();
int Count = O_der.GetInt32(0);
if (Count > 8 || Count == 8)
{
//MessageBox.Show(Count.ToString(),"1");
OleDbCommand com4 = new OleDbCommand("insert SaleD(SaleCode,ItemNo,GoodsName,GoodsSpecs,Unit,Qty,TaxRate,TaxAddPrice,Amt,TaxAmt,RowKind,Price,Taxkind) values('" + der2["Code"] + "','" + i + "','" + der2["名称"] + "','" + der2["规格型号"] + "','" + der2["计量单位"] + "','" + der2["数量"] + "',0.06,'" + 0.06 + "','" + 0.06 + "','" + 0.06 + "',0,'" + 0.06 + "','" + 0.06 + "')", con2);
com4.ExecuteNonQuery();
i++; }
else
{
//MessageBox.Show(Count.ToString(), "2");
OleDbCommand com4 = new OleDbCommand("insert SaleD(SaleCode,ItemNo,GoodsName,GoodsSpecs,Unit,Qty,TaxRate,TaxAddPrice,Amt,TaxAmt,RowKind,Price,Taxkind) values('" + der2["Code"] + "','" + i + "','" + der2["名称"] + "','" + der2["规格型号"] + "','" + der2["计量单位"] + "','" + der2["数量"] + "',0.06,'" + 0.06 + "','" + 0.06 + "','" + 0.06 + "',0,'" + 0.06 + "','" + 0.06 + "')", con2);
com4.ExecuteNonQuery();
i++;
}
}
MessageBox.Show("GOOD ok");
con.Close();
con2.Close();
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=D:\\配件格式(车).xls;Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'");//Oledb 连接字符串
con2.Open();
con.Open();
OleDbCommand com = new OleDbCommand("select Code,名称,规格型号,计量单位,数量,含税总价 from [Sheet1$] where Code<>'#N/A'", con);
OleDbDataReader der2 = com.ExecuteReader(CommandBehavior.CloseConnection);
while (der2.Read())
{
OleDbCommand com_2 = new OleDbCommand("select count(*) from [Sheet1$] where Code='" + der2["Code"] + "'", con);
OleDbDataReader O_der = com_2.ExecuteReader(CommandBehavior.CloseConnection);
O_der.Read();
int Count = O_der.GetInt32(0);
if (Count > 8 || Count == 8)
{
//MessageBox.Show(Count.ToString(),"1");
OleDbCommand com4 = new OleDbCommand("insert SaleD(SaleCode,ItemNo,GoodsName,GoodsSpecs,Unit,Qty,TaxRate,TaxAddPrice,Amt,TaxAmt,RowKind,Price,Taxkind) values('" + der2["Code"] + "','" + i + "','" + der2["名称"] + "','" + der2["规格型号"] + "','" + der2["计量单位"] + "','" + der2["数量"] + "',0.06,'" + 0.06 + "','" + 0.06 + "','" + 0.06 + "',0,'" + 0.06 + "','" + 0.06 + "')", con2);
com4.ExecuteNonQuery();
i++; }
else
{
//MessageBox.Show(Count.ToString(), "2");
OleDbCommand com4 = new OleDbCommand("insert SaleD(SaleCode,ItemNo,GoodsName,GoodsSpecs,Unit,Qty,TaxRate,TaxAddPrice,Amt,TaxAmt,RowKind,Price,Taxkind) values('" + der2["Code"] + "','" + i + "','" + der2["名称"] + "','" + der2["规格型号"] + "','" + der2["计量单位"] + "','" + der2["数量"] + "',0.06,'" + 0.06 + "','" + 0.06 + "','" + 0.06 + "',0,'" + 0.06 + "','" + 0.06 + "')", con2);
com4.ExecuteNonQuery();
i++;
}
}
MessageBox.Show("GOOD ok");
con.Close();
con2.Close();
//using System .Data .OleDb ;
public partial class Form1 : Form
{
}
class sqlconnect
{
private void opensql ()
{
OleDbConnection con2 = new OleDbConnection("Provider=SQLOLEDB.1.Persist Security Info=False; integrated security=sspi;Initial Catalog=JK_DATA;Data Source=WWW-12E7BEEA209");
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=D:\\配件格式(车).xls;Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'");//Oledb 连接字符串
con2.Open();
con.Open();
OleDbCommand com = new OleDbCommand("select Code,名称,规格型号,计量单位,数量,含税总价 from [Sheet1$] where Code <>'#N/A'", con);
OleDbDataReader der2 = com.ExecuteReader(CommandBehavior.CloseConnection);
while (der2.Read())
{
OleDbCommand com_2 = new OleDbCommand("select count(*) from [Sheet1$] where Code='" + der2["Code"] + "'", con);
OleDbDataReader O_der = com_2.ExecuteReader(CommandBehavior.CloseConnection);
O_der.Read();
int Count = O_der.GetInt32(0);
if (Count > 8 || Count == 8)
{
//MessageBox.Show(Count.ToString(),"1");
OleDbCommand com4 = new OleDbCommand("insert SaleD(SaleCode,ItemNo,GoodsName,GoodsSpecs,Unit,Qty,TaxRate,TaxAddPrice,Amt,TaxAmt,RowKind,Price,Taxkind) values('" + der2["Code"] + "','" + i + "','" + der2["名称"] + "','" + der2["规格型号"] + "','" + der2["计量单位"] + "','" + der2["数量"] + "',0.06,'" + 0.06 + "','" + 0.06 + "','" + 0.06 + "',0,'" + 0.06 + "','" + 0.06 + "')", con2);
com4.ExecuteNonQuery();
i++; }
else
{
//MessageBox.Show(Count.ToString(), "2");
OleDbCommand com4 = new OleDbCommand("insert SaleD(SaleCode,ItemNo,GoodsName,GoodsSpecs,Unit,Qty,TaxRate,TaxAddPrice,Amt,TaxAmt,RowKind,Price,Taxkind) values('" + der2["Code"] + "','" + i + "','" + der2["名称"] + "','" + der2["规格型号"] + "','" + der2["计量单位"] + "','" + der2["数量"] + "',0.06,'" + 0.06 + "','" + 0.06 + "','" + 0.06 + "',0,'" + 0.06 + "','" + 0.06 + "')", con2);
com4.ExecuteNonQuery();
i++;
}
}
MessageBox.Show("GOOD ok");
con.Close();
con2.Close();
} }