SQL查询条件生成小工具
时间：2021-07-01 10:21:17
帮助过：6人阅读
using System;
2 using System.Collections.Generic;
3 using System.IO;
4 using System.Linq;
5 using System.Text;
6 using System.Threading.Tasks;
7 using Newtonsoft.Json.Serialization;
8 using Newtonsoft.Json.Linq;
9 using Newtonsoft.Json.Converters;
10 using Newtonsoft.Json.Utilities;
11 using Newtonsoft.Json;
12
13 namespace ConsolePro
14 {
15 public class FileHelper
16 {
17 #region txt \r\n 给txt 文本 批量加‘,‘ 作为sql查询条件
18 public static void CreateSQLContidion()
19 {
20 var filePath =
"D:\\rt.txt";
21 int TotalCountInEveryFile =
10000;
22 List<
string> gotStrings =
GetStreamMethod(filePath);
23 //Console.WriteLine(string.Join("\n", gotStrings.ToArray()));
24 if (gotStrings !=
null)
25 {
26 int fileCount =
1;
27 for (
int i =
0; i < gotStrings.Count; i++
)
28 {
29 StringBuilder sb =
new StringBuilder();
30 sb.AppendFormat(
"{0}\r\n", (
"‘" + gotStrings[i].Trim() +
"‘,"));
31 if (i +
1 <
gotStrings.Count)
32 {
33 i++
;
34 }
35 else
36 {
37 WriteStreamMethod(
string.Format(
"d:\\Document{0}.txt", fileCount), sb.ToString());
38 return;
39 }
40 while (i % TotalCountInEveryFile !=
0)
41 {
42 sb.AppendFormat(
"{0}\r\n", (
"‘" + gotStrings[i].Trim() +
"‘,"));
43 if (i != gotStrings.Count -
1)
44 {
45 i++
;
46 }
47 else
48 {
49 WriteStreamMethod(
string.Format(
"d:\\Document{0}.txt", fileCount), sb.ToString());
50 return;
51 }
52 }
53 //Console.WriteLine(sb.ToString());
54 WriteStreamMethod(
string.Format(
"d:\\Document{0}.txt", fileCount), sb.ToString());
55 if (i % TotalCountInEveryFile ==
0)
56 {
57 i--
;
58 }
59 fileCount++
;
60 }
61 }
62 }
63 #endregion
64
65 public static List<
string> GetStreamMethod(
string path)
66 {
67 List<
string> list =
new List<
string>
();
68 StreamReader sr =
new StreamReader(path);
69 String line;
70 while ((line = sr.ReadLine()) !=
null)
71 {
72 list.Add(line.ToString());
73 }
74 return list;
75 }
76
77 public static string GetStrMethod(
string path)
78 {
79 StringBuilder list =
new StringBuilder();
80 StreamReader sr =
new StreamReader(path);
81 String line;
82 while ((line = sr.ReadLine()) !=
null)
83 {
84 list.Append(line.ToString());
85 }
86 return list.ToString();
87 }
88
89 public static void WriteStreamMethod(
string path,
string content)
90 {
91 FileStream fs =
new FileStream(path, FileMode.Create);
92 StreamWriter sw =
new StreamWriter(fs);
93 sw.Write(content);
94 sw.Flush();
95 sw.Close();
96 fs.Close();
97 }
98
99 public static string GetCustomNo()
100 {
101 var filePath =
"D:\\cus.txt";
102 string gotStrings =
GetStrMethod(filePath);
103 var jsonParse =
gotStrings.ToString();
104 //JObject JsonObj = JObject.Parse(jsonParse);
105 JArray list =
JArray.Parse(jsonParse);
106 IList<JToken> delList =
new List<JToken>
();
107 List<
string> tempStr =
new List<
string>
();
108 StringBuilder s =
new StringBuilder();
109 foreach (
var ss
in list)
//查找某个字段与值
110 {
111 if (((JObject)ss)[
"CustosNo"].ToString() !=
"aa")
112 //tempStr.Add(((JObject)ss)["CustosNo"].ToString());
113 s.Append(
"‘"+((JObject)ss)[
"CustosNo"].ToString()+
"‘,");
114 //delList.Add(ss);
115 }
116
117 //var purchaseInfoes = JsonConvert.DeserializeObject<string>(JsonObj["CustosNo"].ToString());
118 return s.ToString().TrimEnd(
‘,‘);
119
120 }
121 }
122 }
文件实现
SQL查询条件生成小工具
标签：sys span ade tostring 字符串 src gen custom AMM
