C# SQLServer增删改查工具类

//引入SQLServer数据库DLL文件
//创建工具类Common
internal class Common
{

 //数据库连接
 public static string connstr57 = "Data Source=数据库ip;Initial Catalog=连接的库名;Persist Security Info=True;User ID=账号;Password=密码";
 
 /// 新增数据
 public static int insertExecuteNonQusery1(string sqlstr, params SqlParameter[] para)
 {
     using (SqlConnection conn = new SqlConnection(connstr57))
     {
         conn.Open();
         using (SqlCommand cmd = new SqlCommand(sqlstr, conn))
         {
             try
             {
                 if (para != null)
                 {
                     foreach (SqlParameter p in para)
                     {
                         cmd.Parameters.AddWithValue(p.ParameterName, p.Value);
                     }
                 }
                 return cmd.ExecuteNonQuery();
             }
             catch (Exception ee)
             {
                 Common.RecordError("数据库连接异常" + ee.ToString());
                 throw;
             }
         }
     }
 }
 /// <summary>
 /// 修改数据
 /// </summary>
 /// <param name="sqlstr"></param>
 /// <param name="para"></param>
 /// <returns></returns>
 public static DataSet updateExecuteNonQusery1(string sqlstr, params SqlParameter[] para)
 {
     using (SqlConnection conn = new SqlConnection(connstr57))
     {
         // conn.Open();
         using (SqlCommand cmd = new SqlCommand(sqlstr, conn))
         {
             try
             {
                 if (para != null)
                 {
                     foreach (SqlParameter p in para)
                     {
                         cmd.Parameters.AddWithValue(p.ParameterName, p.Value);
                     }
                 }
                 DataSet ds = new DataSet();
                 SqlDataAdapter da = new SqlDataAdapter(cmd);
                 da.Fill(ds);
                 return ds;
             }
             catch (Exception ee)
             {
                 Common.RecordError("数据库连接异常" + ee.ToString());
                 throw;
             }
         }
     }
 }
 /// <summary>
 /// 删除数据
 /// </summary>
 /// <param name="sqlstr"></param>
 /// <param name="para"></param>
 /// <returns></returns>
 public static DataSet DeleteExecuteNonQusery1(string sqlstr, params SqlParameter[] para)
 {
     using (SqlConnection conn = new SqlConnection(connstr57))
     {
         // conn.Open();
         using (SqlCommand cmd = new SqlCommand(sqlstr, conn))
         {
             try
             {
                 if (para != null)
                 {
                     foreach (SqlParameter p in para)
                     {
                         cmd.Parameters.AddWithValue(p.ParameterName, p.Value);
                     }
                 }
                 DataSet ds = new DataSet();
                 SqlDataAdapter da = new SqlDataAdapter(cmd);
                 da.Fill(ds);
                 return ds;
             }
             catch (Exception ee)
             {
                 Common.RecordError("数据库连接异常" + ee.ToString());
                 throw;
             }
         }
     }
 }
 /// <summary>
 /// 查询数据
 /// </summary>
 /// <param name="sqlstr"></param>
 /// <param name="para"></param>
 /// <returns></returns>
 public static DataSet selcetExecuteNonQusery1(string sqlstr, params SqlParameter[] para)
 {
     using (SqlConnection conn = new SqlConnection(connstr57))
     {
         // conn.Open();
         using (SqlCommand cmd = new SqlCommand(sqlstr, conn))
         {
             try
             {
                 if (para != null)
                 {
                     foreach (SqlParameter p in para)
                     {
                         cmd.Parameters.AddWithValue(p.ParameterName, p.Value);
                     }
                 }
                 DataSet ds = new DataSet();
                 SqlDataAdapter da = new SqlDataAdapter(cmd);
                 da.Fill(ds);
                 return ds;
             }
             catch (Exception ee)
             {
                 Common.RecordError("数据库连接异常" + ee.ToString());
                 throw;
             }
         }
     }
 }
 /// <summary>
 /// 查询返回datatable数据
 /// </summary>
 /// <param name="str"></param>
 /// <returns></returns>
 public static DataTable selcetdtExecuteNonQusery1(string str)
 {
     SqlConnection con = new SqlConnection(connstr57);
     DataTable dt = new DataTable();
     //string str = "select * from sys_Menu where menu_id_parent = '" + pid + "'";
     string str = "select * from shaotest where pid = '" + pid + "'";
     try
     {
         if (con.State == ConnectionState.Open)
         {
             con.Close();
         }
         con.Open();
         SqlDataAdapter da = new SqlDataAdapter(str, con);
         da.Fill(dt);
     }
     catch (Exception ee)
     {
         Common.RecordError(ee.ToString());
     }
     return dt;
 }




 //记录错误的日志
 public static void RecordError(string Msg)
 {
     lock ("")
     {
         string fileName = System.DateTime.Now.ToLongDateString() + "ERROR.LOG";
         if (Directory.Exists(Application.StartupPath + "\\LOG") == false)
         {
             Directory.CreateDirectory(Application.StartupPath + "\\LOG");
         }
         StreamWriter file = new StreamWriter(Application.StartupPath + "\\LOG\\" + fileName, true);
         if (Msg != "发送指令遠端主機已強制關閉一個現存的連線。")
         {
             file.WriteLine(System.DateTime.Now.ToString("HH:mm:ss") + "   " + Msg);
         }
         file.Close();
     }
 }

 //记录日志
 public static void RecordData(string Msg)//010300000002C40B
 {
     string fileName = System.DateTime.Now.ToLongDateString() + "DATA.LOG";
     if (Directory.Exists(Application.StartupPath + "\\LOG") == false)
     {
         Directory.CreateDirectory(Application.StartupPath + "\\LOG");
     }
     StreamWriter file = new StreamWriter(Application.StartupPath + "\\LOG\\" + fileName, true);
     file.WriteLine(System.DateTime.Now.ToString("HH:mm:ss") + "   " + Msg);
     file.Close();
 }

}