/// <summary>
/// 得到一个对象实体
/// </summary>
public TrainerEvaluate.Models.SysUser DataRowToModel(DataRow row)
{
TrainerEvaluate.Models.SysUser model=new TrainerEvaluate.Models.SysUser();
if (row != null)
{
if(row["UserId"]!=null && row["UserId"].ToString()!="")
{
model.UserId= new Guid(row["UserId"].ToString());
}
if(row["UserRole"]!=null && row["UserRole"].ToString()!="")
{
model.UserRole=int.Parse(row["UserRole"].ToString());
}
if(row["UserName"]!=null)
{
model.UserName=row["UserName"].ToString();
}
if(row["UserPassWord"]!=null)
{
model.UserPassWord=row["UserPassWord"].ToString();
}
if(row["CreateTime"]!=null && row["CreateTime"].ToString()!="")
{
model.CreateTime=DateTime.Parse(row["CreateTime"].ToString());
}
if(row["UserAccount"]!=null)
{
model.UserAccount=row["UserAccount"].ToString();
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TrainerEvaluate.Models.SysUser GetModel(Guid UserId)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 UserId,UserRole,UserName,UserPassWord,CreateTime,UserAccount from SysUser ");
strSql.Append(" where UserId=@UserId ");
SqlParameter[] parameters = {
new SqlParameter("@UserId", SqlDbType.UniqueIdentifier,16) };
parameters[0].Value = UserId;
TrainerEvaluate.Models.SysUser model=new TrainerEvaluate.Models.SysUser();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
