//发布
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");
}
