DAL/DalMember.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MODEL;
using System.Data;
using System.Data.SqlClient;
namespace DAL
{
    public class DalMember
    {
        /// <summary>
        /// 增加
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static Boolean AddMember(ModelMember model)
        {
            int i = Dal.SqlHelpers.ExecuteNonQuery(CommandType.Text,"insert into mis_member(mno,mname,phone,dcs,creater,status,modify_date,is_recharge) values('"+model.MNO+"','"+model.MNAME+"','"+model.PHONE+"','"+model.DCS+"','"+model.CREATER+"','"+model.STATUS+"','"+model.MODIFY_DATE+"','"+model.IS_RECHARGE+"')");
            if (i > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static Boolean DeleteMember(ModelMember model)
        {
            int i = Dal.SqlHelpers.ExecuteNonQuery(CommandType.Text,"update mis_member set status=0 where mid='"+model.MID+"'");
            if (i > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static Boolean ModifyMember(ModelMember model)
        {
            int i = Dal.SqlHelpers.ExecuteNonQuery(CommandType.Text,"update mis_member set mno='"+model.MNO+"',mname='"+model.MNAME+"',phone='"+model.PHONE+"',dcs='"+model.DCS+"',modifier='"+model.MODIFIER+"',modify_date='"+model.MODIFY_DATE+"' where mid='"+model.MID+"'");
            if (i > 0)
            {
                return true;
            }
            else
            {
                return false;