public string GetProductTags()
{
string keyword = tools.CheckStr(Request["keyword"]);
int tag_isactive = tools.CheckInt(Request["tag_isactive"]);
QueryInfo Query = new QueryInfo();
Query.PageSize = tools.CheckInt(Request["rows"]);
Query.CurrentPage = tools.CheckInt(Request["page"]);
if (tag_isactive == 1)
{
Query.ParamInfos.Add(new ParamInfo("AND", "int", "ProductTagInfo.Product_Tag_IsActive", "=", "1"));
}
else if (tag_isactive == 2)
{
Query.ParamInfos.Add(new ParamInfo("AND", "int", "ProductTagInfo.Product_Tag_IsActive", "=", "0"));
}
if (keyword.Length > 0)
{
Query.ParamInfos.Add(new ParamInfo("AND", "str", "ProductTagInfo.Product_Tag_Name", "like", keyword));
}
Query.ParamInfos.Add(new ParamInfo("AND", "str", "ProductTagInfo.Product_Tag_Site", "=", Public.GetCurrentSite()));
Query.OrderInfos.Add(new OrderInfo(tools.CheckStr(Request["sidx"]), tools.CheckStr(Request["sord"])));
PageInfo pageinfo = MyBLL.GetPageInfo(Query, Public.GetUserPrivilege());
IList <ProductTagInfo> entitys = MyBLL.GetProductTags(Query, Public.GetUserPrivilege());
if (entitys != null)
{
StringBuilder jsonBuilder = new StringBuilder();
jsonBuilder.Append("{\"page\":" + pageinfo.CurrentPage + ",\"total\":" + pageinfo.PageCount + ",\"records\":" + pageinfo.RecordCount + ",\"rows\"");
jsonBuilder.Append(":[");
foreach (ProductTagInfo entity in entitys)
{
jsonBuilder.Append("{\"ProductTagInfo.Product_Tag_ID\":" + entity.Product_Tag_ID + ",\"cell\":[");
//各字段
jsonBuilder.Append("\"");
jsonBuilder.Append(entity.Product_Tag_ID);
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
jsonBuilder.Append(Public.JsonStr(entity.Product_Tag_Name));
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
if (entity.Product_Tag_IsActive == 1)
{
jsonBuilder.Append("启用");
}
else
{
jsonBuilder.Append("关闭");
}
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
if (Public.CheckPrivilege("2fea26b6-bbb2-44d8-9b46-0b1aed1cc47f"))
{
jsonBuilder.Append("<img src=\\\"/images/icon_edit.gif\\\"> <a href=\\\"tag_edit.aspx?product_tag_id=" + entity.Product_Tag_ID + "\\\" title=\\\"修改\\\">修改</a>");
}
if (Public.CheckPrivilege("7b8b58e2-e509-4e6c-a68e-0361225cefa6"))
{
jsonBuilder.Append(" <img src=\\\"/images/icon_edit.gif\\\"> <a href=\\\"javascript:void(0);\\\" onclick=\\\"confirmdelete('tag_do.aspx?action=move&product_tag_id=" + entity.Product_Tag_ID + "')\\\" title=\\\"删除\\\">删除</a>");
}
jsonBuilder.Append("\",");
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
return(jsonBuilder.ToString());
}
else
{
return(null);
}
}
public void GetProductTags()
{
string keyword = tools.CheckStr(Request["keyword"]);
int tag_isactive = tools.CheckInt(Request["tag_isactive"]);
int i = 0;
string Pageurl;
int curpage = tools.CheckInt(tools.NullStr(Request["page"]));
Pageurl = "?action=list";
if (curpage < 1)
{
curpage = 1;
}
QueryInfo Query = new QueryInfo();
Query.PageSize = 10;
Query.CurrentPage = curpage;
if (tag_isactive == 1)
{
Query.ParamInfos.Add(new ParamInfo("AND", "int", "ProductTagInfo.Product_Tag_IsActive", "=", "1"));
}
else if (tag_isactive == 2)
{
Query.ParamInfos.Add(new ParamInfo("AND", "int", "ProductTagInfo.Product_Tag_IsActive", "=", "0"));
}
if (keyword.Length > 0)
{
Query.ParamInfos.Add(new ParamInfo("AND", "str", "ProductTagInfo.Product_Tag_Name", "like", keyword));
}
//Query.ParamInfos.Add(new ParamInfo("AND", "str", "ProductTagInfo.Product_Tag_Site", "=", pub.GetCurrentSite()));
Query.ParamInfos.Add(new ParamInfo("AND", "int", "ProductTagInfo.Product_Tag_SupplierID", "=", tools.NullInt(Session["supplier_id"]).ToString()));
Query.OrderInfos.Add(new OrderInfo("ProductTagInfo.Product_Tag_ID", "DESC"));
//Response.Write("<table class=\"commontable\">");
//Response.Write("<tr>");
Response.Write("<table width=\"973\" cellpadding=\"0\" align=\"center\" cellspacing=\"2\" class=\"table02\" >");
Response.Write("<tr>");
Response.Write(" <td width=\"300\" class=\"name\">标签名称</td>");
Response.Write(" <td width=\"223\" class=\"name\">启用</td>");
Response.Write(" <td width=\"225\" class=\"name\">排序</td>");
Response.Write(" <td width=\"225\" class=\"name\">操作</td>");
Response.Write("</tr>");
IList <ProductTagInfo> entitys = MyBLL.GetProductTags(Query, pub.CreateUserPrivilege("ed87eb87-dade-4fbc-804c-c139c1cbe9c8"));
PageInfo page = MyBLL.GetPageInfo(Query, pub.CreateUserPrivilege("ed87eb87-dade-4fbc-804c-c139c1cbe9c8"));
if (entitys != null)
{
foreach (ProductTagInfo entity in entitys)
{
i++;
if (i % 2 == 0)
{
Response.Write("<tr class=\"bg\" >");
}
else
{
Response.Write("<tr>");
}
Response.Write("<td>" + entity.Product_Tag_Name + "</td>");
Response.Write("<td>");
if (entity.Product_Tag_IsActive == 1)
{
Response.Write("启用");
}
else
{
Response.Write("关闭");
}
Response.Write("</td>");
Response.Write("<td>");
Response.Write(entity.Product_Tag_Sort);
Response.Write("</td>");
Response.Write("<td>");
Response.Write("<span><a href=\"/supplier/tag_edit.aspx?product_tag_id=" + entity.Product_Tag_ID + "\" class=\"a12\">修改</a></span>");
Response.Write(" <span><a href=\"/supplier/tag_do.aspx?action=del&product_tag_id=" + entity.Product_Tag_ID + "\">删除</a></span>");
Response.Write("</td>");
Response.Write("</tr>");
}
Response.Write("</table>");
pub.Page(page.PageCount, page.CurrentPage, Pageurl, page.PageSize, page.RecordCount);
}
else
{
Response.Write("<table width=\"973\" cellpadding=\"0\" align=\"center\" cellspacing=\"2\" class=\"table02\" >");
Response.Write("<tr><td colspan=\"4\" align=\"center\" >没有记录</td></tr>");
Response.Write("</table>");
}
}
