Beispiel #1
0
        public override SqlParameter[] GetParameters()
        {
            M_UserBaseField model = this;

            SqlParameter[] sp = GetSP();
            sp[0].Value  = model.FieldID;
            sp[1].Value  = model.FieldName;
            sp[2].Value  = model.FieldAlias;
            sp[3].Value  = model.FieldTips;
            sp[4].Value  = model.Description;
            sp[5].Value  = model.IsNotNull;
            sp[6].Value  = model.FieldType;
            sp[7].Value  = model.Content;
            sp[8].Value  = model.OrderId;
            sp[9].Value  = model.ShowList;
            sp[10].Value = model.ShowWidth;
            sp[11].Value = model.NoEdit;
            sp[12].Value = model.IsCopy;
            return(sp);
        }
Beispiel #2
0
        public M_UserBaseField GetModelFromReader(DbDataReader rdr)
        {
            M_UserBaseField model = new M_UserBaseField();

            model.FieldID     = Convert.ToInt32(rdr["FieldID"]);
            model.FieldName   = ConverToStr(rdr["FieldName"]);
            model.FieldAlias  = ConverToStr(rdr["FieldAlias"]);
            model.FieldTips   = ConverToStr(rdr["FieldTips"]);
            model.Description = ConverToStr(rdr["Description"]);
            model.IsNotNull   = ConverToBool(rdr["IsNotNull"]);
            model.FieldType   = ConverToStr(rdr["FieldType"]);
            model.Content     = ConverToStr(rdr["Content"]);
            model.OrderId     = ConvertToInt(rdr["OrderId"]);
            model.ShowList    = ConvertToInt(rdr["ShowList"]);
            model.ShowWidth   = ConvertToInt(rdr["ShowWidth"]);
            model.NoEdit      = ConvertToInt(rdr["NoEdit"]);
            model.IsCopy      = ConvertToInt(rdr["IsCopy"]);
            rdr.Close();
            rdr.Dispose();
            return(model);
        }
Beispiel #3
0
        /// <summary>
        /// GetInfoFromDataTable
        /// </summary>
        /// <param name="Rowsinfo">DataTable</param>
        public M_UserBaseField GetInfoFromDataTable(DataTable Rowsinfo)
        {
            M_UserBaseField info = new M_UserBaseField();

            if (Rowsinfo.Rows.Count > 0)
            {
                info.FieldID     = Convert.ToInt32(Rowsinfo.Rows[0]["FieldID"]);
                info.FieldName   = ConverToStr(Rowsinfo.Rows[0]["FieldName"]);
                info.FieldAlias  = ConverToStr(Rowsinfo.Rows[0]["FieldAlias"]);
                info.FieldTips   = ConverToStr(Rowsinfo.Rows[0]["FieldTips"]);
                info.Description = ConverToStr(Rowsinfo.Rows[0]["Description"]);
                info.IsNotNull   = ConverToBool(Rowsinfo.Rows[0]["IsNotNull"]);
                info.FieldType   = ConverToStr(Rowsinfo.Rows[0]["FieldType"]);
                info.Content     = ConverToStr(Rowsinfo.Rows[0]["Content"]);
                info.OrderId     = ConvertToInt(Rowsinfo.Rows[0]["OrderId"]);
                info.ShowList    = ConvertToInt(Rowsinfo.Rows[0]["ShowList"]);
                info.ShowWidth   = ConvertToInt(Rowsinfo.Rows[0]["ShowWidth"]);
                info.NoEdit      = ConvertToInt(Rowsinfo.Rows[0]["NoEdit"]);
                info.IsCopy      = ConvertToInt(Rowsinfo.Rows[0]["IsCopy"]);
            }
            return(info);
        }