protected void btnAddDetail_Click(object sender, EventArgs e) { Page.Validate("AddDetail"); if (Page.IsValid) { int id = Detail.Any() ? Detail.Max(row => row.ID) + 1 : 1; Item selectedItem = ItemService.Get(Convert.ToInt32(ddlItem.SelectedValue)); Detail.Add( new PackageDetailViewModel() { ID = id, ItemBarcode = selectedItem.Barcode, ItemDescription = selectedItem.Description, ItemID = selectedItem.ID, Quantity = Convert.ToInt32(txtQuantity.Text), UnitPrice = Convert.ToDecimal(txtUnitPrice.Text), UnitName = selectedItem.UnitName1 }); WebFormHelper.ClearTextBox(txtQuantity, txtUnitPrice); ddlItem.SelectedIndex = 0; gvwDetail.DataSource = Detail; gvwDetail.DataBind(); } }
private void web_DocumentCompleted(object sender, sy.WebBrowserDocumentCompletedEventArgs e) { sy.WebBrowser web = (sy.WebBrowser)sender; if (web.Document != null) { sy.HtmlElementCollection tbs = web.Document.GetElementsByTagName("TABLE"); if (tbs.Count == 8) { sy.HtmlElementCollection trs = tbs[7].GetElementsByTagName("TR"); ArrayList list = new ArrayList(); for (int j = 1; j < trs.Count; j++) { sy.HtmlElementCollection tds = trs[j].GetElementsByTagName("TD"); if (tds.Count == 13) { var bd = new BaseDetail { Time = Pfun.StringtoDatetime1(tds[0].InnerText.Trim(), "MM/dd/yyyy").ToString("yyyyMMdd"), Kp = Pfun.Stringtodouble1(tds[1].InnerText.Trim()), Zg = Pfun.Stringtodouble1(tds[2].InnerText.Trim()), Zd = Pfun.Stringtodouble1(tds[3].InnerText.Trim()), Sp = Pfun.Stringtodouble1(tds[4].InnerText.Trim()), Cjl = Pfun.Stringtodouble1(tds[5].InnerText.Replace(",", "").Trim()), Cjje = Pfun.Stringtodouble1(tds[6].InnerText.Replace(",", "").Trim()), Sdl = Pfun.Stringtodouble1(tds[7].InnerText.Trim()), Sdbl = Pfun.Stringtodouble1(tds[8].InnerText.Replace("%", "").Trim()), S = Pfun.Stringtoint1(tds[9].InnerText), Gdc = Pfun.Stringtodouble1(tds[10].InnerText.Replace("%", "").Trim()), Sz = Pfun.Stringtodouble1(tds[11].InnerText.Trim()), Szl = Pfun.Stringtodouble1(tds[12].InnerText.Replace("%", "").Trim()), }; Detail.Add(bd); list.Add("insert into BaseData_" + Name + "(tradetime,kpjg,zgjg,zdjg,spjg,cjl,cjje,sd,sdbl) " + "values ('" + bd.Time + "'," + bd.Kp + "," + bd.Zg + "," + bd.Zd + "," + bd.Sp + "," + bd.Cjl + "," + bd.Cjje + "," + bd.Sdl + "," + bd.Sdbl + ")"); } } if (list.Count > 0) { if (!DbHelperSqLite.Exists("select count(*) from sqlite_master where type='table' and name='BaseData_" + Name + "'")) { string tableText = (string)DbHelperSqLite.GetSingle("select table_text from need_createtable where Table_name = 'BaseData' Limit 1"); if (tableText == null) { Log.WriteLog("need_createtable表中没有BaseData_表的创建代码"); return; } tableText = tableText.Replace("XX", Name); DbHelperSqLite.ExecuteSql(tableText); } DbHelperSqLite.ExecuteSqlTran(list); if (!DbHelperSqLite.Exists("select count(*) from sqlite_master where type='table' and name='BaseDataReceived_" + Name + "'")) { string tableText = (string)DbHelperSqLite.GetSingle("select table_text from need_createtable where Table_name = 'BaseDataReceived' Limit 1"); if (tableText == null) { Log.WriteLog("need_createtable表中没有BaseDataReceived表的创建代码"); return; } tableText = tableText.Replace("XX", Name); DbHelperSqLite.ExecuteSql(tableText); } if (DbHelperSqLite.Exists("select count(*) from BaseDataReceived_" + Name)) { DbHelperSqLite.ExecuteSql("update BaseDataReceived_" + Name + " set status = 1 where tradedate ='" + DateTime.Now.ToString("yyyyMMdd") + "'"); } else { DbHelperSqLite.ExecuteSql("insert into BaseDatareceived_" + Name + "(tradedate,status) values('" + DateTime.Now.ToString("yyyyMMdd") + "',1) "); } Log.WriteLog("股票【" + Name + "】的数据获取成功"); } } } }