/// <summary>
///
/// </summary>
/// <returns></returns>
public ActionResult ProjectGrid(tk_ProjectSearch ProjectSearch)
{
if (ModelState.IsValid)
{
string where = "";
string strCurPage;
string strRowNum;
string ProID = ProjectSearch.ProID;
string Pname = ProjectSearch.Pname;
string start = ProjectSearch.StartDate;
string end = ProjectSearch.EndDate;
if (Request["curpage"] != null)
{
strCurPage = Request["curpage"].ToString();
}
if (Request["rownum"] != null)
{
strRowNum = Request["rownum"].ToString();
}
else
{
strRowNum = "10";
}
if (ProID != "" && ProID != null)
{
where += " and a.ProID like '%" + ProID + "%'";
}
if (Pname != "" && Pname != null)
{
where += " and a.Pname like '%" + Pname + "%'";
}
if (start != "" && start != null)
{
where += " and a.CreateTime >= '" + start + "' and a.CreateTime <= '" + end + "'";
}
UIDataTable udtTask = ContractMan.getNewProjectGrid(GFun.SafeToInt32(strRowNum), GFun.SafeToInt32(Request["curpage"]) - 1, where);
string strjson = GFun.Dt2Json("", udtTask.DtData);
strjson = strjson.Substring(1);
strjson = strjson.Substring(0, strjson.Length - 1);
string jsonData = "{ \"page\":" + GFun.SafeToInt32(Request["curpage"]) + ", \"total\": " + udtTask.IntTotalPages + ", \"records\": " + udtTask.IntRecords + ", \"rows\": ";
jsonData += strjson + "}";
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
else
{
//如果有错误，继续输入信息
return(Json(new { success = false, Msg = "查询条件验证不通过" }));
}
}
