public void LoadData() { var id = Request.QueryInt("id"); if (id > 0) { if (art.Fill(id)) { art.Click = art.Click.GetInt() + 1; art.Update("id=" + id); if (cate.Fill(art.Fenleiid)) { } else { cate = new Model.TcFenlei() { Name = "" }; } } else { art = new Model.TcArticle(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var id = Request.QueryInt("id"); if (id > 0) { art = BLL.TcArticle.Instance.GetModel(id); if (art != null) { art.Click = art.Click.GetInt() + 1; BLL.TcArticle.Instance.Update(art); var c = BLL.TcChanpin.Instance.GetModelList("articleid=" + id); if (c.Count > 0) { prt = c[0]; } cate = BLL.TcFenlei.Instance.GetModel(art.Fenleiid.GetInt()); if (cate == null) { cate = new Model.TcFenlei(); } } else { art = new Model.TcArticle(); } } } }
protected void aspnetpage_PageChanged(object sender, EventArgs e) { var aspnetpage = sender as Wuqi.Webdiyer.AspNetPager; int cid = Request.QueryString["c"].GetInt(); var where = "types='" + types + "'"; #region 设置条件 if (cid > 0) { where += " and Fenleiid=" + cid; cate = BLL.TcFenlei.Instance.GetModel(cid); if (cate == null) { cate = new Model.TcFenlei(); } } #endregion 设置条件 int currentPage = Request.QueryString["page"].GetInt(); if (currentPage <= 0) { currentPage = 1; } int start = (currentPage - 1) * aspnetpage.PageSize + 1; var sumcount = 0; dt = BLL.BLLP.Instance.Get_Page_List("TcArticle", "id desc", start, aspnetpage.PageSize, where, out sumcount); aspnetpage.RecordCount = sumcount; }
//执行编辑 protected void gvqy_RowUpdating(object sender, GridViewUpdateEventArgs e) { int qyid = gvqy.DataKeys[e.RowIndex][0].GetString().GetInt(); TextBox txtqymc = gvqy.Rows[e.RowIndex].FindControl("txtqymc") as TextBox; TextBox txtqypx = gvqy.Rows[e.RowIndex].FindControl("txtqypx") as TextBox; DropDownList ddlcate = gvqy.Rows[e.RowIndex].FindControl("ddlcate") as DropDownList; BLL.TcFenlei bbk = new BLL.TcFenlei(); Model.TcFenlei mbk = new Model.TcFenlei(); mbk = bbk.GetModel(qyid); mbk.Name = txtqymc.Text.Trim(); mbk.Paixu = txtqypx.Text.GetInt(); mbk.Types = types; var pid = ddlcate.SelectedValue.GetInt(); if (pid != mbk.Pid) { mbk.Pid = pid; } //add 131118 防止死循环 if (pid == mbk.ID) { mbk.Pid = 0; } bbk.Update(mbk); gvqy.EditIndex = -1; BindGridView(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var id = Request.QueryInt("id"); if (id > 0) { img = BLL.TcImage.Instance.GetModel(id); if (img != null) { img.Click = img.Click.GetInt() + 1; BLL.TcImage.Instance.Update(img); cate = BLL.TcFenlei.Instance.GetModel(img.Fenleiid.GetInt()); if (cate == null) { cate = new Model.TcFenlei(); } } else { img = new Model.TcImage(); } } } }
protected void aspnetpage_PageChanged(object sender, EventArgs e) { var aspnetpage = sender as Wuqi.Webdiyer.AspNetPager; int cid = Request.QueryString["c"].GetInt(); var where = "types='" + types + "'"; #region 设置条件 if (cid > 0) { where += " and Fenleiid=" + cid; cate = BLL.TcFenlei.Instance.GetModel(cid); if (cate == null) { cate = new Model.TcFenlei() { Name = "" }; } } #endregion 设置条件 int currentPage = Request.QueryString["page"].GetInt(); if (currentPage <= 0) { currentPage = 1; } int start = (currentPage - 1) * aspnetpage.PageSize + 1; var sumcount = 0; dt = BLL.BLLP.Instance.Get_Page_List("TcArticle", "id desc", start, aspnetpage.PageSize, where, out sumcount); List <string> list = new List <string>(); dt.Columns.Add("shuxing"); foreach (DataRow item in dt.Rows) { list.Add(item["id"].GetString()); } if (list.Count > 0) { string w = string.Join(",", list.ToArray()); DataTable dtcp = BLL.TcChanpin.Instance.GetList("Articleid in(" + w + ")").Tables[0]; foreach (DataRow item in dt.Rows) { DataTable dttmp = dtcp.Where("Articleid=" + item["id"].GetString()); if (dttmp.Rows.Count > 0) { item["shuxing"] = dttmp.Rows[0]["shuxing"].GetString(); } else { item["shuxing"] = ""; } } } aspnetpage.RecordCount = sumcount; }
/// <summary> /// 获取分类model类 /// </summary> /// <param name="bianhao"></param> /// <returns></returns> public static Model.TcFenlei get_fenlei(int id) { var m = new Model.TcFenlei(); var list = get_fenleis().Where(p => p.ID == id).ToList(); if (list.Count > 0) { m = list[0]; } return(m); }
protected void btnAddQY_Click(object sender, EventArgs e) { Model.TcFenlei mzd = new Model.TcFenlei(); BLL.TcFenlei bzd = new BLL.TcFenlei(); mzd.Name = txtqymc.Text.Trim(); mzd.Paixu = txtpx.Text.Trim().GetInt(); mzd.Types = types; mzd.Pid = ddl_cate.SelectedValue.GetInt(); bzd.Add(mzd); txtqymc.Text = ""; txtpx.Text = ""; BindGridView(); }
/// <summary> /// 获取无限级分类 /// </summary> /// <param name="where"></param> /// <returns></returns> public static List <Model.TcFenlei> GetFenlei(string where) { var bll = new Model.TcFenlei(); var list = bll.Select(where + " order by pid,paixu").ToList <Model.TcFenlei>(); var res = new List <Model.TcFenlei>(); foreach (var m in list) { if (res.Count(p => p.ID == m.ID) < 1) { cz(0, m, list, res); } } return(res); }
private static MDataTable get_fenlei_mdt() { var mdt = new MDataTable(); if (HttpContext.Current.Cache[tc_fenlei] == null) { mdt = new Model.TcFenlei().Select("order by Paixu"); HttpContext.Current.Cache.Insert(tc_fenlei, mdt, null, DateTime.Now.AddDays(c_day), TimeSpan.Zero); return(mdt); } else { mdt = HttpContext.Current.Cache[tc_fenlei] as MDataTable; } return(mdt); }
/// <summary> /// /// </summary> /// <param name="len"></param> /// <param name="m"></param> /// <param name="list"></param> /// <param name="res"></param> private static void cz(int len, Model.TcFenlei m, List <Model.TcFenlei> list, List <Model.TcFenlei> res) { var lt = list.Where(p => p.Pid == m.ID); var s = ""; for (var i = 0; i < len; i++) { s += " "; } m.Name = s + m.Name; res.Add(m); foreach (var item in lt) { cz(len + 1, item, list, res); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var id = Request.QueryInt("id"); if (id > 0) { art = BLL.TcArticle.Instance.GetModel(id); if (art != null) { cate = BLL.TcFenlei.Instance.GetModel(art.Fenleiid.GetInt()); if (cate == null) { cate = new Model.TcFenlei(); } } else { art = new Model.TcArticle(); } } } }
protected void aspnetpage_PageChanged(object sender, EventArgs e) { var aspnetpage = sender as Wuqi.Webdiyer.AspNetPager; int cid = Request.QueryString["c"].GetInt(); var where = "types='" + types + "'"; #region 设置条件 if (cid > 0) { where += " and Fenleiid=" + cid; if (cate.Fill(cid)) { } else { cate = new Model.TcFenlei() { Name = "" }; } } #endregion 设置条件 int currentPage = Request.QueryString["page"].GetInt(); if (currentPage <= 0) { currentPage = 1; } var sumcount = 0; dt = new Model.TcArticle().Select(currentPage, aspnetpage.PageSize, where + " order by addtime desc", out sumcount).ToDataTable(); aspnetpage.RecordCount = sumcount; }