public ActionResult WriteBackResult(WriteBackResultQueryForm form, EasyUIGridSetting gridSetting)
{
FCWebserviceBll bll = new FCWebserviceBll();
EasyUIGridModel result = bll.GetWriteBackResult(form, gridSetting);
return(Content(result.ToJson(), "application/json"));
}
public EasyUIGridModel GetWriteBackResult(WriteBackResultQueryForm form, EasyUIGridSetting gridSetting)
{
string sql = string.Format(@"SELECT SLBH,DJLX,SFTS,PUSHDATA,PUSHDATE,PUSHRESULT,WBERRINFO,CGERRINFO,PID,ADDRESSTYPE
FROM (Select ROWNUM AS ROWNO, T.*
from (select * from FC_SPFHX_TAG where {0} order by pushdate desc) T
WHERE ROWNUM <= {1}) TABLE_ALIAS
WHERE TABLE_ALIAS.ROWNO > {2} ", form.GetWhere(), gridSetting.PageIndex * gridSetting.PageSize, (gridSetting.PageIndex - 1) * gridSetting.PageSize, gridSetting.SortBy.PropertyName, gridSetting.SortBy.SortType);
if (gridSetting.SortBy.PropertyName != "")
{
sql += " order by " + gridSetting.SortBy.PropertyName + " " + gridSetting.SortBy.SortType;
}
DataSet ds = DBHelper.GetDataSet(sql);
TBToList <SPFHX_TAG> list = new TBToList <SPFHX_TAG>();
IList <SPFHX_TAG> tags = list.ConvertToModel(ds.Tables[0]);
string countSql = string.Format("Select count(1) from FC_SPFHX_TAG where {0}", form.GetWhere());
int count = DBHelper.GetScalar(countSql);
EasyUIGridModel ret = new EasyUIGridModel(gridSetting.PageIndex, count, tags);
return(ret);
}
