描述下背景:目前做一个项目,需要对接第三方提供的WebService接口,读取xml数据并保存进数据库。然后而拿到数据的时候有点蒙蔽。返回来的数据是这样子的:
[{material_number=04.04.09.001.0398, material_model=WYD33W04-2200, qty=128, entry_id=frpbjbgpQheLY3CkGASZEiYEHMU=, material_name=浴霸2200W, totalReceiptQty=0},
{material_number=04.04.09.001.0399, material_model=WYD36W05-2200, qty=3332, entry_id=hTuWOEN2SAmasjdHve10syYEHMU=, material_name=浴霸2200W, totalReceiptQty=40},
{material_number=04.04.09.001.0400, material_model=WYD36W05-2400, qty=1000, entry_id=EUqVAulQQDidTA+N1RBQnSYEHMU=, material_name=浴霸2400W, totalReceiptQty=40},
{material_number=04.04.09.001.0401, material_model=WYD36W05-2600, qty=660, entry_id=D/NFnu3dTZGlzO16K6ThDSYEHMU=, material_name=浴霸2600W, totalReceiptQty=40},
{material_number=04.04.09.001.0407, material_model=WYD36W11-2600, qty=200, entry_id=Ut5TcbHCQc602ibG0na7tiYEHMU=, material_name=浴霸2600W, totalReceiptQty=40},
{material_number=04.04.09.001.0404, material_model=WYD36S08-1200, qty=1660, entry_id=YP/F0BgQT1+NA2QXEovgmSYEHMU=, material_name=浴霸1200W, totalReceiptQty=0},
{material_number=04.04.09.001.0405, material_model=WYD33X09-35, qty=300, entry_id=P6BSIaibSLeoNyRwafiBkiYEHMU=, material_name=凉霸35W, totalReceiptQty=0},
{material_number=04.04.09.001.0406, material_model=WYD33X10-40, qty=2000, entry_id=a+Yr0Ep8QWWPha7p36mmnSYEHMU=, material_name=换气扇40W, totalReceiptQty=0}]
[{ orderCustomerNnumber=01.008.0001, material_number=01.01.21.050.0579, material_model=T=0.3锰钢 表面:镀镍 26*10*8.5mm 图号:CMLS-MT5X06-009, qty=1500, orderCustomerName=华东零星客户, entry_id=6GBFaZ78TjikdC/OjvLwA8z9SSM=, material_name=挂板, shippedQty=1500 }, {orderCustomerNnumber=01.008.0001, material_number=01.02.12.001.0080, material_model=十字沉头4*20AN铁镀锌Rohs, qty=1500, orderCustomerName=华东零星客户,
entry_id=E/u2J7tGR7m1zdz/tCKk4cz9SSM=, material_name=螺丝, shippedQty=1500}]
[{orderCustomerNnumber=01.008.0001, material_number=01.02.13.070.3045, material_model=10W光面球泡-商超版彩盒-6500K-350G灰底白板,尺寸62*62*115,WA2W21-10-886E-02-SC, qty=3000,
orderCustomerName=华东零星客户, entry_id=jOgMCPN/TP2nY170m1XU8sz9SSM=, material_name=内盒, shippedQty=3000}]
好吧
1、直接序列化对象肯定是不可行的了
2、尝试将字符串通过字符替换的方式转换为可序列化的Json格式,最终也以失败告终,因为它的值包含了“,”、“:”等,即什么情况都可以出现,无法进行替换。
3、好吧 那只能进行字符截取了:将类的属性名称解析出来,遍历获得属性名称在字符串中的索引,再通过索引将字符串中的值分割出来。
4、好吧 不知道有没有更好的办法
5、花了一个晚上的时候来处理了这个问题
6、最坑的来了,将写好的方法跑测试,发现存到了一些空的行,检查一下,发现返回的数据居然正常了,返回xml格式了,居然正常了,常了!!!!!!!!!!!
7、第三方哪个SaZi写的代码,老子想砍人~~~
8、下面是写的解决方法
9、专此记录一下被坑,屌丝何必为难屌丝
using System; using System.Collections.Generic; using System.Globalization; using System.Linq; using System.Text; using System.Text.RegularExpressions; using System.Threading.Tasks; namespace StringToObject { public class XmlHelper { /// <summary> /// 将字符串解析为泛型对象List /// </summary> /// <typeparam name="T"></typeparam> /// <param name="strData"></param> /// <returns></returns> public static List<T> GetObjectListFormString<T>(string strData) { List<T> output = new List<T>(); strData = FormatString(strData); if (string.IsNullOrEmpty(strData)) return output; string[] stringArrar = Regex.Split(strData, "},{", RegexOptions.IgnoreCase); List<KeyValueClasss> targetObjectNameList = GetTNameList<T>(); CompareInfo compare = CultureInfo.InvariantCulture.CompareInfo; stringArrar.ToList().ForEach(t => { targetObjectNameList.ForEach(l => { l.Index = compare.IndexOf(t, l.Key, CompareOptions.IgnoreCase); }); targetObjectNameList = targetObjectNameList.Where(l => l.Index != -1).OrderBy(l => l.Index).ToList(); for (int i = 0; i < targetObjectNameList.Count; i++) { if (i == 0) { string newValue = string.Empty; if (targetObjectNameList.Count() <= 1) { newValue = t.Substring(targetObjectNameList[i].Key.Length); } else { int index = targetObjectNameList[i].Key.Length; int size = targetObjectNameList[i + 1].Index - targetObjectNameList[i].Index - targetObjectNameList[i + 1].Key.Length - 1; newValue = t.Substring(index, size); } newValue = newValue.Remove(0, 1); newValue = newValue.Remove(newValue.Length - 1, 1); targetObjectNameList[i].Value = newValue; } else if (i == targetObjectNameList.Count() - 1) { int index = targetObjectNameList[i].Index + targetObjectNameList[i].Key.Length; targetObjectNameList[i].Value = t.Substring(index); targetObjectNameList[i].Value = targetObjectNameList[i].Value.Remove(0, 1); } else { int index = targetObjectNameList[i].Index + targetObjectNameList[i].Key.Length; int size = targetObjectNameList[i + 1].Index - targetObjectNameList[i].Index - targetObjectNameList[i].Key.Length; string newValue = t.Substring(index, size); newValue = newValue.Remove(0, 1); newValue = newValue.Remove(newValue.Length - 1, 1); targetObjectNameList[i].Value = newValue; } } T newObject = System.Activator.CreateInstance<T>(); newObject.GetType().GetProperties().ToList().ForEach(o => { var objValue = targetObjectNameList.Where(s => s.Key == o.Name).Select(s => s.Value).FirstOrDefault(); o.SetValue(newObject, objValue); }); output.Add(newObject); }); return output; } /// <summary> /// 获取对象属性名称列表 /// </summary> /// <typeparam name="T"></typeparam> /// <returns></returns> private static List<KeyValueClasss> GetTNameList<T>() { var output = new List<KeyValueClasss>(); var ropertyInfoArray = (typeof(T)).GetProperties(); ropertyInfoArray.ToList().ForEach(t => { output.Add(new KeyValueClasss { Key = t.Name }); }); return output; } /// <summary> /// 过滤字符串 /// </summary> /// <param name="strData"></param> /// <returns></returns> private static string FormatString(string strData) { if (string.IsNullOrEmpty(strData)) return string.Empty; ///过滤空格、换行符 strData = strData.Replace("\n", "").Replace(" ", "").Replace("\t", "").Replace("\r", ""); ///去掉行首2字符 即"[{" strData = strData.Substring(2); ///去掉行尾2字符 即"}]" strData = strData.Substring(0, strData.Length - 2); return strData; } } /// <summary> /// 键值对类 /// </summary> internal class KeyValueClasss { public string Key { get; set; } public int Index { get; set; } public string Value { get; set; } } }
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Text.RegularExpressions; using System.Threading.Tasks; namespace StringToObject { class Program { static void Main(string[] args) { string strData = @"[{material_number=04.04.09.001.0398, material_model=WYD33W04-2200, qty=128, entry_id=frpbjbgpQheLY3CkGASZEiYEHMU=, material_name=浴霸2200W, totalReceiptQty=0}, {material_number=04.04.09.001.0399, material_model=WYD36W05-2200, qty=3332, entry_id=hTuWOEN2SAmasjdHve10syYEHMU=, material_name=浴霸2200W, totalReceiptQty=40}, {material_number=04.04.09.001.0400, material_model=WYD36W05-2400, qty=1000, entry_id=EUqVAulQQDidTA+N1RBQnSYEHMU=, material_name=浴霸2400W, totalReceiptQty=40}, {material_number=04.04.09.001.0401, material_model=WYD36W05-2600, qty=660, entry_id=D/NFnu3dTZGlzO16K6ThDSYEHMU=, material_name=浴霸2600W, totalReceiptQty=40}, {material_number=04.04.09.001.0407, material_model=WYD36W11-2600, qty=200, entry_id=Ut5TcbHCQc602ibG0na7tiYEHMU=, material_name=浴霸2600W, totalReceiptQty=40}, {material_number=04.04.09.001.0404, material_model=WYD36S08-1200, qty=1660, entry_id=YP/F0BgQT1+NA2QXEovgmSYEHMU=, material_name=浴霸1200W, totalReceiptQty=0}, {material_number=04.04.09.001.0405, material_model=WYD33X09-35, qty=300, entry_id=P6BSIaibSLeoNyRwafiBkiYEHMU=, material_name=凉霸35W, totalReceiptQty=0}, {material_number=04.04.09.001.0406, material_model=WYD33X10-40, qty=2000, entry_id=a+Yr0Ep8QWWPha7p36mmnSYEHMU=, material_name=换气扇40W, totalReceiptQty=0}]"; //strData = @"[{ //orderCustomerNnumber=01.008.0001, //material_number=01.01.21.050.0579, //material_model=T=0.3锰钢 表面:镀镍 26*10*8.5mm 图号:CMLS-MT5X06-009, //qty=1500, //orderCustomerName=华东零星客户, //entry_id=6GBFaZ78TjikdC/OjvLwA8z9SSM=, //material_name=挂板, //shippedQty=1500 //}, {orderCustomerNnumber=01.008.0001, material_number=01.02.12.001.0080, material_model=十字沉头4*20AN铁镀锌Rohs, qty=1500, orderCustomerName=华东零星客户, entry_id=E/u2J7tGR7m1zdz/tCKk4cz9SSM=, material_name=螺丝, shippedQty=1500}]"; //strData = @"[{orderCustomerNnumber=01.008.0001, material_number=01.02.13.070.3045, material_model=10W光面球泡-商超版彩盒-6500K-350G灰底白板,尺寸62*62*115,WA2W21-10-886E-02-SC, qty=3000, orderCustomerName=华东零星客户, entry_id=jOgMCPN/TP2nY170m1XU8sz9SSM=, material_name=内盒, shippedQty=3000}]"; List<TestClass> ttt = XmlHelper.GetObjectListFormString<TestClass>(strData); Console.WriteLine(strData); Console.ReadLine(); } } public class TestClass { public string MATerial_number { get; set; } public string material_model { get; set; } public string qty { get; set; } //public string entry_id { get; set; } //public string material_name { get; set; } ////public string totalReceiptQty { get; set; } //public string orderCustomerNnumber { get; set; } //public string orderCustomerName { get; set; } //public string shippedQty { get; set; } //public string sadfsaf { get; set; } } }