Model/Users_Model.cs

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

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

/*
 * 设计者：LHY 2013-02-26  
 * 建议请邮：869067911@qq.com
 * */

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
namespace Model
{
    public class Users_Model:Model.Base.ModelBase
    {
	    public Users_Model()
        {
            TableName = "Users";
            PKey = "UserID";
            PKeyDataType = typeof(System.Int32);
        }

        public override object PKeyValue
        {
            get
            {
                return M_UserID;
            }
            set
            {
                M_UserID = (System.Int32)value;
            }
        }

        public override string AddSQL
        { get
            {
                return @"INSERT INTO [Users]
           ( [LoginID],[UserPwd],[RealName],[DepartmentID],[Mobile],[Email],[QQ],[CreatTime],[ModifyTime],[Creator],[Editor],[LastLoginIP],[LastLoginTime],[IsEnabled],[IsLocked],[Remark],[ordernum]) VALUES (@LoginID,@UserPwd,@RealName,@DepartmentID,@Mobile,@Email,@QQ,@CreatTime,@ModifyTime,@Creator,@Editor,@LastLoginIP,@LastLoginTime,@IsEnabled,@IsLocked,@Remark,@ordernum);select @@identity ";}}

        public override string UpdateSQL
        { get
            {
                return @"UPDATE [Users]
            SET [LoginID]=@LoginID,[UserPwd]=@UserPwd,[RealName]=@RealName,[DepartmentID]=@DepartmentID,[Mobile]=@Mobile,[Email]=@Email,[QQ]=@QQ,[CreatTime]=@CreatTime,[ModifyTime]=@ModifyTime,[Creator]=@Creator,[Editor]=@Editor,[LastLoginIP]=@LastLoginIP,[LastLoginTime]=@LastLoginTime,[IsEnabled]=@IsEnabled,[IsLocked]=@IsLocked,[Remark]=@Remark,[ordernum]=@ordernum WHERE  [UserID]=@UserID";}}

        public override SqlParameter[] ParamsForAdd
        { get
            {
                 List<SqlParameter> list = GetNotKeyParams();return list.ToArray();}}

        public override SqlParameter[] ParamsForUpdate
        { get
            {
                 List<SqlParameter> list = GetNotKeyParams();
                list.Add(new SqlParameter("@UserID", M_UserID));
                return list.ToArray();}}

        public List<SqlParameter> GetNotKeyParams()
        {
            
            List<SqlParameter> list = new List<SqlParameter>();