Model/SystemRoleRelation_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 SystemRoleRelation_Model:Model.Base.ModelBase
    {
	    public SystemRoleRelation_Model()
        {
            TableName = "SystemRoleRelation";
            PKey = "SystemRoleRelationID";
            PKeyDataType = typeof(System.Int32);
        }

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

        public override string AddSQL
        { get
            {
                return @"INSERT INTO [SystemRoleRelation]
           ( [SystemRoleID],[UserID]) VALUES (@SystemRoleID,@UserID);select @@identity ";}}

        public override string UpdateSQL
        { get
            {
                return @"UPDATE [SystemRoleRelation]
            SET [SystemRoleID]=@SystemRoleID,[UserID]=@UserID WHERE  [SystemRoleRelationID]=@SystemRoleRelationID";}}

        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("@SystemRoleRelationID", M_SystemRoleRelationID));
                return list.ToArray();}}

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