public string GetDataSetWithParam(DBInfo dbinfo, string cmdText, string[] paraNames, object[] paraValues)
{
var ds = CreateDB(dbinfo).GetDataSet(cmdText, paraNames, paraValues);
var newds = new Data.DataSet(ds);
return(newds.ToString());
}
/// <summary>
/// XML转DATASET
/// </summary>
/// <param name="xml">xml</param>
/// <returns>DATASET</returns>
public static Data.DataSet FromXML(string xml)
{
StringReader stream = null;
XmlTextReader reader = null;
try
{
Data.DataSet xmlDS = new Data.DataSet();
stream = new StringReader(xml);
reader = new XmlTextReader(stream);
xmlDS.ReadXml(reader);
return(xmlDS);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (reader != null)
{
reader.Close();
}
}
}
public string GetDataSet(DBInfo dbinfo, string cmdText)
{
var ds = CreateDB(dbinfo).GetDataSet(cmdText);
var newds = new Data.DataSet(ds);
return(newds.ToString());
}
/// <summary>
/// JSON转DataSet
/// </summary>
/// <param name="Json">JSON串</param>
/// <returns>DataSet</returns>
public static Data.DataSet JsonToDataSet(string Json)
{
try
{
Data.DataSet ds = new Data.DataSet();
JavaScriptSerializer JSS = new JavaScriptSerializer();
object obj = JSS.DeserializeObject(Json);
Dictionary <string, object> datajson = (Dictionary <string, object>)obj;
foreach (var item in datajson)
{
Data.DataTable dt = new Data.DataTable(item.Key);
object[] rows = (object[])item.Value;
foreach (var row in rows)
{
Dictionary <string, object> val = (Dictionary <string, object>)row;
Data.DataRow dr = dt.NewRow();
foreach (KeyValuePair <string, object> sss in val)
{
if (!dt.Columns.Contains(sss.Key))
{
dt.Columns.Add(sss.Key.ToString());
dr[sss.Key] = sss.Value;
}
else
{
dr[sss.Key] = sss.Value;
}
}
dt.Rows.Add(dr);
}
ds.Tables.Add(dt);
}
return(ds);
}
catch
{
return(null);
}
}
public static async Task <Statuses> InsertDataAsync(this IHistoryApi api, GoogleApiClient client, Data.DataSet dataSet)
{
return((await api.InsertData(client, dataSet)).JavaCast <Statuses> ());
}
