/// <summary> /// 获取指定ID的数据 /// </summary> private void QueryOneData() { int userid = Request.Form["id"] != "" ? Convert.ToInt32(Request.Form["id"]) : 0; DataSet ds = bll.GetList(1, "id=" + userid, "ID ASC"); string strJSON = JsonHelper.CreateJsonOne(ds.Tables[0], false); Response.Clear(); Response.Write(strJSON); Response.End(); }
private string CheckLogin(string userName, string userPwd) { CarSpirits.BLL.Admin bll = new CarSpirits.BLL.Admin(); DataTable dt = bll.GetList("LoginName='" + userName + "' and PassWord='******'").Tables[0]; if (dt.Rows.Count > 0) { return("0");//登录成功 } else { return("1"); } }
/// <summary> /// 查询数据 /// </summary> private void QueryData() { int page = Request.Form["page"] != "" ? Convert.ToInt32(Request.Form["page"]) : 0; int size = Request.Form["rows"] != "" ? Convert.ToInt32(Request.Form["rows"]) : 0; string sort = Request.Form["sort"] != "" ? Request.Form["sort"] : ""; string order = Request.Form["order"] != "" ? Request.Form["order"] : ""; if (page < 1) { return; } string orderField = sort.Replace("JSON_", ""); string strWhere = GetWhere(); DataSet dsAdmin = DataHandler.GetList("Admin", "*", "ID", size, page, false, false, strWhere); int count = bll.GetList(strWhere).Tables[0].Rows.Count;//获取总数 string strJSON = JsonHelper.CreateJsonParameters(dsAdmin.Tables[0], true, count); Response.Write(strJSON); Response.End(); }