void CrawSite_CrawInfoEvent(CrawInfoCls CrawInfo) { dbModelDataContext db = new dbModelDataContext(); var iCheck = (from i in db.CRItemPrices where i.SiteCode == CrawInfo.SiteCode && i.ItemSiteCode == CrawInfo.ItemSiteCode select i).ToList(); if (iCheck.Count > 0) { db.CRItemPrices.DeleteAllOnSubmit(iCheck); db.SubmitChanges(); } CRItemPrice iNew = new CRItemPrice(); iNew.SiteCode = CrawInfo.SiteCode; iNew.ItemSiteCode = CrawInfo.ItemSiteCode; iNew.ItemBrand = CrawInfo.ItemBrand; iNew.ItemSiteName = CrawInfo.ItemSiteName; iNew.SiteItemGroup = CrawInfo.SiteItemGroup; iNew.SitePrice = CrawInfo.SitePrice; iNew.UrlCheck = CrawInfo.UrlCheck; iNew.CreateDate = DateTime.Now; iNew.CreateBy = "SoftWare"; db.CRItemPrices.InsertOnSubmit(iNew); db.SubmitChanges(); cr_LogEvent(string.Format("Mã hàng: {0}, giá: {1}, Thương hiệu: {2}", CrawInfo.ItemSiteCode, CrawInfo.SitePrice, CrawInfo.ItemBrand)); }
void frmCrawler_Load(object sender, EventArgs e) { dbModelDataContext db = new dbModelDataContext(); var dtSites = (from s in db.CRSites where s.Active == true select s).ToList(); cboWebpage.Enabled = true; cboWebpage.DataSource = dtSites; cboWebpage.DisplayMember = "SiteUrl"; cboWebpage.ValueMember = "SiteCode"; cboWebpage.Show(); }
public void updateAutor(IEnumerable <autor> a) { using (var db = new dbModelDataContext()) { foreach (var aVM in a) { var mAutor = new autor { id_autor = aVM.id_autor, nombre = aVM.nombre }; db.autor.Attach(mAutor); db.Refresh(System.Data.Linq.RefreshMode.KeepCurrentValues, mAutor); } db.SubmitChanges(); } }
void bw_DoWork(object sender, DoWorkEventArgs e) { dbModelDataContext db = new dbModelDataContext(); var listSites = db.Proc_CRLoadUrlCraw(CurrentSiteCode).ToList(); foreach (var ilink in listSites) { if (GlobalEnv.StopRuning) { break; } listBoxSite.Log(Level.Info, string.Format("Load trang: {0}", ilink.PageUrl)); CrawMain crMain = new CrawMain(ilink.SiteCode, ilink.PageUrl, ilink.SiteItemGroup); crMain.LogEvent += crMain_LogEvent; crMain.Craw(); } }
public IEnumerable <autor> addAutor(IEnumerable <autor> a) { var res = new List <autor>(); using (var db = new dbModelDataContext()) { foreach (var aVM in a) { var mA = new autor { nombre = aVM.nombre }; res.Add(mA); db.autor.InsertOnSubmit(mA); } db.SubmitChanges(); } return(res.ToList()); }
void btnOK_Click(object sender, EventArgs e) { try { string SiteCode = cboWebpage.SelectedValue != null?cboWebpage.SelectedValue.ToString() : string.Empty; dbModelDataContext db = new dbModelDataContext(); var gData = (from d in db.CRItemPrices where d.SiteCode == SiteCode || SiteCode == string.Empty select d).ToList(); btnExport.Enabled = gData.Count > 0; gridData.DataSource = gData; gridData.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }