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 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"); }
//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++; } }