public void Create_oil(OilDetail test) { try { _context.OilDetail.Add(test); _context.SaveChanges(); } catch (Exception e) { throw new Exception(); } }
public void Createoil() { try { HttpWebRequest request = (WebRequest.Create(@"https://quality.data.gov.tw/dq_download_json.php?nid=6339&md5_url=a03335ba6b0bead4ec405a69605db65c")) as HttpWebRequest; HttpWebResponse response = request.GetResponse() as HttpWebResponse; //string root = Encoding.UTF8.GetString(request.ToString()); StreamReader sr = new StreamReader(response.GetResponseStream()); string RtvStr = sr.ReadToEnd(); byte[] encodeBytes = Encoding.UTF8.GetBytes(RtvStr); byte[] bConvert = System.Text.UnicodeEncoding.Convert(System.Text.Encoding.UTF8, System.Text.Encoding.Unicode, encodeBytes); string sText = System.Text.Encoding.Unicode.GetString(bConvert); //string root = Encoding.UTF8.GetString(RtvStr.ToArray()); List <oilinResult> roots = JsonConvert.DeserializeObject <List <oilinResult> >(sText); List <OilDetail> root = new List <OilDetail>(); foreach (var i in roots) { root.Add(new OilDetail() { Category = i.型別名稱, Oilnumber = i.產品編號, Oilname = i.產品名稱, Package = i.包裝, Sellto = i.銷售對象, Tradelocate = i.交貨地點, Salesunit = i.計價單位, ReferencePrice = i.參考牌價, BusinessTax = i.營業稅, GoodTax = i.貨物稅, DateTimeOffset = i.牌價生效時間, Remarks = i.備註, }); } foreach (OilDetail oil in root) { Guid g; g = Guid.NewGuid(); OilDetail oilDetail = new OilDetail() { OilId = g, Category = oil.Category, Oilname = oil.Oilname, Oilnumber = oil.Oilnumber, Package = oil.Package, Sellto = oil.Sellto, Salesunit = oil.Salesunit, Remarks = oil.Remarks, ReferencePrice = oil.ReferencePrice, BusinessTax = oil.BusinessTax, GoodTax = oil.GoodTax, DateTimeOffset = oil.DateTimeOffset, Tradelocate = oil.Tradelocate, UpdataTime = DateTime.UtcNow }; ioilDAO.Create_oil(oilDetail); } } catch { throw new Exception(); } }