public string GetZhongXins() { QueryInfo Query = new QueryInfo(); Query.PageSize = tools.CheckInt(Request["rows"]); Query.CurrentPage = tools.CheckInt(Request["page"]); Query.ParamInfos.Add(new ParamInfo("AND", "int", "ZhongXinInfo.ID", ">", "0")); string keyword = tools.CheckStr(Request["keyword"]); if (keyword != "") { Query.ParamInfos.Add(new ParamInfo("AND(", "str", "ZhongXinInfo.CompanyName", "like", keyword)); Query.ParamInfos.Add(new ParamInfo("OR)", "str", "ZhongXinInfo.ReceiptAccount", "like", keyword)); } Query.OrderInfos.Add(new OrderInfo(tools.CheckStr(Request["sidx"]), tools.CheckStr(Request["sord"]))); PageInfo pageinfo = MyBLL.GetPageInfo(Query); IList <ZhongXinInfo> entitys = null; if (pageinfo.RecordCount > 0) { entitys = MyBLL.GetZhongXins(Query); } SupplierInfo supplier = null; if (entitys != null) { StringBuilder jsonBuilder = new StringBuilder(); jsonBuilder.Append("{\"page\":" + pageinfo.CurrentPage + ",\"total\":" + pageinfo.PageCount + ",\"records\":" + pageinfo.RecordCount + ",\"rows\""); jsonBuilder.Append(":["); foreach (ZhongXinInfo entity in entitys) { jsonBuilder.Append("{\"id\":" + entity.ID + ",\"cell\":["); //各字段 jsonBuilder.Append("\""); jsonBuilder.Append(entity.ID); jsonBuilder.Append("\","); jsonBuilder.Append("\""); supplier = MySupplier.GetSupplierByID(entity.SupplierID, Public.GetUserPrivilege()); if (supplier != null) { jsonBuilder.Append(Public.JsonStr(supplier.Supplier_CompanyName)); } else { jsonBuilder.Append(entity.SupplierID); } jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append(Public.JsonStr(entity.CompanyName)); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append(Public.JsonStr(entity.OpenAccountName)); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append(Public.JsonStr(entity.SubAccount)); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append(Public.JsonStr(entity.ReceiptAccount)); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append(Public.JsonStr(entity.ReceiptBank)); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append(Public.JsonStr(entity.BankName)); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append(Public.JsonStr(entity.BankCode)); jsonBuilder.Append("\","); jsonBuilder.Append("\""); if (entity.Audit == 0) { jsonBuilder.Append(Public.JsonStr("未审核")); } else { jsonBuilder.Append(Public.JsonStr("已审核")); } jsonBuilder.Append("\","); jsonBuilder.Append("\""); if (entity.Register == 0) { jsonBuilder.Append(Public.JsonStr("未推送")); } else if (entity.Register == 1) { jsonBuilder.Append(Public.JsonStr("已推送未绑定")); } else { jsonBuilder.Append(Public.JsonStr("已推送绑定")); } jsonBuilder.Append("\","); jsonBuilder.Append("\""); if (entity.Audit == 1)//平台已审核 { if (entity.Register == 0) { jsonBuilder.Append("<img src=\\\"/images/btn_add.gif\\\" alt=\\\"推送数据\\\" align=\\\"absmiddle\\\"> <a href=\\\"javascript:void(0);\\\" onclick=\\\"window.open('zhongxin_do.aspx?action=tuisong&id=" + entity.ID + "', '_self')\\\">推送数据</a> "); } if (entity.Register == 1) { jsonBuilder.Append("<img src=\\\"/images/btn_add.gif\\\" alt=\\\"绑定出金账号\\\" align=\\\"absmiddle\\\"> <a href=\\\"javascript:void(0);\\\" onclick=\\\"window.open('zhongxin_do.aspx?action=editRegister&id=" + entity.ID + "', '_self')\\\">绑定</a> "); } } jsonBuilder.Append("<img src=\\\"/images/btn_add.gif\\\" alt=\\\"修改\\\" align=\\\"absmiddle\\\"> <a href=\\\"zhongxin_edit.aspx?id=" + entity.ID + "\\\" title=\\\"修改\\\">修改</a> "); jsonBuilder.Append("\","); jsonBuilder.Remove(jsonBuilder.Length - 1, 1); jsonBuilder.Append("]},"); } jsonBuilder.Remove(jsonBuilder.Length - 1, 1); jsonBuilder.Append("]"); jsonBuilder.Append("}"); return(jsonBuilder.ToString()); } else { return(null); } }