/// <summary> /// 查询固定数据语句 /// </summary> /// <param name="tabID">tableid</param> /// <returns></returns> public DataTable GetDataSourceSqlId(string tabID, string where) { try { Dictionary <string, Dimention> report = GetReport(); Dimention dimention = report[tabID]; ArrayList al = new ArrayList(); string sql = ""; string citydatawherecondition = string.Empty; DataTable dt = new DataTable(); sql = dimention.SqlAll.Replace("%Where%", where); if (tabID.Equals("")) { dt = null; } else { al.Add(sql); dt = MySqlHelpers.Query(al).Tables[0]; } return(dt); } catch (Exception ex) { FileLog.WriteLog(ex.ToString()); return(null); } }
/// <summary> /// 返回DataSet /// </summary> /// <param name="param"></param> /// <returns></returns> public DataSet GetDataSetToParamID(Dictionary <string, Newtonsoft.Json.Linq.JArray> param) { Dictionary <string, Dimention> report = GetReport(); string sql = string.Empty; DataSet ds = null; List <string> repSql = new List <string>(); ArrayList al = new ArrayList(); try { if (param != null) { foreach (var d in param) { Dimention dimention = report[d.Key]; sql = dimention.SqlAll; foreach (var arry in d.Value) { int i = 0; ////替换后的sql语句 foreach (var o in Newtonsoft.Json.Linq.JObject.FromObject(arry)) { sql = sql.Replace("[@c" + i + "]", o.Value.ToString()); i = i + 1; } } } } al.Add(sql); ds = MySqlHelpers.Query(al); } catch (Exception ex) { FileLog.WriteLog(ex.ToString()); } if (ds != null) { return(ds); } else { return(null); } }
/// <summary> /// 安装ID编号查找 /// </summary> /// <param name="tabID"></param> /// <returns></returns> public DataTable GetGridDataSource(string tabID) { Dictionary <string, Dimention> report = GetReport(); Dimention dimention = report[tabID]; ArrayList al = new ArrayList(); string sql = ""; DataTable dt = null; sql = dimention.SqlAll.Replace("%Where%", " "); al.Add(sql); DataSet ds = new DataSet(); ds = MySqlHelpers.Query(al); for (int i = 0; i < ds.Tables.Count; i++) { if (dt != null) { if (ds.Tables[i].Rows.Count > 0) { dt.Merge(ds.Tables[i]); } } else { if (ds.Tables[i].Rows.Count > 0) { dt = ds.Tables[i].Copy(); } } } if (dt != null) { DataView dv = dt.DefaultView; // dv.Sort = "CITYNAME"; dt = dv.ToTable(); } return(dt); }