public string GetList(string whereString, string orderByString, string columnsString, string pageSizeString, string pageIndexString, string clientInf) { #region 初始化 sara.dd.ldsw.commonclass.commonclass cc = new sara.dd.ldsw.commonclass.commonclass(); #endregion Dictionary <string, string> resultDic = new Dictionary <string, string>(); resultDic["result"] = ""; resultDic["message"] = ""; try { columnsString = FormatColumns(columnsString).Replace("^", ","); //code-less??? List <sara.dd.ldsw.model.tbl_maintable> list_tbl_maintable = _idal_tbl_maintable.GetList(whereString, orderByString, columnsString, pageSizeString, pageIndexString, null); //获取图形队列状态,只有上图状态在此获取 string rows = Eva.Library.Format.FormatEntityTool.FormatModelListToJson <sara.dd.ldsw.model.tbl_maintable>(list_tbl_maintable, columnsString); string message = "{\"total\":\"" + _idal_tbl_maintable.GetCount(whereString, null) + "\",\"rows\":" + rows + "}"; resultDic["message"] = message; resultDic["result"] = "true"; NewLog("数据查询成功,查询的数据条件为:whereString:" + whereString + ",orderByString:" + orderByString + ",columnsString:" + columnsString + ",pageSizeString:" + pageSizeString + ",pageIndexString:" + pageIndexString + "", "sql_select", clientInf); } catch (Exception ex) { resultDic["result"] = "false"; resultDic["message"] = Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace); NewLog("数据查询失败,查询的数据条件为:whereString:" + whereString + ",orderByString:" + orderByString + ",columnsString:" + columnsString + ",pageSizeString:" + pageSizeString + ",pageIndexString:" + pageIndexString + ",异常信息:" + Eva.Library.Format.FormatTextTool.ErrorMessageFormat(ex.Message + ex.StackTrace), "sql_select", clientInf); } return(Eva.Library.Format.FormatEntityTool.FormatDicToJson(resultDic)); }