/// <summary> /// 配置信息-详细信息 /// </summary> public void GetHtmlSourceDetailsPZ(string strTargerUrl) { string strContex = ReadHTML(strTargerUrl); ConvertPZ convertPZ = new ConvertPZ(); var data = convertPZ.getDetailsPZ(strContex); InsertPZ insertPZ = new InsertPZ(); //insertPZ.InsertDetailsPZ(data); //insertPZ.InsertDBPZ(data); //insertPZ.InsertSingleDBPZ(data); insertPZ.InsertTvpDBPZ(data); }
/// <summary> /// 插入数据库 /// </summary> /// <param name="strLoginUrl"></param> /// <param name="strTargerUrl"></param> /// <param name="data">列表数据</param> public void InsertDataPZ(string strTargerUrl, DataTable data) { string strContex = string.Empty; string msg = string.Empty; int dataCount = data.Rows.Count; InsertPZ insertPZ = new InsertPZ(); ConvertPZ convertPZ = new ConvertPZ(); DataTable dtInsert = new DataTable(); int i = 0; try { for (i = 0; i < dataCount; i++) { if (IsStopped) { string id = data.Rows[i]["PZXLH"].ToString().Trim(); strContex = Tool.ReadHTML(strTargerUrl + id); if (!string.IsNullOrEmpty(strContex)) { var dataDetails = convertPZ.getDetailsPZ(strContex); //insertPZ.InsertDBPZ(dataDetails); if (i == 0) { dtInsert = dataDetails; } else { DataRow dr = dataDetails.Rows[0]; dtInsert.Rows.Add(dr.ItemArray); } } } } if (IsStopped && dtInsert != null && dtInsert.Rows.Count > 0) { insertPZ.InsertDBPZ(dtInsert); LogWrite(string.Format("{0} 插入配置信息数据第{1}页,共{2}条数据", DateTime.Now.ToString("G"), (page).ToString(), dtInsert.Rows.Count.ToString())); } } catch (Exception ex) { msg = string.Format("{0} 正在抓取第{1}页,插入配置信息数据时出错:i={3},{4}", DateTime.Now.ToString("G"), page.ToString(), i.ToString(), ex.Message); LogWrite(msg); } //msg = string.Format("{0} 配置信息数据 插入详细信息{1}条数据", DateTime.Now.ToString("G"), dataCount.ToString()); //LogWrite(msg); }