Ado.net 类扩展属性

1、要扩展的类名字一样，2个类加（partial）

小例子：

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

/// <summary>
/// Stores 扩展属性（扩展一个Stores类）
/// </summary>
public partial class Stores
{
    private SqlConnection _conn;
    private SqlCommand _cmd;
    private SqlDataReader _dr;

    public Stores()
    {
        _conn = DBconnection.conn;
        _cmd = _conn.CreateCommand();
    }

    public int Login_Id
    {
        get
        {
            _cmd.CommandText = "select * from Ims_Dish_Login where Login_Username=@Login_Username";//去另一个表中查询ID
            _cmd.Parameters.AddWithValue("@Login_Username", this.Login_Username);
            _conn.Open();
            _dr = _cmd.ExecuteReader();
            int a = 0;
            while (_dr.Read())
            {
                a = Convert.ToInt32(_dr["Login_Id"]);
            }
            _conn.Close();
            return a;
        }
    }

}

 

转载于:https://www.cnblogs.com/franky2015/p/5104565.html