作项目的时候,遇到了这样的问题,前台传来的Json字符串在实体类中不对应(没法转换为实体类),并且传来的数据项是跟着数据库中的表的变更而变更的(不能重写实体类)。html
前台Json字符串为:数据库
string s1 ="[{\"ID\":\"99d2a341-ea2e-4f04-b4f4-623153d64336\",\"Name\":\"王五\",\"TotalScores\":80,\"工做效率\":\"B\",\"职业道德\":\"B\",\"业务能力\":\"A\",\"连接自律\":\"B\",\"工做成绩\":\"B\"},{\"ID\":\"728f72ac-473b-4bde-bf83-7ed93d3fd9e6\",\"Name\":\"李四\",\"TotalScores\":80,\"工做效率\":\"B\",\"职业道德\":\"B\",\"业务能力\":\"A\",\"连接自律\":\"B\",\"工做成绩\":\"B\"},{\"ID\":\"29c80443-d0ac-414c-91b5-acd5e69e28f2\",\"Name\":\"刘七\",\"TotalScores\":80,\"工做效率\":\"B\",\"职业道德\":\"B\",\"业务能力\":\"A\",\"连接自律\":\"B\",\"工做成绩\":\"B\"}]";markdown
能够看到其实在微软中将“\“”做为双引号用的,思路是这样的:post
一、去掉“\“”lua
代码实现:spa
strings11=s1.Replace("\"","");3d
二、去掉”[]“code
代码实现:xml
string s22 =s11.Replace("[","");htm
string s33 =s22.Replace("]", "");
这是时候咱们获得的s33是这样的:
s33="{ID:99d2a341-ea2e-4f04-b4f4-623153d64336,Name:王五,TotalScores:80,工做效率:B,职业道德:B,业务能力:A,连接自律:B,工做成绩:B},{ID:728f72ac-473b-4bde-bf83-7ed93d3fd9e6,Name:李四,TotalScores:80,工做效率:B,职业道德:B,业务能力:A,连接自律:B,工做成绩:B},{ID:29c80443-d0ac-414c-91b5-acd5e69e28f2,Name:刘七,TotalScores:80,工做效率:B,职业道德:B,业务能力:A,连接自律:B,工做成绩:B}"
三、将”},{“调换为”}“,去掉空值
代码实现:
string s44 =s33.Replace("},{","}");
s44="{ID:99d2a341-ea2e-4f04-b4f4-623153d64336,Name:王五,TotalScores:80,工做效率:B,职业道德:B,业务能力:A,连接自律:B,工做成绩:B}ID:728f72ac-473b-4bde-bf83-7ed93d3fd9e6,Name:李四,TotalScores:80,工做效率:B,职业道德:B,业务能力:A,连接自律:B,工做成绩:B}ID:29c80443-d0ac-414c-91b5-acd5e69e28f2,Name:刘七,TotalScores:80,工做效率:B,职业道德:B,业务能力:A,连接自律:B,工做成绩:B}"
string[] s55s =s44.Split(new Char[] { '}', '{' }, StringSplitOptions.RemoveEmptyEntries);
s55s是获得的”ID:99d2a341-ea2e-4f04-b4f4-623153d64336,Name:王五,...“将获得的结果放在字典中:
for(inti = 0; i
//string[] detailevaluationinfo = updatedEdit[i].Split(',');
stringpat = @"(?[^,:\s]*):(?[^,:\s]*)";
//一组之间的数据拿出来
//for (int j = 0; j
MatchCollection matches = Regex.Matches(updatedEdit[i], pat);
Dictionary dict =newDictionary();
foreach(Match minmatches)
{
if(dict.ContainsKey(m.Groups["key"].Value))continue;//不能重复啊
dict.Add(m.Groups["key"].Value, m.Groups["value"].Value);
}
}
for (int i = 0; i < updatedEdit.Length; i++) {
//string[] detailevaluationinfo = updatedEdit[i].Split(',');
string pat = @"(?[^,:\s]*):(?[^,:\s]*)";
//一组之间的数据拿出来
//for (int j = 0; j < detailevaluationinfo.Length; j++) {
MatchCollection matches = Regex.Matches(updatedEdit[i], pat);
Dictionary dict = new Dictionary();
foreach (Match m in matches)
{
if (dict.ContainsKey(m.Groups["key"].Value)) continue;//不能重复啊
dict.Add(m.Groups["key"].Value, m.Groups["value"].Value);
}
}
这样就能够将Json字符串截取出来。
完整代码:
privatestaticvoidTestRegex20()
{
strings1 ="[{\"ID\":\"99d2a341-ea2e-4f04-b4f4-623153d64336\",\"Name\":\"王五\",\"TotalScores\":80,\"工做效率\":\"B\",\"职业道德\":\"B\",\"业务能力\":\"A\",\"连接自律\":\"B\",\"工做成绩\":\"B\"},{\"ID\":\"728f72ac-473b-4bde-bf83-7ed93d3fd9e6\",\"Name\":\"李四\",\"TotalScores\":80,\"工做效率\":\"B\",\"职业道德\":\"B\",\"业务能力\":\"A\",\"连接自律\":\"B\",\"工做成绩\":\"B\"},{\"ID\":\"29c80443-d0ac-414c-91b5-acd5e69e28f2\",\"Name\":\"刘七\",\"TotalScores\":80,\"工做效率\":\"B\",\"职业道德\":\"B\",\"业务能力\":\"A\",\"连接自律\":\"B\",\"工做成绩\":\"B\"}]";
//去掉反义字符串
strings11 = s1.Replace("\"","");
strings22 = s11.Replace("[","");
strings33 = s22.Replace("]","");
//s33——"{ID:99d2a341-ea2e-4f04-b4f4-623153d64336,Name:王五,TotalScores:80,工做效率:B,职业道德:B,业务能力:A,连接自律:B,工做成绩:B},{ID:728f72ac-473b-4bde-bf83-7ed93d3fd9e6,Name:李四,TotalScores:80,工做效率:B,职业道德:B,业务能力:A,连接自律:B,工做成绩:B},{ID:29c80443-d0ac-414c-91b5-acd5e69e28f2,Name:刘七,TotalScores:80,工做效率:B,职业道德:B,业务能力:A,连接自律:B,工做成绩:B}"
strings44 = s33.Replace("},{","}");
//s44——"{ID:99d2a341-ea2e-4f04-b4f4-623153d64336,Name:王五,TotalScores:80,工做效率:B,职业道德:B,业务能力:A,连接自律:B,工做成绩:B}ID:728f72ac-473b-4bde-bf83-7ed93d3fd9e6,Name:李四,TotalScores:80,工做效率:B,职业道德:B,业务能力:A,连接自律:B,工做成绩:B}ID:29c80443-d0ac-414c-91b5-acd5e69e28f2,Name:刘七,TotalScores:80,工做效率:B,职业道德:B,业务能力:A,连接自律:B,工做成绩:B}"
string[] s55s = s44.Split(newChar[] {'}','{'}, StringSplitOptions.RemoveEmptyEntries);
for(inti = 0; i
{
//string[] detailevaluationinfo = updatedEdit[i].Split(',');
stringpat = @"(?[^,:\s]*):(?[^,:\s]*)";
//一组之间的数据拿出来
//for (int j = 0; j
MatchCollection matches = Regex.Matches(s55s[i], pat);
Dictionary dict =newDictionary();
foreach(Match minmatches)
{
if(dict.ContainsKey(m.Groups["key"].Value))continue;//不能重复啊
dict.Add(m.Groups["key"].Value, m.Groups["value"].Value);
}
}
}
private static void TestRegex20()
{
string s1 = "[{\"ID\":\"99d2a341-ea2e-4f04-b4f4-623153d64336\",\"Name\":\"王五\",\"TotalScores\":80,\"工做效率\":\"B\",\"职业道德\":\"B\",\"业务能力\":\"A\",\"连接自律\":\"B\",\"工做成绩\":\"B\"},{\"ID\":\"728f72ac-473b-4bde-bf83-7ed93d3fd9e6\",\"Name\":\"李四\",\"TotalScores\":80,\"工做效率\":\"B\",\"职业道德\":\"B\",\"业务能力\":\"A\",\"连接自律\":\"B\",\"工做成绩\":\"B\"},{\"ID\":\"29c80443-d0ac-414c-91b5-acd5e69e28f2\",\"Name\":\"刘七\",\"TotalScores\":80,\"工做效率\":\"B\",\"职业道德\":\"B\",\"业务能力\":\"A\",\"连接自律\":\"B\",\"工做成绩\":\"B\"}]";
//去掉反义字符串
string s11 = s1.Replace("\"", "");
string s22 = s11.Replace("[", "");
string s33 = s22.Replace("]", "");
也能够采用"replace("\\", "")"用于执行屡次"toString()"方法产生多余的斜杠
//s33——"{ID:99d2a341-ea2e-4f04-b4f4-623153d64336,Name:王五,TotalScores:80,工做效率:B,职业道德:B,业务能力:A,连接自律:B,工做成绩:B},{ID:728f72ac-473b-4bde-bf83-7ed93d3fd9e6,Name:李四,TotalScores:80,工做效率:B,职业道德:B,业务能力:A,连接自律:B,工做成绩:B},{ID:29c80443-d0ac-414c-91b5-acd5e69e28f2,Name:刘七,TotalScores:80,工做效率:B,职业道德:B,业务能力:A,连接自律:B,工做成绩:B}"
string s44 = s33.Replace("},{", "}");
//s44——"{ID:99d2a341-ea2e-4f04-b4f4-623153d64336,Name:王五,TotalScores:80,工做效率:B,职业道德:B,业务能力:A,连接自律:B,工做成绩:B}ID:728f72ac-473b-4bde-bf83-7ed93d3fd9e6,Name:李四,TotalScores:80,工做效率:B,职业道德:B,业务能力:A,连接自律:B,工做成绩:B}ID:29c80443-d0ac-414c-91b5-acd5e69e28f2,Name:刘七,TotalScores:80,工做效率:B,职业道德:B,业务能力:A,连接自律:B,工做成绩:B}"
string[] s55s = s44.Split(new Char[] { '}', '{' }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < s55s.Length; i++)
{
//string[] detailevaluationinfo = updatedEdit[i].Split(',');
string pat = @"(?[^,:\s]*):(?[^,:\s]*)";
//一组之间的数据拿出来
//for (int j = 0; j < detailevaluationinfo.Length; j++) {
MatchCollection matches = Regex.Matches(s55s[i], pat);
Dictionary dict = new Dictionary();
foreach (Match m in matches)
{
if (dict.ContainsKey(m.Groups["key"].Value)) continue;//不能重复啊
dict.Add(m.Groups["key"].Value, m.Groups["value"].Value);
}
}
}