internal bool Insert(string table, List<String> field, List<String> value)
{
bool bRst = false;
Conn cn = new Conn();
string sql = "INSERT INTO " + table + "(";
if (field.Count > 0)
{
for (int i = 0; i < field.Count; i++)
{
if (i == field.Count - 1)
{
sql += field[i] + ")";
}
else
{
sql += field[i] + ",";
};
};
};
sql += " VALUES (";
if (value.Count > 0)
{
for (int i = 0; i < value.Count; i++)
{
if (i == value.Count - 1)
{
sql += "'" + value[i] + "')";
}
else
{
sql += "'" + value[i] + "',";
}
};
};
using (cn.Connection)
{
SqlCommand MyCommand = new SqlCommand(); //定义一个数据库操作指令
MyCommand.Connection = cn.Connection;
MyCommand.CommandText = sql;
cn.Connection.Open();
int iRst = MyCommand.ExecuteNonQuery();
cn.Connection.Close();
if (iRst > 0)
{
bRst = true;
}
else
{
bRst = false;
};
};
//myTran = sqlCon.BeginTransaction();
//try
//{
// SqlCommand MyCommand = new SqlCommand(); //定义一个数据库操作指令
// MyCommand.Connection = cn.Connection;
// MyCommand.CommandText = sql;
// if (!cn.isOpen)
// {
// cn.Connection.Open();
// cn.isOpen = true;
// }
// int iRst = MyCommand.ExecuteNonQuery();
// if (cn.isOpen)
// {
// cn.Connection.Close();
// cn.isOpen = false;
// }
// if (iRst > 0)
// {
// bRst = true;
// }
// else
// {
// bRst = false;
// }
//}
//catch (Exception e)
//{
// //bRst = false;
// using (System.IO.StreamWriter sw = new System.IO.StreamWriter(Service1.strPath+"logError.txt", true))
// {
// sw.WriteLine("DBconnGet在 "
// + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss ")
// + "Insert操作时发生错误，" + e.ToString());
// }
// //throw;
//}
//finally
//{
// if (cn.isOpen)
// {
// cn.Connection.Close();
// cn.isOpen = false;
// };
//}
return bRst;
}
internal DataTable getDataView(string sql)
{
DataSet dsRst = new DataSet();
DataTable dtRst = new DataTable();
Conn cn = new Conn();
using (cn.Connection)
{
SqlDataAdapter myDataAdapter = new SqlDataAdapter(sql, cn.Connection);
cn.Connection.Open();
myDataAdapter.Fill(dsRst);
cn.Connection.Close();
dtRst = dsRst.Tables[0];
};
//try
//{
// if (!cn.isOpen)
// {
// cn.Connection.Open();
// cn.isOpen = true;
// }
// SqlDataAdapter myDataAdapter = new SqlDataAdapter(sql, cn.Connection);
// if (cn.isOpen)
// {
// cn.Connection.Close();
// cn.isOpen = false;
// }
// myDataAdapter.Fill(dsRst);
// dtRst = dsRst.Tables[0];
//}
//catch (Exception e)
//{
// using (System.IO.StreamWriter sw = new System.IO.StreamWriter(Service1.strPath + "logError.txt", true))
// {
// sw.WriteLine("DBconnGet在 "
// + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss ")
// + "getDataView操作时发生错误，" + e.ToString());
// }
//}
//finally
//{
// if (cn.isOpen)
// {
// cn.Connection.Close();
// cn.isOpen = false;
// };
//}
return dtRst;
}
