/// <summary> /// 得到一个对象实体 /// </summary> public XCLCMS.Data.Model.View.v_SysWebSetting GetModel(long SysWebSettingID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from v_SysWebSetting WITH(NOLOCK) "); strSql.Append(" where SysWebSettingID=@SysWebSettingID "); XCLCMS.Data.Model.View.v_SysWebSetting model = new XCLCMS.Data.Model.View.v_SysWebSetting(); Database db = base.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "SysWebSettingID", DbType.Int64, SysWebSettingID); using (var dr = db.ExecuteReader(dbCommand)) { return(XCLNetTools.DataSource.DataReaderHelper.DataReaderToEntity <XCLCMS.Data.Model.View.v_SysWebSetting>(dr)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public XCLCMS.Data.Model.View.v_SysWebSetting GetModel(long SysWebSettingID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from v_SysWebSetting "); strSql.Append(" where SysWebSettingID=@SysWebSettingID "); XCLCMS.Data.Model.View.v_SysWebSetting model = new XCLCMS.Data.Model.View.v_SysWebSetting(); Database db = base.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "SysWebSettingID", DbType.Int64, SysWebSettingID); DataSet ds = db.ExecuteDataSet(dbCommand); var lst = XCLNetTools.Generic.ListHelper.DataSetToList <XCLCMS.Data.Model.View.v_SysWebSetting>(ds); return(null != lst && lst.Count > 0 ? lst[0] : null); }