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); }
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); }
/// <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); }