memberbdal.cs

c#三层架构项目开发的全过程

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using Model;
namespace DAL.Members
{
    public class MemberbDal
    {
        #region 显示会员反馈信息
        public  List<Model.Members.Memberb> SelectMembers()
        {
            List<Model.Members.Memberb> li = new List<Model.Members.Memberb>();
            string cmdtextm0 = "FindMembersAll_select";
            DataSet ds = new DataSet();
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, cmdtextm0, ds, new string[] { "ki" }, null);
        
            foreach (DataRow item in ds.Tables[0].Rows)
             {
               Model.Members.Memberb md = new Model.Members.Memberb();
               md.Member_ID = item["Member_ID"].ToString();
               md.Member_level_ID = (int)item["Member_level_ID"];
               md.Member_name = item["Member_name"].ToString();
               md.Member_Sex = item["Member_Sex"].ToString();
               md.HYMember_Mobile = item["HYMember_Mobile"].ToString();
               md.HYMember_Birthday = item["HYMember_Birthday"].ToString();
               md.HYMember_Text = item["HYMember_Text"].ToString();
               li.Add(md);
            }
           return li;
        }
        #endregion

        #region 添加会员反馈信息
        public  int Getmembers(string member_id, int member_level_id, string member_name, string member_sex, string hymember_mobile, string hymember_birthday, string hymember_text)
         {
        string  cmdtextm1 = "FindMembers_insert";
        SqlParameter mid = new SqlParameter("@member_id", SqlDbType.VarChar, 10);
        mid.Value = member_id;
        SqlParameter mli = new SqlParameter("@member_level_id", SqlDbType.Int);
        mli.Value = member_level_id;
        SqlParameter ma = new SqlParameter("@member_name", SqlDbType.VarChar, 10);
        ma.Value = member_name;
        SqlParameter mx = new SqlParameter("@member_sex", SqlDbType.VarChar, 4);
        mx.Value = member_sex;
        SqlParameter mm = new SqlParameter("@hymember_mobile", SqlDbType.VarChar, 15);
        mm.Value = hymember_mobile;
        SqlParameter mb = new SqlParameter("@hymember_birthday", SqlDbType.VarChar,10);
        mb.Value = hymember_birthday;
        SqlParameter mt = new SqlParameter("@hymember_text", SqlDbType.Text);
        mt.Value = hymember_text;

        return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, cmdtextm1, new SqlParameter[] { mid, mli, ma, mx, mm, mb, mt });
            
       }
        #endregion

        #region 通过会员姓名查询
        public List<Model.Members.Memberb> SelectMembersByName(string member_name)
        {
            List<Model.Members.Memberb> li1 = new List<Model.Members.Memberb>();
            string commandtext = "FindMembersByName_select";
            DataSet ds = new DataSet();
            SqlParameter name = new SqlParameter("@Member_name", SqlDbType.VarChar, 10);
            name.Value = member_name;
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { "ue" }, name);

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Model.Members.Memberb md = new Model.Members.Memberb();
                md.Member_ID = item["Member_ID"].ToString();
                md.Member_level_ID = (int)item["Member_level_ID"];
                md.Member_name = item["Member_name"].ToString();
                md.Member_Sex = item["Member_Sex"].ToString();
                md.HYMember_Mobile = item["HYMember_Mobile"].ToString();
                md.HYMember_Birthday = item["HYMember_Birthday"].ToString();
                md.HYMember_Text = item["HYMember_Text"].ToString();
                li1.Add(md);
            }
            return li1;
        }
        #endregion
       
        #region 通过会员编号查询
        public List<Model.Members.Memberb> SelectMembersByID(string member_id)
        {
            List<Model.Members.Memberb> li2 = new List<Model.Members.Memberb>();
            string commandtext = "SelectMembersByID";
            DataSet ds = new DataSet();
            SqlParameter ID = new SqlParameter("@Member_ID", SqlDbType.VarChar, 10);
            ID.Value = member_id;
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { "id" }, ID);

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Model.Members.Memberb md = new Model.Members.Memberb();
                md.Member_ID = item["Member_ID"].ToString();
                md.Member_level_ID = (int)item["Member_level_ID"];
                md.Member_name = item["Member_name"].ToString();
                md.Member_Sex = item["Member_Sex"].ToString();
                md.HYMember_Mobile = item["HYMember_Mobile"].ToString();
                md.HYMember_Birthday = item["HYMember_Birthday"].ToString();
                md.HYMember_Text = item["HYMember_Text"].ToString();
                li2.Add(md);
            }
            return li2;
        }
        #endregion

        #region 修改会员反馈信息
        /// <summary>
        /// 会员反馈信息
        /// </summary>
        /// <param name="member_id">会员编号</param>
        /// <param name="member_level_id">会员等级</param>
        /// <param name="member_name">会员性别</param>
        /// <param name="member_sex">会员性别</param>
        /// <param name="hymember_mobile">会员号码</param>
        /// <param name="hymember_birthday">会员生日</param>
        /// <param name="hymember_text">会员反馈内容</param>
        /// <returns></returns>
        public int  MembersUpdate(string member_id ,int member_level_id, string member_name, string member_sex, string hymember_mobile, string hymember_birthday, string hymember_text)
        {
            string com = "FindMembers_updata";
            SqlParameter id = new SqlParameter("@Member_ID", SqlDbType.VarChar, 10);
            id.Value = member_id;
            SqlParameter lid = new SqlParameter("@Member_level_ID", SqlDbType.Int);
            lid.Value = member_level_id;
            SqlParameter name = new SqlParameter("@Member_name", SqlDbType.VarChar, 10);
            name.Value = member_name;
            SqlParameter sex = new SqlParameter("@Member_Sex", SqlDbType.VarChar, 4);
            sex.Value = member_sex;
            SqlParameter mobile = new SqlParameter("@HYMember_Mobile", SqlDbType.VarChar, 15);
            mobile.Value = hymember_mobile;
            SqlParameter birthday = new SqlParameter("@HYMember_Birthday", SqlDbType.VarChar, 10);
            birthday.Value = hymember_birthday;
            SqlParameter text = new SqlParameter("@HYMember_Text", SqlDbType.Text );
            text.Value = hymember_text;
            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, com, new SqlParameter[] { id, lid, name, sex, mobile, birthday, text });
        }
        #endregion

        #region 删除会员反馈信息
        public int MembersDelete(string member_id)
        {
            string com = "FindMembers_delete";
            SqlParameter id = new SqlParameter("@Member_ID", SqlDbType.VarChar, 10);
            id.Value = member_id;
           
            return SqlHelper.ExecuteNonQuery(SqlHelper.conStr, CommandType.StoredProcedure, com, new SqlParameter[] { id });
        }
        #endregion

        #region 会员编号查询
        public List<Model.Members.Memberb> SelectMembersID(string member_id)
        {
            List<Model.Members.Memberb> li2 = new List<Model.Members.Memberb>();
            string commandtext = "Member_Select";
            DataSet ds = new DataSet();
            SqlParameter id = new SqlParameter("@member_id", SqlDbType.VarChar, 18);
            id.Value = member_id;
            SqlHelper.FillDataSet(SqlHelper.conStr, CommandType.StoredProcedure, commandtext, ds, new string[] { }, new SqlParameter []{id});

            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Model.Members.Memberb md = new Model.Members.Memberb();
                md.Member_ID = item["Member_ID"].ToString();
                li2.Add(md);
            }
            return li2;
        }
        #endregion
    }
}