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 + "】的数据获取成功");
}
}
}
}
