//发布 public static string ViewTxtList2(int top, int txtNum, int isTime, string chrico, string strWhere, string orderby) { DtCms.BLL.Products bll = new DtCms.BLL.Products(); StringBuilder strTxt = new StringBuilder(); DataSet ds = bll.GetList(top, strWhere, orderby); //如果记录存在 if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr = ds.Tables[0].Rows[i]; strTxt.Append("<li>"); if (isTime == 1) { strTxt.Append("<span>[" + string.Format("{0:MM-dd}", dr["AddTime"]) + "]</span>"); } strTxt.Append(chrico); strTxt.Append("<a target=\"_blank\" title=\"" + dr["Title"].ToString() + "\" href=\"Product_View.aspx?id=" + dr["Id"] + "\">" + StringPlus.CutString(dr["Title"].ToString(), txtNum) + "</a>"); strTxt.Append("</li>"); } } else { strTxt.Append("<div>暂无数据显示...</div>"); } return(strTxt.ToString()); }
//删除 protected void lbtnDel_Click(object sender, EventArgs e) { chkLoginLevel("viewProducts"); DtCms.BLL.Products bll = new DtCms.BLL.Products(); switch (this.prolistview) { case "Txt": for (int i = 0; i < this.rptList1.Items.Count; i++) { int id = Convert.ToInt32(((Label)this.rptList1.Items[i].FindControl("lb_id")).Text); CheckBox cb = (CheckBox)this.rptList1.Items[i].FindControl("cb_id"); if (cb.Checked) { bll.Delete(id); } } break; default: for (int i = 0; i < this.rptList2.Items.Count; i++) { int id = Convert.ToInt32(((Label)this.rptList2.Items[i].FindControl("lb_id")).Text); CheckBox cb = (CheckBox)this.rptList2.Items[i].FindControl("cb_id"); if (cb.Checked) { bll.Delete(id); } } break; } JscriptPrint("批量删除成功啦!", "List.aspx?" + CombUrlTxt(this.classId, this.keywords, this.property) + "page=0", "Success"); }
/// <summary> /// 产品图片列表 /// </summary> /// <param name="top">显示条数</param> /// <param name="txtNum">显示字符,注意一个汉字等于二个字节</param> /// <param name="imgW">预览图宽度</param> /// <param name="imgH">预览图高度</param> /// <param name="strWhere">查询条件</param> /// <param name="orderby">排序条件</param> /// <returns></returns> public static string ViewImgList(int top, int txtNum, int imgW, int imgH, string strWhere, string orderby) { DtCms.BLL.Products bll = new DtCms.BLL.Products(); StringBuilder strTxt = new StringBuilder(); DataSet ds = bll.GetList(top, strWhere, orderby); //如果记录存在 if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr = ds.Tables[0].Rows[i]; strTxt.Append("<li>"); strTxt.Append("<a target=\"_blank\" href=\"Product_View.aspx?id=" + dr["ID"] + "\">"); strTxt.Append("<img src=\"/Tools/Http_ImgLoad.ashx?w=" + imgW + "&h=" + imgH + "&gurl=" + dr["ImgUrl"] + "\" alt=\"" + dr["Title"].ToString() + "\" />"); strTxt.Append("</a>"); strTxt.Append("<span><a target=\"_blank\" title=\"" + dr["Title"].ToString() + "\" href=\"Product_View.aspx?id=" + dr["Id"] + "\">" + StringPlus.CutString(dr["Title"].ToString(), txtNum) + "</a></span>"); strTxt.Append("</li>\n"); } } else { strTxt.Append("<div>暂无数据显示...</div>"); } return(strTxt.ToString()); }
//产品首页图片 public static string ViewTxtList_Image(int top, int txtNum, int isTime, string chrico, string strWhere, string orderby) { DtCms.BLL.Products bll = new DtCms.BLL.Products(); StringBuilder strTxt = new StringBuilder(); DataSet ds = bll.GetList(top, strWhere, orderby); //如果记录存在 if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr = ds.Tables[0].Rows[i]; strTxt.Append("<td style=\"padding-right:35px;\"><table border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\"><tr>\n"); if (isTime == 1) { strTxt.Append("<span>[" + string.Format("{0:MM-dd}", dr["AddTime"]) + "]</span>"); } strTxt.Append(chrico); strTxt.Append("<td align=\"center\" class=\"product\"><A href=\"Product_View.aspx?id=" + dr["Id"] + "\" target=\"_blank\"><img src=\"/Tools/Http_ImgLoad.ashx?w=105&h=120&gurl=" + dr["ImgUrl"] + "\" alt=" + StringPlus.CutString(dr["Title"].ToString(), txtNum) + "\" border=\"0\" /></A></td>"); strTxt.Append("</tr><tr>"); strTxt.Append("<td align=\"center\" height=\"30\" style=\"color:#666666;\">" + StringPlus.CutString(dr["Title"].ToString(), txtNum) + "</td>"); strTxt.Append("</tr></table></td>"); } } else { strTxt.Append("<div>暂无数据显示...</div>"); } return(strTxt.ToString()); }
protected void Page_Load(object sender, EventArgs e) { DtCms.BLL.Products bll = new DtCms.BLL.Products(); //查询分页绑定数据 DataTable dt = bll.GetList("ClassId=79").Tables[0]; int a = dt.Rows.Count; this.Repeater1.DataSource = dt; this.Repeater1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { DtCms.BLL.Products bll = new DtCms.BLL.Products(); //查询分页绑定数据 if (!string.IsNullOrEmpty(Request.QueryString["Id"] + "")) { pro = new DtCms.BLL.Products().GetModel(int.Parse(Request.QueryString["Id"].ToString())); DataTable dt2 = DtCms.DBUtility.DbHelperOleDb.Query("select * from Channel where ClassList like '%,77,%' and ID not in(77)").Tables[0]; this.Repeater2.DataSource = dt2; this.Repeater2.DataBind(); } }
//保存 protected void btnSave_Click(object sender, EventArgs e) { DtCms.BLL.Products bll = new DtCms.BLL.Products(); DtCms.Model.Products model = bll.GetModel(this.Id); model.Title = txtTitle.Text.Trim(); model.Guige = txtGuige.Text.Trim(); model.Xinghao = txtXinghao.Text.Trim(); model.Price = decimal.Parse(txtPrice.Text.Trim()); model.ClassId = int.Parse(ddlClassId.SelectedValue); model.ImgUrl = txtImgUrl.Text.Trim(); model.Content = FCKeditor.Value; model.Click = int.Parse(txtClick.Text.Trim()); model.IsMsg = 0; model.IsTop = 0; model.IsRed = 0; model.IsHot = 0; model.IsSlide = 0; model.IsLock = 0; if (cblItem.Items[0].Selected == true) { model.IsMsg = 1; } if (cblItem.Items[1].Selected == true) { model.IsTop = 1; } if (cblItem.Items[2].Selected == true) { model.IsRed = 1; } if (cblItem.Items[3].Selected == true) { model.IsHot = 1; } if (cblItem.Items[4].Selected == true) { model.IsSlide = 1; } if (cblItem.Items[5].Selected == true) { model.IsLock = 1; } bll.Update(model); JscriptPrint("编辑成功啦!", "List.aspx", "Success"); }
protected void Page_Load(object sender, EventArgs e) { DtCms.BLL.Products bll = new DtCms.BLL.Products(); //查询分页绑定数据 if (!string.IsNullOrEmpty(Request.QueryString["page"] + "")) { page = int.Parse(Request.QueryString["page"].ToString()); back = page - 1; next = page + 1; if (back < 0) { back = 0; } } if (!string.IsNullOrEmpty(Request.QueryString["title"] + "")) { title = " and Title like '%" + Request.QueryString["title"] + "%'"; } if (!string.IsNullOrEmpty(Request.QueryString["type"] + "")) { type = Request.QueryString["type"].ToString(); DataTable dt = bll.GetPageList(15, page, "ClassId not in(78,79) and ClassId=" + Request.QueryString["type"] + title, " ID desc").Tables[0]; this.Repeater1.DataSource = dt; this.Repeater1.DataBind(); } else { DataTable dt = bll.GetPageList(15, page, "ClassId not in(78,79)" + title, " ID desc").Tables[0]; this.Repeater1.DataSource = dt; this.Repeater1.DataBind(); } DataTable dt2 = DtCms.DBUtility.DbHelperOleDb.Query("select * from Channel where ClassList like '%,77,%' and ID not in(77)").Tables[0]; this.Repeater2.DataSource = dt2; this.Repeater2.DataBind(); }
private void RptBind(string strWhere, string orderby) { if (!int.TryParse(Request.Params["page"] as string, out this.page)) { this.page = 0; } DtCms.BLL.Products bll = new DtCms.BLL.Products(); //获得总条数 this.pcount = bll.GetCount(strWhere); if (this.pcount > 0) { this.lbtnDel.Enabled = true; } else { this.lbtnDel.Enabled = false; } if (this.classId > 0) { this.ddlClassId.SelectedValue = this.classId.ToString(); } this.txtKeywords.Text = this.keywords; this.ddlProperty.SelectedValue = this.property; //图表或列表显示 switch (this.prolistview) { case "Txt": this.rptList2.Visible = false; this.rptList1.DataSource = bll.GetPageList(this.pagesize, this.page, strWhere, orderby); this.rptList1.DataBind(); break; default: this.rptList1.Visible = false; this.rptList2.DataSource = bll.GetPageList(this.pagesize, this.page, strWhere, orderby); this.rptList2.DataBind(); break; } }
//赋值操作 private void ShowInfo(int _id) { DtCms.BLL.Products bll = new DtCms.BLL.Products(); DtCms.Model.Products model = bll.GetModel(_id); txtTitle.Text = model.Title; txtGuige.Text = model.Guige; txtXinghao.Text = model.Xinghao; txtPrice.Text = model.Price.ToString(); ddlClassId.SelectedValue = model.ClassId.ToString(); txtImgUrl.Text = model.ImgUrl; FCKeditor.Value = model.Content; txtClick.Text = model.Click.ToString(); if (model.IsMsg == 1) { cblItem.Items[0].Selected = true; } if (model.IsTop == 1) { cblItem.Items[1].Selected = true; } if (model.IsRed == 1) { cblItem.Items[2].Selected = true; } if (model.IsHot == 1) { cblItem.Items[3].Selected = true; } if (model.IsSlide == 1) { cblItem.Items[4].Selected = true; } if (model.IsLock == 1) { cblItem.Items[5].Selected = true; } }
//设置操作 protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e) { int id = Convert.ToInt32(((Label)e.Item.FindControl("lb_id")).Text); DtCms.BLL.Products bll = new DtCms.BLL.Products(); DtCms.Model.Products model = bll.GetModel(id); switch (e.CommandName.ToLower()) { case "ibtnmsg": if (model.IsMsg == 1) { bll.UpdateField(id, "IsMsg=0"); } else { bll.UpdateField(id, "IsMsg=1"); } break; case "ibtntop": if (model.IsTop == 1) { bll.UpdateField(id, "IsTop=0"); } else { bll.UpdateField(id, "IsTop=1"); } break; case "ibtnred": if (model.IsRed == 1) { bll.UpdateField(id, "IsRed=0"); } else { bll.UpdateField(id, "IsRed=1"); } break; case "ibtnhot": if (model.IsHot == 1) { bll.UpdateField(id, "IsHot=0"); } else { bll.UpdateField(id, "IsHot=1"); } break; case "ibtnslide": if (model.IsSlide == 1) { bll.UpdateField(id, "IsSlide=0"); } else { bll.UpdateField(id, "IsSlide=1"); } break; } this.RptBind("Id>0" + CombSqlTxt(this.classId, this.keywords, this.property), "AddTime desc"); }