/// <summary>
/// DataTable转为json
/// </summary>
/// <param name="dt">DataTable</param>
/// <returns>json数据</returns>
public static string ToJson(DataTable dt)
{
List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
try
{
foreach (DataRow dr in dt.Rows)
{
Dictionary<string, object> result = new Dictionary<string, object>();
foreach (DataColumn dc in dt.Columns)
{
result.Add(dc.ColumnName, dr[dc]);
}
list.Add(result);
}
}
catch (Exception ex)
{
LogInfo logInfo = new LogInfo("", "DataTable转为json", "Utility.cs页面的ToJson", ex);
logInfo.CreateExceptionLogFile(ex);
}
return SerializeToJson(list);
}
/// <summary>
/// 获取数据
/// </summary>
strJson += ",{";
strJson += "\"ProductTypeListId\":\"" + ProductTypeListId + "\",";
strJson += "\"CustomerPN\":\"" + CustomerPN + "\",";
strJson += "\"CustomerGroup\":\"" + CustomerGroup + "\",";
strJson += "\"RRDPN\":\"" + RRDPN + "\",";
strJson += "\"ValuationNo\":\"" + ValuationNo + "\",";
strJson += "\"ProductName\":\"" + ProductName + "\",";
strJson += "\"PricingDate\":\"" + PricingDate + "\",";
strJson += "\"StandardUnitPrice\":\"" + StandardUnitPrice + "\",";
strJson += "\"StandardQuantity\":\"" + StandardQuantity + "\",";
strJson += "\"ActualQuantity\":\"" + ActualQuantity + "\",";
strJson += "\"ActualUnitPrice\":\"" + ActualUnitPrice + "\",";
strJson += "\"Currency\":\"" + Currency + "\",";
strJson += "\"GP\":\"" + GP + "\",";
strJson += "\"ActualCOMRate\":\"" + ActualCOMRate + "\",";
strJson += "\"PricingLeadTime\":\"" + PricingLeadTime + "\",";
strJson += "\"EffectiveDate\":\"" + EffectiveDate + "\",";
strJson += "\"ExpiryDate\":\"" + ExpiryDate + "\",";
strJson += "\"WinorLost\":\"" + WinorLost + "\",";
strJson += "\"Reason\":\"" + Reason + "\",";
strJson += "\"ProjectTypeID\":\"" + ProjectTypeID + "\",";
strJson += "\"PriceInformationID\":\"" + ProjectCode + "\",";
strJson += "\"RFQSubmitDate\":\"" + RFQSubmitDate + "\",";
strJson += "\"EvaluationDate\":\"" + EvaluationDate + "\",";
strJson += "\"prcingCh\":\"" + prcingCh + "\"";
strJson += "}";
strJson = strJson.substring(1, strJson.length);
strJson = "[" + strJson + "]";
/// <summary>
/// Json 字符串 转换为 DataTable数据集合
/// </summary>
public static DataTable ToDataTable(string json)
{
DataTable dataTable = new DataTable(); //实例化
DataTable result;
try
{
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
javaScriptSerializer.MaxJsonLength = Int32.MaxValue; //取得最大数值
ArrayList arrayList = javaScriptSerializer.Deserialize<ArrayList>(json);
if (arrayList.Count > 0)
{
foreach (Dictionary<string, object> dictionary in arrayList)
{
if (dictionary.Keys.Count<string>() == 0)
{
result = dataTable;
return result;
}
if (dataTable.Columns.Count == 0)
{
foreach (string current in dictionary.Keys)
{
dataTable.Columns.Add(current, dictionary[current].GetType());
}
}
DataRow dataRow = dataTable.NewRow();
foreach (string current in dictionary.Keys)
{
dataRow[current] = dictionary[current];
}
dataTable.Rows.Add(dataRow); //循环添加行到DataTable中
}
}
}
catch
{
}
result = dataTable;
return result;
}