The confusion is not intended, mainly to achieve a thinking: use system; use system.data; using system.data.sqlclient;
Namespace Gyqm.common {/// /// Provide data access component /// public class clsconnectForcs {
#region custom private fields private string sConnString; // private SQL Server connection string of SqlConnection cConnection = null; // SQL Server connector private int trans = 0; // record the number of transaction private static ClsConnectForCS cConnectDAL = null; // Private variable, used to return to the instance of the class #ENDREGION
#REGON MODEL 模式 模式 /// /// When constructor is privat, the outside cannot instantiate the type /// private clsconnectForcs () {}
/// /// This type of real instantiation function, used to return to this class /// /// ConnectDal Public Static ClsconnectForcs Instance () {ix (cconnectdal == null) cconnectdal = new clsConnectForcs (); return cconnectdal;} #ENDREGION
#Region overrides function /// // / Overwrite the default default function, enabling it to return to string /// /// database connection string public override string toString () {return sconnstring;} #ENDREGION
#Region Public Methods for Uses To Act in Certain Function
/// /// Open the connection //////////////////////////////////////////bit of success, otherwise return public bool openDatabase () {Try {Sconnstring = Agriculture. Clscommon.ReadAppSettings ("SqlConnection.connectionstring"); if (cconnection == null) cconnection = new sqlConnection (sconnstring);
IF (cconnection.state! = connectionState.open) cconnection.open (); return true;} catch {return false;}}
/// /// Close Database /// /// Returns True Public Bool CloseDatabase () {TRY {IF (TRANS! = 0) Return TRUE; IF (cconnection.state! = connectionState.closed) cconnection.close (); return true;} catch {returnaf
/// // / execute SQL statement, return to DataTable /// /// SQL statement //// data sheet to be executed public DataTable ExecuteDataTable (string sql) {DataTable dt = new DataTable (); SqlDataAdapter sAdapter = new SqlDataAdapter (sql, cConnection); sAdapter.Fill (dt); return dt;} public DataTable ExecuteDataTable (SqlCommand cmd) { DataTable DT = New DataTable (); cmd.connection = this.cconnection; sqldataadapter sadapter = new sqldataadapter (cmd); SADAPTER.FILL (DT); return Dt;} /// // execute SQL statement, return DataSet /// /// SQL statement to execute /// Dataset Public Dataset ExecuteDataSet (String SQL) {DataSet DS = New DataSet (); SqlDataAdapter Sadapter = New SqlDataAdapter (SQL, CConnection); Sadapter.Fill (DS); Return DS;}
/// /// execute the sqlstring statement, no need to return anything from the database /// /// /// if successful returns true, otherwise returns false public void ExecuteNonQuery (string SqlString) {SqlCommand cCmd = new SqlCommand (); cCmd.Connection = cConnection; cCmd.CommandText = SqlString; cCmd.ExecuteNonQuery ();} public void ExecuteNonQuery (SqlCommand CMD) {cmd.connection = cconnection; cmd.executenonQuery ();} /// /// Return scalar value, the last person can perform type conversion /// ////// Passing SQL statement /// successful or failed public object executescalar (string sql) {sqlcommand ccmd = new sqlcommand (); ccmd.connection = CConnection; ccmd.commandtext = SQL; return ccmd.executescalar ();} /// /// Execute Command /// Code: Wang Kai /// /// /// Object public object executescalar (system.data.sqlclient.sqlcommand cmd) {Cmd.connection = cconnection; return cmd.executescalar ();} /// /// Execute Command object /// /// passed from the upper layer Command Object /// If successful returns true, returning to false public void run (sqlcommand mycommand) {MyCommand.connection = cconnection; myCommand.executenonQuery ();
/// /// Execute Command Statement /// /// The command object passed from the upper layer /// Fill the table object passed from the upper layer /// If successful returns true, return to the false public bool run (SQLCommand MyCommand, DataTable DT) {Try {MyCommand.connection = CConnection ; SqlDataAdapter sDataAdapter = new SqlDataAdapter (); sDataAdapter.SelectCommand = myCommand; sDataAdapter.Fill (dt); return true;} catch {return false;}} public DataSet Run (string sqlStr) {DataSet ds = new DataSet (); SqlCommand Mycommand = new sqlcommand (sqlstr, cconnection); sqldataadapter sdataadapter = new sqldataadapter (); sdataadapter.selectCommand = mycommand; sdataadapter.fill (DS); return DS;}
/// /// /// / // successful return data sets public bool Run (string sql, DataTable myDataTable) {SqlDataAdapter sAdapter = null; try {sAdapter = new SqlDataAdapter (sql, cConnection); sAdapter.Fill (myDataTable); return true ;} Finally {mydataable = null; sadapter.dispose (); sadapter = null;}} /// /// transaction start /// public void begintransaction () {Trans = 1; sqlcommand scmd = null; scmd = new sqlcommand ("Begin Transaction", cconnection; scmd.executenonQuery (); scmd.dispose (); scmd = null;} /// /// transaction submission / // public void committransaction () {trans- = 1; sqlcommand scmd = null; scmd = new sqlcommand ("commit transaction", cconnection; scmd.executenonquery (); scmd.dispose (); scmd = null }
/// /// Transaction rollback /// public void rollbackTransaction () {TRANS- = 1; sqlcommand scmd = null; scmd = new sqlcommand ("rollback transaction", cconnection; scmd. EXECUTENONQUERY (); scmd.dispose (); scmd = null;
/// /// Explicitly release memory /// public void dispose () {if (cconnection! = null) cconnection = null;}
#ndregion}}}
