public static String getBoolDataPayLoad(String column, List <String> columns, String dbName, String table, int index) { String data = data_value.Replace("{data}", column).Replace("{allcolumns}", Comm.unionColumns(columns, ",")).Replace("{orderby}", columns[0]); String payload = data.Replace("{dbname}", dbName).Replace("{table}", table).Replace("{data}", column).Replace("{index}", index.ToString()); return(payload); }
public static String getUnionDataValue(String unionFileTemplate, List <String> columns, String dbname, String table, String index) { String data = "chr(94)||chr(94)||chr(33)||" + unionColumns(columns, "||chr(36)||chr(36)||chr(36)||") + "||chr(33)||chr(94)||chr(94)"; String template = unionFileTemplate.Replace("{data}", (data_no_cast_value.Replace("{data}", data).Replace("{allcolumns}", Comm.unionColumns(columns, ",")).Replace("{dbname}", dbname).Replace("{table}", table).Replace("{index}", index))); return(union_value.Replace("{data}", template)); }
public static String getUnionDataValue(int columnsLen, int showIndex, String Fill, List <String> columns, String table, String index) { StringBuilder sb = new StringBuilder(); String data = "chr(94)&chr(94)&chr(33)&" + Comm.unionColumns(columns, "&chr(36)&chr(36)&chr(36)&") + "&chr(33)&chr(94)&chr(94)"; for (int i = 1; i <= columnsLen; i++) { if (i == showIndex) { sb.Append(data_value.Replace("{data}", data).Replace("{allcolumns}", Comm.unionColumns(columns, ",")).Replace("{table}", table).Replace("{index}", index).Replace("{orderby}", columns[0])); sb.Append(","); } else { sb.Append(Fill + ","); } } sb.Remove(sb.Length - 1, 1); return(union_value.Replace("{data}", sb.ToString())); }
/// <summary> /// /// </summary> /// <param name="columnsLen">列长</param> /// <param name="showIndex">显示列</param> /// <param name="Fill">填充</param> /// <param name="dbname">数据库名</param> /// <param name="table">表名</param> /// <param name="column">获取数据的字段</param> /// <param name="index">第几行数据,1开始</param> public static String getErrorDataValue(String dbname, String table,int index,List<String> columns) { String data = data_value.Replace("{data}", Comm.unionColumns(columns,",")).Replace("{orderby}", columns[0]); String d = data.Replace("{dbname}", dbname).Replace("{table}", table).Replace("{index}", index.ToString()); return error_value.Replace("{data}", d); }