目录
新建BaseLibrary文件夹,在文件夹中添加DataAccess、Kernel、Utilities控制台应用。
1、DataAccess
右键-添加-新建项目
新建文件夹DataBase.SqlServer,添加类SqlServerHelper,类中方法主要实现数据库连接、SQL指令操作等。
引用中添加Configuration主要是从web.config文件中读取数据库配置信息。
namespace DataAccess.DataBase.SqlServer
{
public class SqlHelper
{
private static StreamWriter sw;
public static readonly string connString = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
/// <summary>
/// 执行操作数据库签的准备
/// </summary>
/// <param name="cmd"></param>zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
/// <param name="conn"></param>
/// <param name="trans"></param>
/// <param name="type"></param>
/// <param name="cmdText"></param>
/// <param name="param"></param>
public static void PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType type, string cmdText, SqlParameter[] param)
{
try
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
cmd.Connection = conn;
cmd.CommandText = cmdText;
}
}
catch (InvalidOperationException e) {
Console.Write(e.Message.ToString());
}
if (param != null)
{
foreach (SqlParameter paramter in param)
{
cmd.Parameters.Add(paramter);
}
}
}
/// <summary>
///
/// </summary>
/// <param name="connstring"></param>
/// <param name="type"></param>
/// <param name="cmdText"></param>
/// <param name="param"></param>
/// <returns></returns>
public static DataSet ExectuteDataset(string connstring,CommandType type,string cmdText,SqlParameter[]param)
{
SqlCommand cmd = new SqlCommand();
using (SqlConnection conn=new SqlConnection(connstring))
{
SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmd);
PrepareCommand(cmd,conn,null,type,cmdText,param);
try
{
//sqlAdapter.SelectCommand = cmd;
DataSet ds = new DataSet();
sqlAdapter.Fill(ds);
return ds;
}
catch
{
throw;
}
finally {
conn.Dispose();
}
}
}
/// <summary>
/// 从数据库中返回以表形式存储的数据
/// </summary>
/// <param name="connstring"></param>
/// <param name="type"></param>
/// <param name="cmdText"></param>
/// <param name="param"></param>
/// <returns></returns>
public static DataTabl