/// <summary>
/// 得到一个对象实体
/// </summary>
public Models.Beans.User GetModel(int userid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select userid,username,realname,password,phone,enable,createtime,modifytime,sex,address, roletype,createtime ,createman,modifytime,modifyman from t_user ");
strSql.Append(" where userid=@userid");
MySqlParameter[] parameters = {
new MySqlParameter("@userid", MySqlDbType.Int32)
};
parameters[0].Value = userid;
Models.Beans.User model = new Models.Beans.User();
DataSet ds = MySqlHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["userid"].ToString() != "")
{
model.userid = int.Parse(ds.Tables[0].Rows[0]["userid"].ToString());
}
model.username = ds.Tables[0].Rows[0]["username"].ToString();
model.password = ds.Tables[0].Rows[0]["password"].ToString();
model.phone = ds.Tables[0].Rows[0]["phone"].ToString();
if (ds.Tables[0].Rows[0]["enable"].ToString() != "")
{
model.enable = int.Parse(ds.Tables[0].Rows[0]["enable"].ToString());
}
model.createtime= DateTime.Parse( ds.Tables[0].Rows[0]["createtime"].ToString());
model.modifytime= DateTime.Parse( ds.Tables[0].Rows[0]["modifytime"].ToString());
model.sex = ds.Tables[0].Rows[0]["sex"].ToString();
model.address = ds.Tables[0].Rows[0]["address"].ToString();
model.roletype = ds.Tables[0].Rows[0]["roletype"].ToString();
model.createman = ds.Tables[0].Rows[0]["createman"].ToString();
model.modifyman = ds.Tables[0].Rows[0]["modifyman"].ToString();
model.realname = ds.Tables[0].Rows[0]["realname"].ToString();
return model;
}
else
{
return null;
}
}
public JsonResult GetUserList(String name, int pageidx = 0, int pagesize = 20)
{
ContractMvcWeb.Models.AccountContext db = new Models.AccountContext();
ContractMvcWeb.Models.Beans.User query = new Models.Beans.User();
query.username = name;
query.realname = name;
query.phone = name;
Models.Beans.Page<ContractMvcWeb.Models.Beans.User> list = db.QueryByPage(query, pageidx, pagesize);
Models.Result result = new Result((int)ResultCodeEnum.Success, "", list);
JsonResult jsonresult = new JsonResult();
jsonresult.Data = result;
jsonresult.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
return jsonresult;
}
