/// <summary>
/// [main]
/// </summary>
public PageSetting SelPage(int cpage, int psize, Filter_Product filter)
{
string where = "1=1 ";
List <SqlParameter> sp = new List <SqlParameter>();
if (filter.NodeID > 0)
{
string nids = new B_Node().GetChilds(filter.NodeID);
//where += " AND (A.NodeID=" + filter.NodeID + " OR A.FirstNodeID=" + filter.NodeID + ")";
where += " AND A.NodeID IN (" + nids + ")";
}
if (!string.IsNullOrEmpty(filter.NodeIDS))
{
SafeSC.CheckIDSEx(filter.NodeIDS); where += " AND A.NodeID IN (" + filter.NodeIDS + ")";
}
//组合|单品
if (filter.pclass != -100)
{
where += "AND [Class]=" + filter.pclass;
}
//商品分类
if (!string.IsNullOrEmpty(filter.proclass))
{
SafeSC.CheckIDSEx(filter.proclass); where += " AND A.ProClass IN (" + filter.proclass + ")";
}
if (filter.hasRecycle != -100)
{
where += " AND Recycler=" + filter.hasRecycle;
}
if (filter.istrue != -100)
{
where += " AND IsTrue=" + filter.istrue;
}
if (filter.issale != -100)
{
where += " AND Sales=" + filter.issale;
}
//搜索,支持指定条件
//if (!string.IsNullOrEmpty(filter.skey))
//{
// if (string.IsNullOrEmpty(filter.stype)) { filter.stype = "proname"; }
// sp.Add(new SqlParameter("skey", "%" + filter.skey + "%"));
// int sid = DataConverter.CLng(filter.skey);
// switch (filter.stype.ToLower())
// {
// case "id": where += " AND A.ID=" + sid; break;
// case "proname": where += " AND A.Proname LIKE @skey"; break;
// case "id_proname": where += " AND (A.ID=" + sid + " OR A.ProName LIKE @skey)"; break;
// case "adduser": where += " AND A.AddUser LIKE @skey"; break;
// case "storeid": filter.storeid = sid; break;
// }
//}
if (!string.IsNullOrEmpty(filter.proname))
{
sp.Add(new SqlParameter("proname", "%" + filter.proname + "%"));
where += " AND A.Proname LIKE @proname";
}
if (!string.IsNullOrEmpty(filter.adduser))
{
sp.Add(new SqlParameter("adduser", "%" + filter.adduser + "%"));
where += " AND A.AddUser LIKE @adduser";
}
if (filter.special > 0)
{
where += " AND SpecialID LIKE '%," + filter.special + ",%'";
}
//快速筛选
where += GetWhereByType(filter.type);
if (filter.storeid == 0)
{
where += " AND (A.UserShopID=0 OR A.UserShopID IS NULL)";
} //仅商城
else if (filter.storeid > 0)
{
where += " AND A.UserShopID=" + filter.storeid;
} //指定店铺
else if (filter.storeid == -1)
{
where += " AND A.UserShopID>0";
} //仅店铺
else if (filter.storeid == -100)
{
} //全部
string orderBy = StrHelper.SQL_OrderBy(filter.orderBy, "id,linprice", "A.OrderId DESC,A.ID DESC");
PageSetting setting = new PageSetting()
{
cpage = cpage,
psize = psize,
fields = "A.*,B.NodeName,(SELECT Title FROM ZL_CommonModel WHERE GeneralID=A.UserShopID) StoreName",
t1 = TbName,
t2 = "ZL_Node",
on = "A.NodeID=B.NodeID",
where = where,
order = orderBy,
spList = sp
};
DBCenter.SelPage(setting);
return(setting);
}
public DataTable GetProductAll(Filter_Product filter)
{
return(SelPage(1, int.MaxValue, filter).dt);
}
