public JsonResult GetAppointList(AppointLogListReq parame)
{
int totalSize = 0;
parame.userId = this.GetLoginUser().UserID;
List <PostManageModel> appointList = new List <PostManageModel>();
appointList = postManageBll.GetAppointLogList(parame, ref totalSize);
List <SiteManage> siteDic = ncBase.CurrentEntities.SiteManage.ToList();
if (appointList != null && appointList.Count > 0)
{
var resultList = appointList.Select(p => new
{
p.Title,
p.HouseID,
AddTime = p.AddTime.ToString(),
p.OrderStatus,
OrderSites = siteDic != null?OrderSitesList(siteDic, p.OrderSites):null,
OrderTime = OrderTimesList(p.OrderTime)
});
return(Json(new { data = resultList, totalSize = totalSize }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { data = new List <PostManageModel>(), totalSize = totalSize }, JsonRequestBehavior.AllowGet));
}
}
public virtual List <PostManageModel> GetAppointLogList(AppointLogListReq parame, ref int totalSize)
{
DbCommand cmd = GetStoredProcCommand("P_Api_GetAppointLogList");
AddInParameter(cmd, "@userId", DbType.Int32, parame.userId);
AddInParameter(cmd, "@time", DbType.Date, parame.time);
AddInParameter(cmd, "@status", DbType.Int32, parame.status);
AddInParameter(cmd, "@tradeType", DbType.Int32, parame.tradeType);
AddInParameter(cmd, "@pi", DbType.Int32, parame.pi);
AddInParameter(cmd, "@ps", DbType.Int32, parame.ps);
AddOutParameter(cmd, "@totalSize", DbType.Int32, 4);
DataSet ds = ExecuteDataSet(cmd);
int.TryParse(cmd.Parameters["@totalSize"].Value.ToString(), out totalSize);
List <PostManageModel> appointList = new List <PostManageModel>();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
return(BuildToModelList(ds.Tables[0].Select()));
}
return(appointList);
}
public virtual List <PostManageModel> GetAppointLogList(AppointLogListReq parame, ref int totalSize)
{
return(postManageDal.GetAppointLogList(parame, ref totalSize));
}
