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