示例#1
0
        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");
        }
示例#2
0
        //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;
                }
            }
        }