/// <summary>
/// 获取列表
/// </summary>
public ActionResult GetDataGridJsonV(string userID)
{
SplitPage s = new SplitPage()
{
Conditions = new Conditions[]
{
new Conditions()
{
Key = "userID", Value = userID
}
}
};
s.sort = "CreateDate";
s.order = "desc";
int total = 0;
string sqlw = SxSqlHelperBLL.getSqlw(s);
System.Data.DataTable dt = new System.Data.DataTable();
SxSqlHelperBLL.getPageDataEasyUi(sqlw, "Base_Person", s, ref total, ref dt);
if (!TB.CheckTB(dt))
{
dt = new System.Data.DataTable();
}
var jsonData = new { rows = dt, total = total };
return(ToJsonResult(jsonData));
}
/// <summary>
/// 获取列表
/// </summary>
public ActionResult GetDataGridJsonV(int?typeX)
{
SplitPage splitPage = new SplitPage()
{
Conditions = new Conditions[]
{
new Conditions()
{
Key = "isnull(isOK,-1)", Value = typeX.ToStringV()
}
}
};
splitPage.order = "desc";
splitPage.sort = "createDate";
string sqlw = SxSqlHelperBLL.getSqlw(splitPage);
int total = 0;
System.Data.DataTable dt = new System.Data.DataTable();
SxSqlHelperBLL.getPageDataEasyUi(sqlw, "CR_CreditMoney", splitPage, ref total, ref dt);
if (!TB.CheckTB(dt))
{
dt = new System.Data.DataTable();
}
var jsonData = new { rows = dt, total = total };
return(ToJsonResult(jsonData));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="splitPage">分页参数</param>
/// <returns></returns>
public ActionResult GetDataGridJson(SplitPage splitPage)
{
string sqlw = SxSqlHelperBLL.getSqlw(splitPage);
int total = 0;
System.Data.DataTable dt = new System.Data.DataTable();
SxSqlHelperBLL.getPageDataEasyUi(sqlw, "Base_Person", splitPage, ref total, ref dt);
if (!TB.CheckTB(dt))
{
dt = new System.Data.DataTable();
}
var jsonData = new { rows = dt, total = total };
return(ToJsonResult(jsonData));
}
