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;
}
