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);
}
}
