Model/DataDictionary_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 DataDictionary_Model:Model.Base.ModelBase
    {
	    public DataDictionary_Model()
        {
            TableName = "DataDictionary";
            PKey = "DataDictionaryID";
            PKeyDataType = typeof(System.Int32);
        }

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

        public override string AddSQL
        { get
            {
                return @"INSERT INTO [DataDictionary]
           ( [TableName],[FieldName],[FieldCName],[DataType],[DataLength],[Nullable],[ToolTip],[FieldDesc],[OrderNum],[IsDelete]) VALUES (@TableName,@FieldName,@FieldCName,@DataType,@DataLength,@Nullable,@ToolTip,@FieldDesc,@OrderNum,@IsDelete);select @@identity ";}}

        public override string UpdateSQL
        { get
            {
                return @"UPDATE [DataDictionary]
            SET [TableName]=@TableName,[FieldName]=@FieldName,[FieldCName]=@FieldCName,[DataType]=@DataType,[DataLength]=@DataLength,[Nullable]=@Nullable,[ToolTip]=@ToolTip,[FieldDesc]=@FieldDesc,[OrderNum]=@OrderNum,[IsDelete]=@IsDelete WHERE  [DataDictionaryID]=@DataDictionaryID";}}

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

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