Dao.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;

namespace ConsoleApplication1
{
    class Dao
    {
        private const string connstr = "Data Source=127.0.0.1;Initial Catalog=mydata;User ID=sa;Password=sa";

        public static bool login(string username, string password)
        {
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                using (SqlCommand cmd = new SqlCommand("select count(*) from t_user where username = @username, password = @password", conn))
                {
                    cmd.Parameters.AddWithValue("username", username);
                    cmd.Parameters.AddWithValue("password", password);
                    conn.Open();
                    object o = cmd.ExecuteScalar();
                    if (o.Equals("0"))
                    {
                        return false;
                    }
                    return true;
                }
            }
        }

        public static List<Dictionary<string ,string>> select_t_user(string sql, params SqlParameter[] msp)
        {
           
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                using (SqlCommand cmd = new SqlCommand(sql, conn))
                {
                    cmd.Parameters.AddRange(msp);
                    conn.Open();
                    using (SqlDataReader mdr = cmd.ExecuteReader())
                    {
                        List<Dictionary<string, string>> ldss = new List<Dictionary<string, string>>();
                        while (mdr.Read())
                        {
                            Dictionary<string, string> dss = new Dictionary<string, string>();
                            dss.Add("user_iden", mdr["user_iden"].ToString());
                            dss.Add("user_name", mdr["user_name"].ToString());
                            dss.Add("pass_word", mdr["pass_word"].ToString());
                            ldss.Add(dss);
                        }
                        return ldss;
                    }
                }
            }          
        }

        public static bool insertUpdateDelete(string sql, params SqlParameter[] msp)
        {
            using (SqlConnection conn = new SqlConnection(connstr))
            {
                using (SqlCommand cmd = new SqlCommand(sql, conn))
                {
                    cmd.Parameters.AddRange(msp);
                    conn.Open();
                    if (cmd.ExecuteNonQuery() >= 1)
                    {
                        return  true;
                    }
                    return false;
                }
            }
        }

        public static DataTable select(string sql, params SqlParameter[] sp)
        {
            using (SqlConnection conn =new SqlConnection (connstr))
            {
                using (SqlCommand cmd =new SqlCommand(sql,conn))
                {
                    cmd.Parameters.AddRange(sp);
                    using (SqlDataAdapter sda =new SqlDataAdapter(cmd))
                    {
                        using (DataTable dt =new DataTable())
                        {
                            sda.Fill(dt);
                            return dt;
                        }
                    }
                }
            }
        }
    }
}