//-----------------------------------------------------------------------------------------------------------// //-----------------------------------------------------------------------------------------------------------// //-----------------------------------------------------------------------------------------------------------// //-----------------------------------------------------------------------------------------------------------// //-----------------------------------------------------------------------------------------------------------// void update_number_shop(decimal id_product, decimal count) { Product ac = new Product(); ProductDatum dm = new ProductDatum(); dm.Number_Shop = count; dm.Id = id_product; ac.Update_Number_Shop(dm); }
//---------------------------------------Delete --------------------------------------------------- protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { Product ac2 = new Product(); ProductDatum dm2 = new ProductDatum(); string id = ((Label)(GridView1.Rows[e.RowIndex].FindControl("Lblid"))).Text; dm.Id = decimal.Parse(id); dm2.Id_Group = dm.Id; if (ac.SelectAll(dm).Rows.Count == 0 && ac2.Select_Product_Group_Node(dm2).Rows.Count == 0) { ac.Delete(dm); Cancel(); FillGrid(); } else { Label3.Visible = true; } }
void fillgrid() { Product ac = new Product(); ProductDatum dm = new ProductDatum(); dm.Title = TextBox1.Text; dm.Id_State = decimal.Parse(DropDownList1.SelectedValue); decimal price1 = 0; decimal price2 = 999999999; if (TextBox3.Text.Length > 0) { price1 = decimal.Parse(TextBox3.Text); } if (TextBox4.Text.Length > 0) { price2 = decimal.Parse(TextBox4.Text); } GridView1.DataSource = ac.Select_Product_Search(dm, price1, price2); GridView1.DataBind(); }
//---------------------------------------------------------------------------------------------- protected void LinkButton1_Click(object sender, EventArgs e) { StreamWriter asw = new StreamWriter(Server.MapPath("~//administrator//files//Web.sitemap"), false, System.Text.Encoding.UTF8); asw.Write(""); asw.Close(); string p = ""; string title = ""; string desc = ""; int i = 0; OneRecord ac2 = new OneRecord(); OneRecordDatum dm2 = new OneRecordDatum(); DataTable dt2; dm2.Type = "MetaTagTitle"; dt2 = ac2.SelectOne(dm2); if (dt2.Rows.Count > 0) { title = dt2.Rows[0]["text"].ToString(); } dm2.Type = "MetaTagDescription"; dt2 = ac2.SelectOne(dm2); if (dt2.Rows.Count > 0) { desc = dt2.Rows[0]["text"].ToString(); } p += "<?xml version='1.0' encoding='utf-8' ?>" + "<siteMap xmlns='http://schemas.microsoft.com/AspNet/SiteMap-File-1.0' >"; p += "<siteMapNode url='~/index.aspx' title='" + title + "' description='" + desc + "' >"; //----------------- title = "ثبت نام سایت"; desc = "در این بخش می توانید با ثبت نام در سایت از امکانات بیشتری بهره مند گردید"; p += "<siteMapNode url='~/index.aspx?Type=UserRegister' title='" + title + "' description='" + desc + "' />"; title = "جستجو پیشرفته"; desc = "در این بخش می توانید با امکانات بیشتری به جستجوی محصول مورد نظر خود بپردازید"; p += "<siteMapNode url='~/index.aspx?Type=Search' title='" + title + "' description='" + desc + "' />"; title = "نقشه سایت"; desc = "در این بخش می توانید با نقشه سایت و امکانات سایت را دسته بندی شده مشاهده نمایید"; p += "<siteMapNode url='~/index.aspx?Type=SiteMap' title='" + title + "' description='" + desc + "' />"; //---------------- Page_Manage ac = new Page_Manage(); Page_ManageDatum dm = new Page_ManageDatum(); dm.Place = "Down"; DataTable dt = ac.Select_User(dm); for (i = 0; i < dt.Rows.Count; i++) { title = dt.Rows[i]["title"].ToString(); desc = dt.Rows[i]["MetaDescription"].ToString(); p += "<siteMapNode url='~/index.aspx?ID_Page=" + dt.Rows[i]["id"].ToString() + "' title='" + title + "' description='" + desc + "' />"; } //--------------- title = "آرشیو صفحات"; desc = "در این بخش می توانید با آرشیو صفحات ثبت شده را مشاهده نمایید"; p += "<siteMapNode url='~/index.aspx?Type=PageArchive' title='" + title + "' description='" + desc + "' >"; dm.Place = "Right"; dt = ac.Select_User(dm); for (i = 0; i < dt.Rows.Count; i++) { title = dt.Rows[i]["title"].ToString(); desc = dt.Rows[i]["MetaDescription"].ToString(); p += "<siteMapNode url='~/index.aspx?ID_Page=" + dt.Rows[i]["id"].ToString() + "' title='" + title + "' description='" + desc + "' />"; } p += "</siteMapNode>"; //--------------- Product_Grouping ac3 = new Product_Grouping(); Product_GroupingDatum dm3 = new Product_GroupingDatum(); dm3.Id = -1; int i2 = 0; int i3 = 0; int i4 = 0; int i5 = 0; int i6 = 0; DataTable dt3; DataTable dt4; DataTable dt5; DataTable dt6; DataTable dtp; Product acp = new Product(); ProductDatum dmp = new ProductDatum(); int j = 0; dt = ac3.SelectAll(dm3); for (i = 0; i < dt.Rows.Count; i++) { title = dt.Rows[i]["Title"].ToString(); desc = dt.Rows[i]["MetaDescription"].ToString(); p += "<siteMapNode url='~/index.aspx?ID_Root=" + dt.Rows[i]["id"].ToString() + "' title='" + title + "' description='" + desc + "' >"; dm3.Id = int.Parse(dt.Rows[i]["id"].ToString()); dt2 = ac3.SelectAll(dm3); for (i2 = 0; i2 < dt2.Rows.Count; i2++) { title = dt2.Rows[i2]["Title"].ToString(); desc = dt2.Rows[i2]["MetaDescription"].ToString(); p += "<siteMapNode url='~/index.aspx?ID_Root=" + dt2.Rows[i2]["id"].ToString() + "' title='" + title + "' description='" + desc + "' >"; dm3.Id = int.Parse(dt2.Rows[i2]["id"].ToString()); dt3 = ac3.SelectAll(dm3); for (i3 = 0; i3 < dt3.Rows.Count; i3++) { title = dt3.Rows[i3]["Title"].ToString(); desc = dt3.Rows[i3]["MetaDescription"].ToString(); p += "<siteMapNode url='~/index.aspx?ID_Root=" + dt3.Rows[i3]["id"].ToString() + "' title='" + title + "' description='" + desc + "' >"; dm3.Id = int.Parse(dt3.Rows[i3]["id"].ToString()); dt4 = ac3.SelectAll(dm3); for (i4 = 0; i4 < dt4.Rows.Count; i4++) { title = dt4.Rows[i4]["Title"].ToString(); desc = dt4.Rows[i4]["MetaDescription"].ToString(); p += "<siteMapNode url='~/index.aspx?ID_Root=" + dt4.Rows[i4]["id"].ToString() + "' title='" + title + "' description='" + desc + "' >"; dm3.Id = int.Parse(dt4.Rows[i4]["id"].ToString()); dt5 = ac3.SelectAll(dm3); for (i5 = 0; i5 < dt5.Rows.Count; i5++) { title = dt5.Rows[i5]["Title"].ToString(); desc = dt5.Rows[i5]["MetaDescription"].ToString(); p += "<siteMapNode url='~/index.aspx?ID_Root=" + dt5.Rows[i5]["id"].ToString() + "' title='" + title + "' description='" + desc + "' >"; dm3.Id = int.Parse(dt5.Rows[i5]["id"].ToString()); dt6 = ac3.SelectAll(dm3); for (i6 = 0; i6 < dt6.Rows.Count; i6++) { title = dt6.Rows[i6]["Title"].ToString(); desc = dt6.Rows[i6]["MetaDescription"].ToString(); p += "<siteMapNode url='~/index.aspx?ID_Root=" + dt6.Rows[i6]["id"].ToString() + "' title='" + title + "' description='" + desc + "' >"; dmp.Id_Group = int.Parse(dt6.Rows[i6]["id"].ToString()); dtp = acp.Select_Product_Group_Node_SiteMap(dmp); for (j = 0; j < dtp.Rows.Count; j++) { title = dtp.Rows[j]["Title"].ToString(); desc = dtp.Rows[j]["MetaDescription"].ToString(); p += "<siteMapNode url='~/index.aspx?ID_Product=" + dtp.Rows[j]["id"].ToString() + "' title='" + title + "' description='" + desc + "' />"; } p += "</siteMapNode>"; } dmp.Id_Group = int.Parse(dt5.Rows[i5]["id"].ToString()); dtp = acp.Select_Product_Group_Node_SiteMap(dmp); for (j = 0; j < dtp.Rows.Count; j++) { title = dtp.Rows[j]["Title"].ToString(); desc = dtp.Rows[j]["MetaDescription"].ToString(); p += "<siteMapNode url='~/index.aspx?ID_Product=" + dtp.Rows[j]["id"].ToString() + "' title='" + title + "' description='" + desc + "' />"; } p += "</siteMapNode>"; } dmp.Id_Group = int.Parse(dt4.Rows[i4]["id"].ToString()); dtp = acp.Select_Product_Group_Node_SiteMap(dmp); for (j = 0; j < dtp.Rows.Count; j++) { title = dtp.Rows[j]["Title"].ToString(); desc = dtp.Rows[j]["MetaDescription"].ToString(); p += "<siteMapNode url='~/index.aspx?ID_Product=" + dtp.Rows[j]["id"].ToString() + "' title='" + title + "' description='" + desc + "' />"; } p += "</siteMapNode>"; } dmp.Id_Group = int.Parse(dt3.Rows[i3]["id"].ToString()); dtp = acp.Select_Product_Group_Node_SiteMap(dmp); for (j = 0; j < dtp.Rows.Count; j++) { title = dtp.Rows[j]["Title"].ToString(); desc = dtp.Rows[j]["MetaDescription"].ToString(); p += "<siteMapNode url='~/index.aspx?ID_Product=" + dtp.Rows[j]["id"].ToString() + "' title='" + title + "' description='" + desc + "' />"; } p += "</siteMapNode>"; } dmp.Id_Group = int.Parse(dt2.Rows[i2]["id"].ToString()); dtp = acp.Select_Product_Group_Node_SiteMap(dmp); for (j = 0; j < dtp.Rows.Count; j++) { title = dtp.Rows[j]["Title"].ToString(); desc = dtp.Rows[j]["MetaDescription"].ToString(); p += "<siteMapNode url='~/index.aspx?ID_Product=" + dtp.Rows[j]["id"].ToString() + "' title='" + title + "' description='" + desc + "' />"; } p += "</siteMapNode>"; } dmp.Id_Group = int.Parse(dt.Rows[i]["id"].ToString()); dtp = acp.Select_Product_Group_Node_SiteMap(dmp); for (j = 0; j < dtp.Rows.Count; j++) { title = dtp.Rows[j]["Title"].ToString(); desc = dtp.Rows[j]["MetaDescription"].ToString(); p += "<siteMapNode url='~/index.aspx?ID_Product=" + dtp.Rows[j]["id"].ToString() + "' title='" + title + "' description='" + desc + "' />"; } p += "</siteMapNode>"; } //--------------- p += "</siteMapNode></siteMap>"; File.AppendAllText(Server.MapPath("~//administrator//files//Web.sitemap"), p, System.Text.Encoding.UTF8); Response.Redirect("index.aspx"); }
private void FillPath() { lblPath.Text = ""; if (Request.QueryString["ID_Root"] != null && Request.QueryString["ID_Root"].Length > 0) { if (Request.QueryString["ID_Root"] != "-1") { dm.Id = int.Parse(Request.QueryString["ID_Root"]); DataTable dt = ac.SelectOne(dm); string delimitedInfo = dt.Rows[0]["Path"].ToString(); string[] discreteInfo = delimitedInfo.Split(new char[] { ',' }); string title = ""; DataTable dt2 = new DataTable(); foreach (string Data in discreteInfo) { if (Data == "-1") { title = "صفحه اصلی"; } else { dm.Id = int.Parse(Data); dt2 = ac.SelectOne(dm); if (dt2.Rows.Count > 0) { title = dt2.Rows[0]["Title"].ToString(); } } lblPath.Text = lblPath.Text + "<a href='./index.aspx?Type=ProductCategory&ID_Root=" + Data + "'>" + title + "</a>" + "<img src='./Administrator/files/Design/arrow_rtl.png' class='PathArrow'/>"; } lblPath.Text = lblPath.Text + "<a href='./index.aspx?Type=ProductCategory&ID_Root=" + dt.Rows[0]["ID"].ToString() + "'>" + dt.Rows[0]["Title"].ToString() + "</a>" + "<img src='./Administrator/files/Design/arrow_rtl.png' class='PathArrow'/>"; } else { lblPath.Text = lblPath.Text + "<a href='./index.aspx'>صفحه اصلی</a><img src='./Administrator/files/Design/arrow_rtl.png' class='PathArrow'/>"; } } else { lblPath.Text = lblPath.Text + "<a href='./index.aspx'>صفحه اصلی</a><img src='./Administrator/files/Design/arrow_rtl.png' class='PathArrow'/>"; } if (Request.QueryString["ID_Product"] != null) { Product ac3 = new Product(); ProductDatum dm3 = new ProductDatum(); dm3.Id = decimal.Parse(Request.QueryString["ID_Product"]); DataTable dt3 = ac3.Select_Product_One(dm3); if (dt3.Rows.Count > 0) { lblPath.Text = lblPath.Text + "<a href='./index.aspx?ID_Product=" + Request.QueryString["ID_Product"] + "&ID_Root=" + dt3.Rows[0]["id_group"].ToString() + "'>" + dt3.Rows[0]["Title"].ToString() + "</a><img src='./Administrator/files/Design/arrow_rtl.png' class='PathArrow'/>"; } else { Response.Redirect("~/index.aspx?Type=404"); } } if (Request.QueryString["ID_Page"] != null) { Page_Manage ac4 = new Page_Manage(); Page_ManageDatum dm4 = new Page_ManageDatum(); dm4.Id = decimal.Parse(Request.QueryString["ID_Page"]); DataTable dt4 = ac4.Select_page_One(dm4); if (dt4.Rows.Count > 0) { lblPath.Text = lblPath.Text + "<a href='./index.aspx?Type=PageArchive'>آرشیو صفحات</a><img src='./Administrator/files/Design/arrow_rtl.png' class='PathArrow'/>" + "<a href='./index.aspx?ID_Page=" + Request.QueryString["ID_Page"] + "'>" + dt4.Rows[0]["Title"].ToString() + "</a><img src='./Administrator/files/Design/arrow_rtl.png' class='PathArrow'/>"; } else { Response.Redirect("~/index.aspx?Type=404"); } } }