/// <summary>
/// 得到一个对象实体
/// </summary>
public Gymnasium_APP.Model.RoleModel DataRowToModel(DataRow row)
{
Gymnasium_APP.Model.RoleModel model=new Gymnasium_APP.Model.RoleModel();
if (row != null)
{
if(row["RoleId"]!=null && row["RoleId"].ToString()!="")
{
model.RoleId=int.Parse(row["RoleId"].ToString());
}
if(row["RoleName"]!=null)
{
model.RoleName=row["RoleName"].ToString();
}
if(row["RoleMailRoom"]!=null && row["RoleMailRoom"].ToString()!="")
{
model.RoleMailRoom=int.Parse(row["RoleMailRoom"].ToString());
}
if(row["RoleSynopsis"]!=null)
{
model.RoleSynopsis=row["RoleSynopsis"].ToString();
}
if(row["DataTime"]!=null)
{
model.DataTime=row["DataTime"].ToString();
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Gymnasium_APP.Model.RoleModel GetModel(int RoleId)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 RoleId,RoleName,RoleMailRoom,RoleSynopsis,DataTime from Role ");
strSql.Append(" where RoleId=@RoleId ");
SqlParameter[] parameters = {
new SqlParameter("@RoleId", SqlDbType.Int,4) };
parameters[0].Value = RoleId;
Gymnasium_APP.Model.RoleModel model=new Gymnasium_APP.Model.RoleModel();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
