/// <summary>
/// 获取所有装修信息
/// </summary>
public void GetCenterBuidingDetailList()
{
int pageIndex = string.IsNullOrEmpty(context.Request["pageIndex"]) ? 1 : Convert.ToInt32(context.Request["pageIndex"]);
int PageSize = Convert.ToInt32(context.Request["PageSize"]);
string UserID = context.Request["UserID"];
string WorkerID = context.Request["WorkerID"];
string SortOrder = context.Request["SortOrder"];
string DemandID = context.Request["DemandID"];
string SortParameters = "";
int pageCount = 0;
int recordcount = 0;
string SelectParameters = string.Format("[BuidingID],[BuidingTitle],[BuidingBrief],[BuidingInfo],"
+ "[CompanyID],[WorkerID],[thumbnailImage],[BuidingImage],[ShowOrder],[AddOn],[EditOn],[DeleteOn],"
+ "[FlagDelete],[PageViewCount],[CollectCount],[ZanCount],[CommentCount],[IsHot],[IsTop],[Price],[Space],"
+ "[constructionstageID],[constructionstage],[ResultID],[StartTime],[StageNow],[EndTime],"
+ "[superviseName],[UserID],[DemandID],[IsWorkerEnd],[IsUserEnd],[Guid]");
SortParameters = string.Format(" FlagDelete=0 {0} {1}",
UserID == "0" || string.IsNullOrEmpty(UserID) ? "" : "and UserID=" + UserID,
WorkerID == "0" || string.IsNullOrEmpty(WorkerID) ? "" : "and WorkerID=" + WorkerID,
string.IsNullOrEmpty(DemandID) ? "" : "and DemandID!=0");
Pagination paginfo = new Pagination();
paginfo.SelectParameters = SelectParameters;
paginfo.PageIndex = pageIndex;
paginfo.PageSize = PageSize;
paginfo.EntityName = "WebBuiding";
paginfo.SortParameters = SortParameters;
paginfo.SortOrder = SortOrder + " AddOn desc,BuidingID desc";
var result = PageList.GetPageListBySQL <WebBuiding>(paginfo, out recordcount, out pageCount);
List <BuidingDetail> list = new List <BuidingDetail>();
foreach (var item in result)
{
BuidingDetail detail = new BuidingDetail
{
woker = worser.GetWebWorkerByID(item.WorkerID),
buiding = item,
stagelist = SageSer.GetStagesWorkerListByID(item.BuidingID),
demand = demandSer.GetDecDemandByGuID(item.Guid),
comment = commentSer.GetCommentByTypeAndID("WebBuiding", item.BuidingID)
};
list.Add(detail);
}
var obj = new
{
list = list,
recordcount = recordcount,
pageCount = pageCount
};
string msg = JsonConvert.SerializeObject(obj);
context.Response.Write(msg);
}
