using
System;
using System.Data ;
using System.Data.SqlClient ;
using System.Data.SqlTypes ;
using System.Windows.Forms ;
using System.Collections;
namespace Database
... {
/**//// <summary>
/// Database 的摘要说明。
/// </summary>
public class Database
...{
/**//// <summary>
/// 属性
/// </summary>
// public DataSet dataSet
// {
// get
// {
// return m_DataSet;
// }
// }
public Database()
...{
//
// TODO: 在此处添加构造函数逻辑
//
XmlRead ConStr=new XmlRead();
if (ConStr.ReadAllConnectNode())
...{
constr= ConStr.connstring ;
// try
// {
// Open();
// }
// catch(Exception Ex)
// {
// MessageBox.Show("数据库连接错误"+Ex.ToString () );
// }
}
else
...{
constr="-1";
//throw new SqlErrorCollection();
}
}
// public bool Open()
// {
// mcn.ConnectionString = constr;
// try
// {
// mcn.Open();
// }
// catch( Exception)
// {
// return false;
// }
// return true;
// }
/**//// <summary>
/// 默认获取DataSet
/// </summary>
/// <param name="pMyTableName"></param>
/// <param name="tmpMyComputerName"></param>
/// <returns></returns>
// public virtual int getData (string pMyTableName ,string tmpMyComputerName)
// {
// return -1;
// }
ExecuteNonQuery#region ExecuteNonQuery
/**//// <summary>
/// 执行一个SQL Command(使用ConnectString)
/// </summary>
/// <param name="connString">ConnectString(Sql连接字符串)</param>
/// <param name="cmdType">Command类型</param>
/// <param name="cmdText">Command的语句(SQL语句)</param>
/// <param name="cmdParms">Command的参数(SqlParameter[]数组类型)</param>
/// <returns>Command的返回值(受影响的行数)</returns>
public int ExecuteNonQuery(string connString, CommandType cmdType, string cmdText, params SqlParameter[] cmdParms)
...{
SqlCommand cmd = new SqlCommand();
using (SqlConnection conn = new SqlConnection(connString))
...{
PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms);
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return val;
}
}
/**//// <summary>
/// 执行一个SQL Command(使用隐含的ConnectString)
/// </summary>
/// <param name="cmdType">Command类型</param>
/// <param name="cmdText">Command的语句(SQL语句)</param>
/// <param name="cmdParms">Command的参数(SqlParameter[]数组类型)</param>
/// <returns>Command的返回值(受影响的行数)</returns>
public int ExecuteNonQuery(CommandType cmdType,
using System.Data ;
using System.Data.SqlClient ;
using System.Data.SqlTypes ;
using System.Windows.Forms ;
using System.Collections;
namespace Database
... {
/**//// <summary>
/// Database 的摘要说明。
/// </summary>
public class Database
...{
/**//// <summary>
/// 属性
/// </summary>
// public DataSet dataSet
// {
// get
// {
// return m_DataSet;
// }
// }
public Database()
...{
//
// TODO: 在此处添加构造函数逻辑
//
XmlRead ConStr=new XmlRead();
if (ConStr.ReadAllConnectNode())
...{
constr= ConStr.connstring ;
// try
// {
// Open();
// }
// catch(Exception Ex)
// {
// MessageBox.Show("数据库连接错误"+Ex.ToString () );
// }
}
else
...{
constr="-1";
//throw new SqlErrorCollection();
}
}
// public bool Open()
// {
// mcn.ConnectionString = constr;
// try
// {
// mcn.Open();
// }
// catch( Exception)
// {
// return false;
// }
// return true;
// }
/**//// <summary>
/// 默认获取DataSet
/// </summary>
/// <param name="pMyTableName"></param>
/// <param name="tmpMyComputerName"></param>
/// <returns></returns>
// public virtual int getData (string pMyTableName ,string tmpMyComputerName)
// {
// return -1;
// }
ExecuteNonQuery#region ExecuteNonQuery
/**//// <summary>
/// 执行一个SQL Command(使用ConnectString)
/// </summary>
/// <param name="connString">ConnectString(Sql连接字符串)</param>
/// <param name="cmdType">Command类型</param>
/// <param name="cmdText">Command的语句(SQL语句)</param>
/// <param name="cmdParms">Command的参数(SqlParameter[]数组类型)</param>
/// <returns>Command的返回值(受影响的行数)</returns>
public int ExecuteNonQuery(string connString, CommandType cmdType, string cmdText, params SqlParameter[] cmdParms)
...{
SqlCommand cmd = new SqlCommand();
using (SqlConnection conn = new SqlConnection(connString))
...{
PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms);
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return val;
}
}
/**//// <summary>
/// 执行一个SQL Command(使用隐含的ConnectString)
/// </summary>
/// <param name="cmdType">Command类型</param>
/// <param name="cmdText">Command的语句(SQL语句)</param>
/// <param name="cmdParms">Command的参数(SqlParameter[]数组类型)</param>
/// <returns>Command的返回值(受影响的行数)</returns>
public int ExecuteNonQuery(CommandType cmdType,