using System;
using ;
using ;
using ;
using ;
using ;
namespace yjgl
{
/// <summary>
/// Data Access Basic Class (SQL)
/// </summary>
class BaseOperate
{
#region Establish a database connection
/// <summary>
/// Establish a database connection.
/// </summary>
/// <returns>Returns SqlConnection object</returns>
public SqlConnection getcon()
{
string M_str_sqlcon = "Data Source=PC-200201010009 ;Database=db_yjzl;User ID=sa;PWD=123";//Connection string
SqlConnection mycon = new SqlConnection(M_str_sqlcon); //Create a connection object
return mycon;
}
#endregion
#region Execute the SqlCommand command
/// <summary>
/// Execute SqlCommand
/// </summary>
/// <param name="M_str_sqlstr">SQL statement</param>
public void getcom(string M_str_sqlstr)
{
SqlConnection sqlcon = (); //Get the connection string
(); //Open the connection
try
{
SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon); //Create command objects through SQL statements and connection objects
(); (); //Execute SQL statements on sqlcon and return the number of affected rows
(); �
}
catch (SqlException e)
{
((), "Information prompt", , );
}
finally
{
();
();
}
}
#endregion
#region Create DataSet object
/// <summary>
/// Create a DataSet object
/// </summary>
/// <param name="M_str_sqlstr">SQL statement</param>
/// <param name="M_str_table">table name</param>
/// <returns>Returns DataSet object</returns>
public DataSet getds(string M_str_sqlstr, string M_str_table) //Query
{
SqlConnection sqlcon = ();
SqlDataAdapter sqlda = new SqlDataAdapter(M_str_sqlstr, sqlcon);
DataSet myds = new DataSet();
(myds, M_str_table);
return myds;
}
#endregion
#region Create SqlDataReader object
/// <summary>
/// Create a SqlDataReader object
/// </summary>
/// <param name="M_str_sqlstr">SQL statement</param>
/// <returns>Returns SqlDataReader object</returns>
public SqlDataReader getread(string M_str_sqlstr)
{
SqlConnection sqlcon = ();
SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon);
();
SqlDataReader sqlread = ();
return sqlread;
}
#endregion
}
}
using ;
using ;
using ;
using ;
using ;
namespace yjgl
{
/// <summary>
/// Data Access Basic Class (SQL)
/// </summary>
class BaseOperate
{
#region Establish a database connection
/// <summary>
/// Establish a database connection.
/// </summary>
/// <returns>Returns SqlConnection object</returns>
public SqlConnection getcon()
{
string M_str_sqlcon = "Data Source=PC-200201010009 ;Database=db_yjzl;User ID=sa;PWD=123";//Connection string
SqlConnection mycon = new SqlConnection(M_str_sqlcon); //Create a connection object
return mycon;
}
#endregion
#region Execute the SqlCommand command
/// <summary>
/// Execute SqlCommand
/// </summary>
/// <param name="M_str_sqlstr">SQL statement</param>
public void getcom(string M_str_sqlstr)
{
SqlConnection sqlcon = (); //Get the connection string
(); //Open the connection
try
{
SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon); //Create command objects through SQL statements and connection objects
(); (); //Execute SQL statements on sqlcon and return the number of affected rows
(); �
}
catch (SqlException e)
{
((), "Information prompt", , );
}
finally
{
();
();
}
}
#endregion
#region Create DataSet object
/// <summary>
/// Create a DataSet object
/// </summary>
/// <param name="M_str_sqlstr">SQL statement</param>
/// <param name="M_str_table">table name</param>
/// <returns>Returns DataSet object</returns>
public DataSet getds(string M_str_sqlstr, string M_str_table) //Query
{
SqlConnection sqlcon = ();
SqlDataAdapter sqlda = new SqlDataAdapter(M_str_sqlstr, sqlcon);
DataSet myds = new DataSet();
(myds, M_str_table);
return myds;
}
#endregion
#region Create SqlDataReader object
/// <summary>
/// Create a SqlDataReader object
/// </summary>
/// <param name="M_str_sqlstr">SQL statement</param>
/// <returns>Returns SqlDataReader object</returns>
public SqlDataReader getread(string M_str_sqlstr)
{
SqlConnection sqlcon = ();
SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon);
();
SqlDataReader sqlread = ();
return sqlread;
}
#endregion
}
}