- Address),
- new SqlParameter("@TelNum", customer.TelNum),
- new SqlParameter("@CustLevel", customer.CustLevel));
- }
- /// <summary>
- /// 查询所有数据
- /// </summary>
- /// <returns></returns>
- public Customer[] GetAll()
- {
- DataTable table = SqlHelper.ExecuteDataTable("select * from T_Customer");
- Customer[] customers = new Customer[table.Rows.Count];
- for (int i = 0; i < table.Rows.Count; i++)
- {
- DataRow row = table.Rows[i];
- customers[i] = ToCustomer(row);
- }
- return customers;
- }
- }
- }
/DAL/SqlHelper.cs
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Configuration;
- using System.Data.SqlClient;
- using System.Data;
- namespace ADOTest5.DAL
- {
- static class SqlHelper
- {
- public static readonly string connstr = ConfigurationManager.ConnectionStrings["myconnstr"].ConnectionString;
- public static int ExecuteNonQuery(string sql,
- params SqlParameter[] parameters)
- {
- using (SqlConnection conn = new SqlConnection(connstr))
- {
- conn.Open();
- using (SqlCommand cmd = conn.CreateCommand())
- {
- cmd.CommandText = sql;
- cmd.Parameters.AddRange(parameters);
- return cmd.ExecuteNonQuery();
- }
- }
- }
- public static object ExecuteScalar(string sql,
- params SqlParameter[] parameters)
- {
- using (SqlConnection conn = new SqlConnection(connstr))
- {
- conn.Open();
- using (SqlCommand cmd = conn.CreateCommand())
- {
- cmd.CommandText = sql;
- cmd.Parameters.AddRange(parameters);
- return cmd.ExecuteScalar();
- }
- }
- }
- public static DataTable ExecuteDataTable(string sql,
- params SqlParameter[] parameters)
- {
- using (SqlConnection conn = new SqlConnection(connstr))
- {
- conn.Open();
- using (SqlCommand cmd = conn.CreateCommand())
- {
- cmd.CommandText = sql;
- cmd.Parameters.AddRange(parameters);
- DataSet ds = new DataSet();
- SqlDataAdapter adapter = new SqlDataAdapter(cmd);
- adapter.Fill(ds);
- return ds.Tables[0];
- }
- }
- }
- public static object FromDbValue(object value)
- {
- if (value == DBNull.Value)
- {
- return null;
- }
- else
- {
- return value;
- }
- }
- public static object ToDbValue(object value)
- {
- if (value == null)
- {
- return DBNull.Value;
- }
- else
- {
- return value;
- }
- }
- }
- }
版权声明:本文为博主原创文章,未经博主允许不得转载。