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