public void SetProductID(int productID) { _productID = productID; dBPMan.ProductAnanytic.Clear(); DBPManTableAdapters.ProductTableAdapter adt = new DBPManTableAdapters.ProductTableAdapter(); adt.Connection.ConnectionString = Server.ConnectionString; DBPMan.ProductDataTable dt = new DBPMan.ProductDataTable(); adt.FillBy_SelectOne(dt, productID); if (dt.Rows.Count > 0) { nameProduct = dt.Rows[0]["Name"].ToString(); } adt.Dispose(); dt.Dispose(); this.product_KeyComparisonTableAdapter.FillBy_ProductID(dBPMan.Product_KeyComparison, productID); if (dBPMan.Product_KeyComparison.Rows.Count <= 0) { this.dBPMan.Product_KeyComparison.IDProductColumn.DefaultValue = productID; //this.dBPMan.Product_KeyComparison.IDKeySearchColumn.DefaultValue = 0; this.product_KeyComparisonBindingSource.AddNew(); this.product_KeyComparisonBindingSource.EndEdit(); } txttcode.Text = ""; }
private void InitData() { try { DBPManTableAdapters.ProductTableAdapter _productTableAdapter = new DBPManTableAdapters.ProductTableAdapter(); _productTableAdapter.Connection.ConnectionString = QT.Entities.Server.ConnectionString; DBPMan.ProductDataTable productTable = new DBPMan.ProductDataTable(); _productTableAdapter.FillBy_ID(productTable, _productId); if (productTable.Rows.Count != 0) { string imagepath = productTable.Rows[0]["ImagePath"].ToString(); #region Kiểm tran ImagePath //nếu có ImagePath thì hiển thị ảnh #region Có ảnh if (!string.IsNullOrEmpty(imagepath)) { string imgurl = "http://img.websosanh.vn/" + imagepath; pictureBoxProduct.ImageLocation = imgurl; checkEditProduct.Checked = true; } #endregion else { #region Chưa có ảnh - kiểm tra ImageUrls -> Thực hiện download ảnh -> Tự upload ảnh đại diện string imageurls = productTable.Rows[0]["ImageUrls"].ToString(); if (!string.IsNullOrEmpty(imageurls)) { if (Common.UploadImageSPGoc(_productId, _nameProduct, imageurls)) { labelControlProduct.Text = "Upload success!"; } else { labelControlProduct.Text = "Upload fails!"; } } else { labelControlProduct.Text = "ImageUrls ko có. Upload ảnh trực tiếp!"; } #endregion } #region Lấy MapCategory của Product để tạo thư mục int categoryId = QT.Entities.Common.Obj2Int(productTable.Rows[0]["CategoryID"].ToString()); _mapcategoryProduct = GetFilterCategory(categoryId); #endregion } else { richTextBox1.Text = "Xảy ra lỗi, không tìm thấy sản phẩm trong Database!"; } #endregion } catch (Exception ex) { richTextBox1.Text = ex.Message; } }
void doUpdateTongView() { QT.Entities.Product_KeyComparison obj = new Product_KeyComparison(); DBPMan.ProductDataTable dt = new DBPMan.ProductDataTable(); if (chkAll.Checked == true) { this.productTableAdapter.FillBy_AllSPGocValid_orderByLastUpdate(dt, Common.GetIDCompany("quangtrung.vn"), DateTime.Now); } else { this.productTableAdapter.FillBy_CompanyID_Valid_Category(dt, Common.GetIDCompany("quangtrung.vn"), true, Common.Obj2Int(this.iDListClassificationTextBox.Text)); } DBPManTableAdapters.Product_LogsTableAdapter adtLog = new DBPManTableAdapters.Product_LogsTableAdapter(); adtLog.Connection.ConnectionString = QT.Entities.Server.ConnectionString; for (int i = 0; i < dt.Rows.Count; i++) { try { int productid = 0; productid = Common.Obj2Int(dt.Rows[i]["ID"].ToString()); int viewCount = 0; try { viewCount = Common.Obj2Int(adtLog.ScalarQuery_SumCountByProductID_FromDate(productid, DateTime.Now.AddDays(-30))); } catch (Exception) { } int delay = 1000; this.Invoke( (MethodInvoker) delegate { this.laMess1.Text = String.Format("Update thông tin view {0}/{1} sản phẩm: {2}\n Tổng: {3}\n ", i, dt.Rows.Count, dt.Rows[i]["Name"].ToString(), viewCount); delay = Common.Obj2Int(txtDelay.Text.Trim()); }); this.productTableAdapter.UpdateQuery_ViewCount(viewCount, productid); Thread.Sleep(delay); } catch (Exception) { } } adtLog.Dispose(); if (updateFulltextThread != null) { if (updateFulltextThread.IsAlive) { updateFulltextThread.Abort(); updateFulltextThread.Join(); updateFulltextThread = null; } } }
void doUpdateGiaSPGoc() { QT.Entities.Product_KeyComparison obj = new Product_KeyComparison(); DBPMan.ProductDataTable dt = new DBPMan.ProductDataTable(); while (true) { if (chkAll.Checked == true) { this.productTableAdapter.FillBy_AllSPGocValid_orderByLastUpdate(dt, Common.GetIDCompany("quangtrung.vn"), DateTime.Now.AddDays(-1)); } else { this.productTableAdapter.FillBy_CompanyID_Valid_Category(dt, Common.GetIDCompany("quangtrung.vn"), true, Common.Obj2Int(this.iDListClassificationTextBox.Text)); } for (int i = 0; i < dt.Rows.Count; i++) { try { int productid = 0; productid = Common.Obj2Int(dt.Rows[i]["ID"].ToString()); long idSPChuyenSPGoc = Common.Obj2Int64(dt.Rows[i]["ClassificationID"].ToString()); /// Update ProductID của những sản phẩm được chuyển sang làm sản phẩm gốc, ProductID=ClassificationID this.productTableAdapter.UpdateQuery_ProductID(productid, idSPChuyenSPGoc); Product_KeyComparisonEntyties oe = obj.UpdatePriceAndTongSP_ProductAndKeyComparision(productid); int delay = 1000; this.Invoke( (MethodInvoker) delegate { this.laMess1.Text = String.Format("Update thông tin so sánh giá {0}/{1} sản phẩm: {2}\n Tổng: {3}\n PriceMin: {4}\n PriceMax: {5}", i, dt.Rows.Count, dt.Rows[i]["Name"].ToString(), oe.TongSanPham, oe.PriceMin, oe.PriceMax); delay = Common.Obj2Int(txtDelay.Text.Trim()); }); Thread.Sleep(delay); } catch (Exception) { } } if (updateFulltextThread != null) { if (updateFulltextThread.IsAlive) { updateFulltextThread.Abort(); updateFulltextThread.Join(); updateFulltextThread = null; } } } }
private void btUpdateTopGiamGiaTuan_Click(object sender, EventArgs e) { QT.Entities.Product_KeyComparison obj = new Product_KeyComparison(); DBPMan.ProductDataTable dt = new DBPMan.ProductDataTable(); if (chkAll.Checked == true) { this.productTableAdapter.FillBy_AllSPGocValid_orderByLastUpdate(dt, Common.GetIDCompany("quangtrung.vn"), DateTime.Now); } else { this.productTableAdapter.FillBy_CompanyID_Valid_Category(dt, Common.GetIDCompany("quangtrung.vn"), true, Common.Obj2Int(this.iDListClassificationTextBox.Text)); } DBPManTableAdapters.Price_LogsTableAdapter adtLog = new DBPManTableAdapters.Price_LogsTableAdapter(); DBPMan.Price_LogsDataTable dtLog = new DBPMan.Price_LogsDataTable(); adtLog.Connection.ConnectionString = QT.Entities.Server.ConnectionString; for (int i = 0; i < dt.Rows.Count; i++) { int productid = 0; productid = Common.Obj2Int(dt.Rows[i]["ID"].ToString()); int PriceChange = 0; try { adtLog.FillBy_ProductIDFromDate(dtLog, productid, DateTime.Now.AddDays(-7)); if (dtLog.Rows.Count > 0) { DateTime dateUpdate = Common.ObjectToDataTime(dtLog.Rows[0]["DateUpdate"]); if (dateUpdate < DateTime.Now.AddDays(-6)) { int price0 = Common.Obj2Int(dtLog.Rows[0]["NewPrice"].ToString()); int pricen = Common.Obj2Int(dtLog.Rows[dtLog.Rows.Count - 1]["NewPrice"].ToString()); PriceChange = pricen - price0; } } } catch (Exception) { } this.productTableAdapter.UpdateQuery_PriceChangeWeek(PriceChange, productid); this.laMess1.Text = String.Format("Update giá giảm trong tuần {0}/{1} sản phẩm: {2}\n Tổng: {3}\n ", i, dt.Rows.Count, dt.Rows[i]["Name"].ToString(), PriceChange); Application.DoEvents(); } adtLog.Dispose(); }
private void btUpdateTinLienQuan_Click(object sender, EventArgs e) { #region update lại giá, tổng số sản phẩm tìm thấy trong dữ liệu QT.Entities.Product_KeyComparison obj = new Product_KeyComparison(); DBPMan.ProductDataTable dt = new DBPMan.ProductDataTable(); if (chkAll.Checked == true) { this.productTableAdapter.FillBy_AllSPGocValid_orderByLastUpdate(dt, Common.GetIDCompany("quangtrung.vn"), DateTime.Now); } else { this.productTableAdapter.FillBy_CompanyID_Valid_Category(dt, Common.GetIDCompany("quangtrung.vn"), true, Common.Obj2Int(this.iDListClassificationTextBox.Text)); } for (int i = 0; i < dt.Rows.Count; i++) { int productid = 0; productid = Common.Obj2Int(dt.Rows[i]["ID"].ToString()); int tong = obj.UpdateProductIDTinLienQuan(productid); this.laMess1.Text = String.Format("Update tin liên quan {0}/{1} sản phẩm: {2}\n Tổng: {3}\n ", i, dt.Rows.Count, dt.Rows[i]["Name"].ToString(), tong); Application.DoEvents(); } #endregion }
private void btSiteMap_Click(object sender, EventArgs e) { DBPMan.ProductDataTable dt = new DBPMan.ProductDataTable(); DBPMan.Product_PropertiesDataTable dtProperties = new DBPMan.Product_PropertiesDataTable(); DBPManTableAdapters.Product_PropertiesTableAdapter adtProperties = new DBPManTableAdapters.Product_PropertiesTableAdapter(); adtProperties.Connection.ConnectionString = Server.ConnectionString; this.productTableAdapter.FillBy_AllSPGocValid_orderByLastUpdate(dt, Common.GetIDCompany("quangtrung.vn"), DateTime.Now); String xml = ""; xml += "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n"; xml += "<urlset xmlns=\"http://www.sitemaps.org/schemas/sitemap/0.9\">\n"; xml += " <url>\n"; xml += " <loc>http://websosanh.vn/home.htm</loc>\n"; xml += " <changefreq>daily</changefreq>\n"; xml += " <priority>0.8</priority>\n"; xml += " </url>\n"; string f = ""; f += " <url>\n"; f += " <loc>{0}</loc>\n"; f += " <changefreq>daily</changefreq>\n"; f += " <priority>0.8</priority>\n"; f += " </url>\n"; for (int i = 0; i < dt.Rows.Count; i++) { long id = 0; string name = "", url = ""; id = Common.Obj2Int64(dt.Rows[i]["ID"].ToString()); name = dt.Rows[i]["Summary"].ToString(); url = Bussiness.UrlHelper.GetUrlOfProductIDSoSanh(id, name); xml += string.Format(f, url); } dt.Dispose(); xml += "</urlset>\n"; FileLog.WriteText(xml, "sitemap.xml"); }
/// <summary> /// Update lại thời gian cập nhật sản phẩm trên vật giá + giá thấp nhất so sánh trên vật giá /// thông tin id sản phẩm từ vật giá được lưu vào trường ClassificationID /// Update lại giá nhỏ nhất, tổng số sản phẩm tìm thấy trong dữ liệu /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btUpdateGiaSPGoc_Click(object sender, EventArgs e) { DBPMan.ProductDataTable dt = new DBPMan.ProductDataTable(); DBPMan.ProductDataTable dtvatgia = new DBPMan.ProductDataTable(); this.productTableAdapter.FillBy_CompanyID(dt, Common.GetIDCompany("quangtrung.vn")); #region Update lại thông tin trên vật giá for (int i = 0; i < dt.Rows.Count; i++) { long productid = 0; productid = Common.Obj2Int64(dt.Rows[i]["ClassificationID"].ToString()); if (productid == 0) { productid = Common.GetIDProduct(dt.Rows[i]["DetailUrl"].ToString()); } try { this.productTableAdapter.FillBy_Price_LastUpdateByID(dtvatgia, productid); int price = 0; DateTime dtpro = DateTime.Now; if (dtvatgia.Rows.Count > 0) { price = Common.Obj2Int(dtvatgia.Rows[0]["Price"].ToString()); dtpro = Common.ObjectToDataTime(dtvatgia.Rows[0]["LastUpdate"]); } this.productTableAdapter.UpdateQuery_SPGoc(dtpro, price, productid, Common.Obj2Int64(dt.Rows[i]["ID"].ToString())); this.laMess1.Text = String.Format("{0}/{1}", i, dt.Rows.Count); } catch (Exception ex) { this.laMess1.Text = String.Format("Error {0}/{1}{2}", i, dt.Rows.Count, ex); } Application.DoEvents(); } #endregion }
//Không sử dụng nữa 02-12-2015 void doUpdateFulltext() { DBPMan.ProductDataTable dt = new DBPMan.ProductDataTable(); DBPMan.Product_PropertiesDataTable dtProperties = new DBPMan.Product_PropertiesDataTable(); DBPManTableAdapters.Product_PropertiesTableAdapter adtProperties = new DBPManTableAdapters.Product_PropertiesTableAdapter(); adtProperties.Connection.ConnectionString = Server.ConnectionString; if (chkAll.Checked == true) { this.productTableAdapter.FillBy_AllSPGocValid_orderByLastUpdate(dt, Common.GetIDCompany("quangtrung.vn"), DateTime.Now); } else { this.productTableAdapter.FillBy_CompanyID_Valid_Category(dt, Common.GetIDCompany("quangtrung.vn"), true, Common.Obj2Int(this.iDListClassificationTextBox.Text)); } for (int i = 0; i < dt.Rows.Count; i++) { try { long id = 0; int categoryID = 0; string nameCat = ""; id = Common.Obj2Int64(dt.Rows[i]["ID"].ToString()); categoryID = Common.Obj2Int(dt.Rows[i]["CategoryID"].ToString()); var filter = GetFilterCategory(categoryID); nameCat = dt.Rows[i]["CategoryName"].ToString(); //adtProperties.FillBy_FillterByProductID(dtProperties, id); //foreach (DBPMan.Product_PropertiesRow dr in dtProperties) //{ // int proid = Common.Obj2Int(dr.PropertiesID); // int provalue = Common.Obj2Int(dr.PropertiesValueID); // filter += string.Format(" {0}_{1}", proid, provalue); //} //for (int ii = 0; ii < dtProperties.Rows.Count; ii++) //{ // int proid = Common.Obj2Int(dtProperties.Rows[ii]["PropertiesID"].ToString()); // int provalue = Common.Obj2Int(dtProperties.Rows[ii]["PropertiesValueID"].ToString()); // filter += string.Format(" {0}_{1}", proid, provalue); //} string nameFT = Common.UnicodeToKoDauFulltext(dt.Rows[i]["Name"].ToString() + " " + nameCat) + " " + nameCat; var contentft = Common.UnicodeToKoDauFulltext(nameCat) + " " + filter; if (contentft.Contains("c000")) { contentft = contentft; } this.productTableAdapter.UpdateQuery_ContentFT_NameFT_ByID( contentft, nameFT, id); int delay = 1000; this.Invoke( (MethodInvoker) delegate { this.laMess1.Text = String.Format("Update thông tin search {0}/{1} sản phẩm gốc: {2}\n ", i, dt.Rows.Count, dt.Rows[i]["Name"].ToString()); delay = Common.Obj2Int(txtDelay.Text.Trim()); }); contentft = nameFT + " " + filter; if (contentft.Contains("c000")) { contentft = contentft; } this.productTableAdapter.UpdateQuery_ContentFT_CategoryID_ByProductID( contentft, Common.Obj2Int(dt.Rows[i]["CategoryID"]), Common.Obj2Int(id)); Thread.Sleep(delay); } catch (Exception ex) { var error = ex.Message; error += ""; } } dt.Dispose(); if (updateFulltextThread != null) { if (updateFulltextThread.IsAlive) { updateFulltextThread.Abort(); updateFulltextThread.Join(); updateFulltextThread = null; } } }
void doConvertSPGoc() { this.Invoke((MethodInvoker) delegate { this.lamssconvert.Text = "Start convert"; }); DBPManTableAdapters.ProductTableAdapter adtProduct = new DBPManTableAdapters.ProductTableAdapter(); DBPMan.ProductDataTable dtP = new DBPMan.ProductDataTable(); adtProduct.Connection.ConnectionString = Server.ConnectionString; int i = 0; foreach (DBMap.ProductRow dr in dBMap.Product) { //if (Common.Obj2Int64(dr.ProductID) <= 0) //{ //insert to productid // vatgia if ((dBMap.Product.Rows[i]["ImageUrls"].ToString().Trim() != "") //&& (dBMap.Product.Rows[i]["ProductContent"].ToString().Trim().Length > 10) && (dBMap.Product.Rows[i]["ImageUrls"].ToString().Trim() != "")) { int ID = Common.GetID_ProductID(dr.Name, IDCategory); try { string name = dr.Name.Replace("- Thông số kỹ thuật", "").Trim(); string contentft = Common.UnicodeToKoDauFulltext(name + " " + labelControlListIDSearch.Text); if (adtProduct.Connection.State == ConnectionState.Closed) { adtProduct.Connection.Open(); } try { /// check san pham nay da được tạo chưa /// nếu chưa thì insert /// đã có thì update lại thông số kỹ thuật /// dtP = new DBPMan.ProductDataTable(); adtProduct.FillBy_CheckID(dtP, ID); if (dtP.Rows.Count > 0) { //adtProduct.UpdateQuery_SPGoc( // 12, // Common.GetIDCompany("quangtrung.vn"), // DateTime.Now, // dBMap.Product.Rows[i]["ProductContent"].ToString(), // name, // dr.DetailUrl, // dr.ImageUrls, // Common.UnicodeToKoDauFulltext(name), // false, // Common.GetHashNameProduct("quangtrung.vn", name), // "", // IDCategory, // ID); } else { // chuyển sang làm sản phẩm gốc adtProduct.InsertQuery_SPGoc( ID, Common.GetIDCompany("quangtrung.vn"), DateTime.Now, name, dBMap.Product.Rows[i]["ProductContent"].ToString(), name, dr.DetailUrl, dr.ImageUrls, Common.UnicodeToKoDauFulltext(name) + " " + NameCategory + " " + Common.UnicodeToKoDauFulltext(NameCategory), false, Common.GetHashNameProduct("quangtrung.vn", name), "", IDCategory, Common.Obj2Int(dBMap.Product.Rows[i]["Price"].ToString()), dr.ID, // lưu product id vào trường classification vì productid chỉ là kiểu int contentft); LogJobAdapter.SaveLog(JobName.FrmEditeProductByCat_Them_moi_san_pham_goc, "Thêm mới sản phẩm gốc MAP PRODUCT!", ID, (int)JobTypeData.Product); } dtP.Dispose(); List <PropertyEntyties> ls = new List <PropertyEntyties>(); ls = ContentAnalytic.GetListProperties(dBMap.Product.Rows[i]["ProductContent"].ToString().Trim(), dBMap.Product.Rows[i]["DetailUrl"].ToString().Trim()); ContentAnalytic.UpdateContent(ID, ls); } catch (Exception) { // tên sản phẩm trong chuyên mục này đã có } // update lại sản phẩm vừa chuyển đã chuyển adtProduct.UpdateQuery_ProductID(ID, dr.ID); } catch (Exception) { } this.Invoke((MethodInvoker) delegate { this.lamssconvert.Text = string.Format("{0}/{1} - {2}", i, dBMap.Product.Count, dr.Name); }); Application.DoEvents(); adtProduct.Connection.Close(); //String[] images = dBMap.Product.Rows[i++]["Promotion"].ToString().Split('\n'); //if ((images.Length > 0) && (images[0].Trim().Length > 0)) //{ //try //{ // adtID.Insert( // ID, // images[0].ToString(), // IDCategory, // 0, 0, 0, // dr.ProductContent, // dr.DetailUrl, // dr.Name, // dr.NameFT, // Common.Obj2Int(Common.ProductIDStatus.NotValid)); //} //catch (Exception) //{ //} //} } //} i++; } }