/// <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();
}
