private string makeSql1() { string sql = "select "; for (int i = 0; i < configM.List.Count; i++) { DBConfigItem item = configM.List[i]; sql += item.Dbfld + " as " + item.ApiKey; if (i < configM.List.Count - 1) { sql += ","; } } string from = " from " + configM.TbName; string rsql1 = sql + from; return(rsql1); }
private string makeSql() { string sql = "select "; for (int i = 0; i < configM.List.Count; i++) { DBConfigItem item = configM.List[i]; sql += item.Dbfld + " as " + item.ApiKey; if (i < configM.List.Count - 1) { sql += ","; } } string from = " from " + configM.TbName; string where = " where " + configM.Timefld + ">='{0}' and " + configM.Timefld + "<'{1}'"; rsql = sql + from + where; return(rsql); }