public RESTStatus GetPackages(SQLLib sql, object dummy, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ChangeServerSettings) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
PackageDataList = new PackageDataList();
PackageDataList.Items = new List <FoxSDC_Common.PackageData>();
lock (ni.sqllock)
{
SqlDataReader dr = sql.ExecSQLReader("Select * FROM Packages");
while (dr.Read())
{
PackageData pd = new PackageData();
sql.LoadIntoClass(dr, pd);
PackageDataList.Items.Add(pd);
}
dr.Close();
}
return(RESTStatus.Success);
}
protected void Page_Load(object sender, EventArgs e)
{
string typeid = Request.QueryString["Id"].ToString().Trim();
//分类开始
FillXiaoShuoData();
FillWenYiData();
FillLiShiData();
FillJingJiData();
FillXinLiData();
FillShengHuoData();
FillTongShuData();
FillKeJiData();
FillYuanBanData();
//分类结束
//模糊搜索功能，禁用分类排序功能
if (typeid == "search")
{
LinkButton1.Enabled = false;
LinkButton2.Enabled = false;
LinkButton3.Enabled = false;
LinkButton4.Enabled = false;
try
{
ArrayList allId = (ArrayList)Session["result"];
string pinjie = "";
foreach (object o in allId)
{
pinjie += o.ToString() + ",";
}
pinjie = pinjie.Substring(0, pinjie.Length - 1);
string pinjieSql = "select * from Book where Id in (" + pinjie + ")";
DB db = new DB();
db.LoadExecuteData(pinjieSql);
PackageDataList.DataSource = db.MyDataSet.Tables[0].DefaultView;
PackageDataList.DataKeyField = "Id";
PackageDataList.DataBind();
if (db.MyDataSet.Tables[0].Rows.Count <= 0)
{
Image5.Visible = true;
}
db.OffData();
}
catch
{
Image5.Visible = true;
}
}
else
{
if (!IsPostBack)
{
FillPackageData(typeid, " order by Sales");
}
}
}
//好评填充
protected void FillGoodComment(int id, string sortText)
{
DB db = new DB();
string sql = "select s.* from(select *, row_number() over(partition by Id order by Id) as group_idx from(SELECT top 1000 Book.*, CommentLevel, ReplyNumber FROM Book LEFT JOIN LeaveWord ON Book.Id = LeaveWord.BookID order by CommentLevel " + sortText + ", ReplyNumber " + sortText + ") ta) s where s.group_idx = 1 and BookTypeID = " + id + "order by CommentLevel " + sortText + ", ReplyNumber " + sortText;
if (id == 0)
{
sql = "select s.* from(select *, row_number() over(partition by Id order by Id) as group_idx from(SELECT top 1000 Book.*, CommentLevel, ReplyNumber FROM Book LEFT JOIN LeaveWord ON Book.Id = LeaveWord.BookID order by CommentLevel " + sortText + ", ReplyNumber " + sortText + ") ta) s where s.group_idx = 1 order by CommentLevel " + sortText + ", ReplyNumber " + sortText;
}
if (id > 0 && id < 10)
{
sql = "select s.* from(select *, row_number() over(partition by Id order by Id) as group_idx from(SELECT top 1000 Book.*, CommentLevel, ReplyNumber FROM Book LEFT JOIN LeaveWord ON Book.Id = LeaveWord.BookID order by CommentLevel " + sortText + ", ReplyNumber " + sortText + ") ta) s , (select Id from BookType where ParentID = " + id + ") as typeid where s.group_idx = 1 and typeid.Id = s.BookTypeID order by CommentLevel " + sortText + ", ReplyNumber " + sortText;
}
db.LoadExecuteData(sql);
PackageDataList.DataSource = db.MyDataSet.Tables[0].DefaultView;
PackageDataList.DataKeyField = "Id";
PackageDataList.DataBind();
if (db.MyDataSet.Tables[0].Rows.Count <= 0)
{
Image5.Visible = true;
}
db.OffData();
}
//根据分类填充数据
protected void FillPackageData(string typeid, string sortMethood)
{
DB db = new DB();
string sql = "select * from Book where BookTypeID =" + typeid.ToString().Trim() + sortMethood;
int id = int.Parse(typeid);
if (id == 0)
{
sql = "select * from Book" + sortMethood;
}
if (id > 0 && id < 10)
{
sql = "select * from Book where BookTypeID in (select Id from BookType where ParentID = " + id + ")" + sortMethood;
}
db.LoadExecuteData(sql);
PackageDataList.DataSource = db.MyDataSet.Tables[0].DefaultView;
PackageDataList.DataKeyField = "Id";
PackageDataList.DataBind();
if (db.MyDataSet.Tables[0].Rows.Count <= 0)
{
Image5.Visible = true;
}
db.OffData();
}
