/// <summary>
/// 取的我的消息(学生，教练)
/// </summary>
/// <param name="CoachID"></param>
/// <returns></returns>
public IHttpActionResult GetMyNotice(string query)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
Comm.RequestModel.RequestModelBase <Sys.Models.VenueNotice> oData = Newtonsoft.Json.JsonConvert.DeserializeObject <Comm.RequestModel.RequestModelBase <Sys.Models.VenueNotice> >(query);
if (oData.PageIndex < 0 || oData.PageSize <= 0)
{
return(BadRequest());
}
PageCriteria criteria = new PageCriteria();
if (oData.SearchCondition.StudentID > 0)
{
criteria.Condition += string.Format(" state = 1 and((NoticeRange in(4, 5, 6, 7) and StudentID = 0) or StudentID ={0}) ", oData.SearchCondition.StudentID);
}
else
{
if (oData.SearchCondition.CoachID > 0)
{
criteria.Condition += string.Format(" state = 1 and((NoticeRange in(2,3,6,7) and CoachID = 0) or CoachID ={0}) ", oData.SearchCondition.CoachID);
}
}
criteria.CurrentPage = oData.PageIndex;
criteria.Fields = "NoticeId, NoticeType, SendTime, source, NoticeTitle";
criteria.PageSize = oData.PageSize;
criteria.TableName = "VenueNotice";
criteria.PrimaryKey = "NoticeId";
criteria.Sort = "SendTime desc ,NoticeId desc ";
var r = Comm.Helper.DapperHelper.GetPageData <Sys.Models.VenueNotice>(criteria);
return(Ok(new Comm.ResponseModel.ResponseModel4Page <Sys.Models.VenueNotice>()
{
data = r.Items,
recordsFiltered = r.TotalNum,
recordsTotal = r.TotalNum,
}));
}
catch (Exception ex)
{
logs.Error("取的学生的消息", ex);
return(BadRequest());
}
}
public IHttpActionResult Page(string query)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
Comm.RequestModel.RequestModelBase <Sys.Models.Venue> oData = Newtonsoft.Json.JsonConvert.DeserializeObject <Comm.RequestModel.RequestModelBase <Sys.Models.Venue> >(query);
if (oData.PageIndex < 0 || oData.PageSize <= 0)
{
return(BadRequest());
}
PageCriteria criteria = new PageCriteria();
criteria.Condition = "1=1";
if (!string.IsNullOrWhiteSpace(oData.SearchCondition.LinkManMobile))
{
criteria.Condition += string.Format(" and v.LinkManMobile = {0}", oData.SearchCondition.LinkManMobile);
}
if (!string.IsNullOrWhiteSpace(oData.SearchCondition.LinkMan))
{
criteria.Condition += string.Format(" and v.LinkMan like '%{0}%'", oData.SearchCondition.LinkMan);
}
if (!string.IsNullOrWhiteSpace(oData.SearchCondition.VenueName))
{
criteria.Condition += string.Format(" and v.VenueName like '%{0}%'", oData.SearchCondition.VenueName);
}
criteria.CurrentPage = oData.PageIndex + 1;//adminlte 加载的datatable起始页为0
criteria.Fields = "v.[VenueID],v.[CityID],v.[UserName],v.[VenueCode],v.[VenueName],v.[VenueAddress],v.[LinkMan],v.[LinkManMobile],v.[LinkManWX],v.[VenueFax],v.[LegalPerson],v.[CardNumber],v.[AddTime],v.[BusinessLicense],v.[LogoUrl],v.[AddUser],v.[Status],v.[SystemRoleIDS]";
criteria.PageSize = oData.PageSize;
criteria.TableName = "Venue as v";
criteria.PrimaryKey = "v.VenueID";
var r = Comm.Helper.DapperHelper.GetPageData <Sys.Models.Venue>(criteria);
return(Ok(new Comm.ResponseModel.ResponseModel4Page <Sys.Models.Venue>()
{
data = r.Items,
recordsFiltered = r.TotalNum,
recordsTotal = r.TotalNum,
}));
}
catch (Exception ex)
{
logs.Error("场馆查询失败", ex);
return(BadRequest());
}
}
public IHttpActionResult Page(string query)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
Comm.RequestModel.RequestModelBase <Sys.Models.VenueNotice> oData = Newtonsoft.Json.JsonConvert.DeserializeObject <Comm.RequestModel.RequestModelBase <Sys.Models.VenueNotice> >(query);
if (oData.PageIndex < 0 || oData.PageSize <= 0 || oData.SearchCondition == null || oData.SearchCondition.VenueID <= 0)
{
return(BadRequest());
}
try
{
IList <IPredicate> predList = new List <IPredicate>();
predList.Add(Predicates.Field <Sys.Models.VenueNotice>(f => f.VenueID, Operator.Eq, oData.SearchCondition.VenueID));
if (oData.SearchCondition.State > -1)
{
predList.Add(Predicates.Field <Sys.Models.VenueNotice>(f => f.State, Operator.Eq, oData.SearchCondition.State));
}
IPredicateGroup predGroup = Predicates.Group(GroupOperator.And, predList.ToArray());
var result = Comm.Helper.DapperHelper.Instance.GetPage <Sys.Models.VenueNotice>(
predGroup,
new List <ISort>()
{
new Sort {
PropertyName = "NoticeId", Ascending = false
},
},
oData.PageIndex,
oData.PageSize
);
long allRowsCount = Comm.Helper.DapperHelper.Instance.Count <YY.Edu.Sys.Models.VenueNotice>(predGroup);
return(Ok(new Comm.ResponseModel.ResponseModel4Page <YY.Edu.Sys.Models.VenueNotice>()
{
data = result.AsList(),
recordsFiltered = allRowsCount,
recordsTotal = allRowsCount,
}));
}
catch (Exception ex)
{
logs.Error("公告分页查询失败", ex);
return(BadRequest());
}
}
//取得学生的留言信息
public IHttpActionResult GetFeedBackLog(string query)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
Comm.RequestModel.RequestModelBase <Sys.Models.Student> oData = Newtonsoft.Json.JsonConvert.DeserializeObject <Comm.RequestModel.RequestModelBase <Sys.Models.Student> >(query);
if (oData.SearchCondition.StudentID <= 0 || oData.PageIndex < 0 || oData.PageSize <= 0)
{
return(BadRequest());
}
PageCriteria criteria = new PageCriteria();
criteria.Condition += string.Format("StudentID={0}", oData.SearchCondition.StudentID);
criteria.CurrentPage = oData.PageIndex;
criteria.Fields = "* ";
criteria.PageSize = oData.PageSize;
criteria.TableName = "Feedbacklog";
criteria.PrimaryKey = "FDid";
criteria.Sort = "FDid";
var r = Comm.Helper.DapperHelper.GetPageData <FeedBackLog>(criteria);
return(Ok(new Comm.ResponseModel.ResponseModel4Page <FeedBackLog>()
{
data = r.Items,
recordsFiltered = r.TotalNum,
recordsTotal = r.TotalNum,
}));
}
catch (Exception ex)
{
logs.Error("取得学生的留言信息", ex);
return(BadRequest());
}
}
public IHttpActionResult Page4Venue(string query)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
Comm.RequestModel.RequestModelBase <Models.RequestModel.ApplyBuyHoursRequest> oData = Newtonsoft.Json.JsonConvert.DeserializeObject <Comm.RequestModel.RequestModelBase <Models.RequestModel.ApplyBuyHoursRequest> >(query);
if (oData.PageIndex < 0 || oData.PageSize <= 0)
{
return(BadRequest());
}
PageCriteria criteria = new PageCriteria();
criteria.Condition = "1=1";
criteria.Condition += string.Format(" and a.VenueID = {0}", oData.SearchCondition.VenueID);
if (oData.SearchCondition.CoachID > 0)
{
criteria.Condition += string.Format(" and a.CoachID = {0}", oData.SearchCondition.CoachID);
}
if (oData.SearchCondition.StudentID > 0)
{
criteria.Condition += string.Format(" and a.StudentID = {0}", oData.SearchCondition.StudentID);
}
if (oData.SearchCondition.PayState > -1)
{
criteria.Condition += string.Format(" and c.PayState = {0}", oData.SearchCondition.PayState);
}
if (oData.SearchCondition.Status > -1)
{
criteria.Condition += string.Format(" and a.Status = {0}", oData.SearchCondition.Status);
}
if (oData.SearchCondition.PKType > 0)
{
criteria.Condition += string.Format(" and a.PKType = {0}", oData.SearchCondition.PKType);
}
if (!string.IsNullOrEmpty(oData.SearchCondition.StartDate))
{
criteria.Condition += string.Format(" and c.PaySuccessTime >= '{0}'", oData.SearchCondition.StartDate);
}
if (!string.IsNullOrEmpty(oData.SearchCondition.EndDate))
{
criteria.Condition += string.Format(" and c.PaySuccessTime < '{0}'", Convert.ToDateTime(oData.SearchCondition.EndDate).AddDays(1));
}
criteria.CurrentPage = oData.PageIndex + 1;
criteria.Fields = "a.[ApplyID],a.[StudentID],a.[CoachID],a.[ClassNumber],a.[AddTime],a.[PayMoney],a.[Status],a.[PKType],a.[PaidMoney],a.[VenueID],a.[StudentFullName],a.[CoachFullName],s.OpenID,c.PayState,c.PaySuccessTime";
criteria.PageSize = oData.PageSize;
criteria.TableName = "[ApplyBuyHours] as a join Student as s on a.StudentID=s.StudentID left join classhoursorder as c on a.applyid=c.applyid";
criteria.PrimaryKey = "ApplyID";
var r = Comm.Helper.DapperHelper.GetPageData <Models.ResponseModel.ApplyBuyHoursResponse>(criteria);
string sumSql = "SELECT COALESCE(SUM(PaidMoney),0) FROM ApplyBuyHours as a left join classhoursorder as c on a.applyid=c.applyid where " + criteria.Condition;
var sumResult = Comm.Helper.DapperHelper.Instance.Query <decimal>(sumSql);
return(Ok(new Comm.ResponseModel.ResponseModel4Page <Models.ResponseModel.ApplyBuyHoursResponse>()
{
data = r.Items,
recordsFiltered = r.TotalNum,
recordsTotal = r.TotalNum,
SumMoney = sumResult.FirstOrDefault(),
}));
}
catch (Exception ex)
{
logs.Error("缴费记录查询失败", ex);
return(BadRequest());
}
}
public IHttpActionResult GetCoachWages(string query)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
try
{
Comm.RequestModel.RequestModelBase <Models.RequestModel.CoachWageRequest> oData = Newtonsoft.Json.JsonConvert.DeserializeObject <Comm.RequestModel.RequestModelBase <Models.RequestModel.CoachWageRequest> >(query);
if (oData.PageIndex < 0 || oData.PageSize <= 0)
{
return(BadRequest());
}
PageCriteria criteria = new PageCriteria();
criteria.Condition = "1=1";
criteria.Condition += string.Format(" and c.VenueID = {0}", oData.SearchCondition.VenueID);
if (oData.SearchCondition.CoachID > 0)
{
criteria.Condition += string.Format(" and c.CoachID = {0}", oData.SearchCondition.CoachID);
}
if (oData.SearchCondition.State >= 0)
{
criteria.Condition += string.Format(" and c.State = {0}", oData.SearchCondition.State);
}
if (!string.IsNullOrEmpty(oData.SearchCondition.StartWorkDate))
{
criteria.Condition += string.Format(" and c.WorkDate >= '{0}'", Convert.ToDateTime(oData.SearchCondition.StartWorkDate));
}
if (!string.IsNullOrEmpty(oData.SearchCondition.EndWorkDate))
{
criteria.Condition += string.Format(" and c.WorkDate < '{0}'", Convert.ToDateTime(oData.SearchCondition.EndWorkDate).AddMonths(1));
}
criteria.CurrentPage = oData.PageIndex + 1;
criteria.Fields = "[WagesID],[CoachID],[AddTime],[Price],[Remark],[VenueID],[CoachFullName],[WorkDate],State,PayTime";
criteria.PageSize = oData.PageSize;
criteria.TableName = "[CoachWages] as c ";
criteria.PrimaryKey = "c.[WagesID]";
var r = Comm.Helper.DapperHelper.GetPageData <Sys.Models.CoachWages>(criteria);
string sumSql = "SELECT COALESCE(SUM(Price),0) FROM " + criteria.TableName + " where " + criteria.Condition;
var sumResult = DapperHelper.Instance.Query <decimal>(sumSql);
return(Ok(new Comm.ResponseModel.ResponseModel4Page <Sys.Models.CoachWages>()
{
data = r.Items,
recordsFiltered = r.TotalNum,
recordsTotal = r.TotalNum,
SumMoney = sumResult.FirstOrDefault(),
}));
}
catch (Exception ex)
{
logs.Error("查询录入工资异常", ex);
return(BadRequest());
}
}
public IHttpActionResult GetClassOverTeachingSches(string query)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
Comm.RequestModel.RequestModelBase <Sys.Models.TeachingSchedule> oData = Newtonsoft.Json.JsonConvert.DeserializeObject <Comm.RequestModel.RequestModelBase <Sys.Models.TeachingSchedule> >(query);
if (oData.PageIndex < 0 || oData.PageSize <= 0)
{
return(BadRequest());
}
PageCriteria criteria = new PageCriteria();
criteria.Condition = "1=1";
criteria.Condition += string.Format(" and t.State = {0}", Convert.ToInt32(Sys.Models.StateEnum.TeachingSchedule.ClassOverTeachingSche));
if (oData.SearchCondition.VenueID > 0)
{
criteria.Condition += string.Format(" and t.VenueID = {0}", oData.SearchCondition.VenueID);
}
if (oData.SearchCondition.CoachID > 0)
{
criteria.Condition += string.Format(" and t.CoachID = {0}", oData.SearchCondition.CoachID);
}
if (!string.IsNullOrEmpty(oData.SearchCondition.CurriculumBeginTime))
{
criteria.Condition += string.Format(" and t.CurriculumDate >= '{0}'", Convert.ToDateTime(oData.SearchCondition.CurriculumBeginTime));
criteria.Condition += string.Format(" and t.CurriculumDate < '{0}'", Convert.ToDateTime(oData.SearchCondition.CurriculumBeginTime).AddMonths(1));
}
//if (!string.IsNullOrEmpty(oData.SearchCondition.CurriculumEndTime))
// criteria.Condition += string.Format(" and t.CurriculumDate < '{0}'", Convert.ToDateTime(oData.SearchCondition.CurriculumEndTime).AddMonths(1));
criteria.CurrentPage = oData.PageIndex + 1;
criteria.Fields = "c.CurriculumID,t.PKID,t.VenueID,t.CampusID,t.CoachID,t.Title,t.CurriculumDate,t.CurriculumBeginTime,t.CurriculumEndTime,t.AddTime,t.Price,t.CoachPrice,t.PKType,t.State,t.info,t.PurchasePrice,c2.FullName as CoachFullName,c.studentfullname";
criteria.PageSize = oData.PageSize;
criteria.TableName = "Curriculum as c join TeachingSchedule as t on t.pkid = c.pkid join Coach as c2 on t.CoachID = c2.CoachID ";
criteria.PrimaryKey = "c.CurriculumID";
var r = Comm.Helper.DapperHelper.GetPageData <Models.ResponseModel.TeachingScheduleResponse>(criteria);
string sumSql = "SELECT COALESCE(SUM(t.CoachPrice),0) FROM " + criteria.TableName + " where " + criteria.Condition;
var sumResult = Comm.Helper.DapperHelper.Instance.Query <decimal>(sumSql);
return(Ok(new Comm.ResponseModel.ResponseModel4Page <Models.ResponseModel.TeachingScheduleResponse>()
{
data = r.Items,
recordsFiltered = r.TotalNum,
recordsTotal = r.TotalNum,
SumMoney = sumResult.FirstOrDefault(),
}));
}
catch (Exception ex)
{
logs.Error("查询排课详情异常", ex);
return(BadRequest());
}
}
public IHttpActionResult Page4Venue(string query)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
Comm.RequestModel.RequestModelBase <Sys.Models.TeachingSchedule> oData = Newtonsoft.Json.JsonConvert.DeserializeObject <Comm.RequestModel.RequestModelBase <Sys.Models.TeachingSchedule> >(query);
if (oData.PageIndex < 0 || oData.PageSize <= 0)
{
return(BadRequest());
}
PageCriteria criteria = new PageCriteria();
criteria.Condition = "1=1";
if (oData.SearchCondition.VenueID > 0)
{
criteria.Condition += string.Format(" and t.VenueID = {0}", oData.SearchCondition.VenueID);
}
if (oData.SearchCondition.CampusID > 0)
{
criteria.Condition += string.Format(" and t.CampusID = {0}", oData.SearchCondition.CampusID);
}
if (oData.SearchCondition.CoachID > 0)
{
criteria.Condition += string.Format(" and t.CoachID = {0}", oData.SearchCondition.CoachID);
}
if (oData.SearchCondition.State > -1)
{
criteria.Condition += string.Format(" and t.State = {0}", oData.SearchCondition.State);
}
if (oData.SearchCondition.PKType > 0)
{
criteria.Condition += string.Format(" and t.PKType = {0}", oData.SearchCondition.PKType);
}
if (!string.IsNullOrEmpty(oData.SearchCondition.CurriculumBeginTime))
{
criteria.Condition += string.Format(" and t.CurriculumDate >= '{0}'", oData.SearchCondition.CurriculumBeginTime);
}
if (!string.IsNullOrEmpty(oData.SearchCondition.CurriculumEndTime))
{
criteria.Condition += string.Format(" and t.CurriculumDate < '{0}'", Convert.ToDateTime(oData.SearchCondition.CurriculumEndTime).AddDays(1));
}
criteria.CurrentPage = oData.PageIndex + 1;
criteria.Fields = "t.PKID,t.VenueID,t.CampusID,t.CoachID,t.Title,t.CurriculumDate,t.CurriculumBeginTime,t.CurriculumEndTime,t.AddTime,t.Price,t.CoachPrice,t.PKType,t.State,t.Info,t.PurchasePrice,v.VenueName,c.CampusName,c2.FullName as CoachFullName,c3.StudentFullName";
criteria.PageSize = oData.PageSize;
criteria.TableName = "TeachingSchedule as t join Venue as v on t.VenueID=v.VenueID join Campus as c on c.CampusID=t.CampusID join Coach as c2 on t.CoachID=c2.CoachID left join Curriculum as c3 on t.PKID=c3.PKID";
criteria.PrimaryKey = "t.PKID";
var r = Comm.Helper.DapperHelper.GetPageData <Models.ResponseModel.TeachingScheduleResponse>(criteria);
return(Ok(new Comm.ResponseModel.ResponseModel4Page <Models.ResponseModel.TeachingScheduleResponse>()
{
data = r.Items,
recordsFiltered = r.TotalNum,
recordsTotal = r.TotalNum,
}));
}
catch (Exception ex)
{
logs.Error("排课查询失败", ex);
return(BadRequest());
}
}
public IHttpActionResult Page(string query)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
Comm.RequestModel.RequestModelBase <Sys.Models.City> oData = Newtonsoft.Json.JsonConvert.DeserializeObject <Comm.RequestModel.RequestModelBase <Sys.Models.City> >(query);
//System.Web.HttpContextBase context = (System.Web.HttpContextBase)Request.Properties["MS_HttpContext"];//获取传统context
//System.Web.HttpRequestBase request = context.Request;//定义传统request对象
//string name = Comm.Helper.ParamHelper<string>.GetParam(request["cityName"], "");
//int cityId = Comm.Helper.ParamHelper<int>.GetParam(request["cityId"], 0);
//int start = Comm.Helper.ParamHelper<int>.GetParam(request["start"], 0);
//int length = Comm.Helper.ParamHelper<int>.GetParam(request["length"], 0);
if (oData.PageIndex < 0 || oData.PageSize <= 0)
{
return(BadRequest());
}
IList <ISort> sort = new List <ISort>();
sort.Add(new Sort {
PropertyName = "CityID", Ascending = false
});
long allRowsCount = 0;
/*
* GT: Greater Than , >
* GE: Greater than or Equivalent with , >=
* LT: Less than, <
* LE: Less than or Equivalent with, <=
* EQ: EQuivalent with, ==
* NE: Not Equivalent with, /=
*/
/*
* var pg = new PredicateGroup { Operator = GroupOperator.And, Predicates = new List<IPredicate>() };
* pg.Predicates.Add(Predicates.Field<Person>(f => f.Active, Operator.Eq, true));
* pg.Predicates.Add(Predicates.Field<Person>(f => f.LastName, Operator.Like, "Br%"));
* IEnumerable<Person> list = cn.GetList<Person>(pg);
*/
IList <IPredicate> predList = new List <IPredicate>();
if (oData.SearchCondition != null)
{
if (!string.IsNullOrWhiteSpace(oData.SearchCondition.CityName))
{
predList.Add(Predicates.Field <YY.Edu.Sys.Models.City>(f => f.CityName, Operator.Like, "%" + oData.SearchCondition.CityName + "%"));
}
if (oData.SearchCondition.CityID > 0)
{
predList.Add(Predicates.Field <YY.Edu.Sys.Models.City>(f => f.CityID, Operator.Le, oData.SearchCondition.CityID));
}
}
IPredicateGroup predGroup = Predicates.Group(GroupOperator.And, predList.ToArray());
var result = Comm.Helper.DapperHelper.Instance.GetPage <YY.Edu.Sys.Models.City>(predGroup, sort, oData.PageIndex, oData.PageSize);
allRowsCount = Comm.Helper.DapperHelper.Instance.Count <YY.Edu.Sys.Models.City>(predGroup);
return(Ok(new Comm.ResponseModel.ResponseModel4Page <YY.Edu.Sys.Models.City>()
{
data = result.AsList(),
recordsFiltered = allRowsCount,
recordsTotal = allRowsCount,
}));
}
catch (Exception ex)
{
logs.Error("城市分页查询失败", ex);
return(BadRequest());
}
}
public IHttpActionResult Page4VenueIncome(string query)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
Comm.RequestModel.RequestModelBase <Models.RequestModel.ClassHoursDetailedRequest> oData = Newtonsoft.Json.JsonConvert.DeserializeObject <Comm.RequestModel.RequestModelBase <Models.RequestModel.ClassHoursDetailedRequest> >(query);
if (oData.SearchCondition.VenueID <= 0 || oData.PageIndex < 0 || oData.PageSize <= 0)
{
return(BadRequest());
}
PageCriteria criteria = new PageCriteria();
criteria.Condition = "1=1";
criteria.Condition += string.Format(" and c.VenueID = {0}", oData.SearchCondition.VenueID);
//查询购买课时和约课的流水记录
criteria.Condition += string.Format(" and c.DType in ({0}) ", "1,2");
if (oData.SearchCondition.CoachID > 0)
{
criteria.Condition += string.Format(" and c.CoachID = {0}", oData.SearchCondition.CoachID);
}
if (!string.IsNullOrEmpty(oData.SearchCondition.StartDate))
{
criteria.Condition += string.Format(" and AddTime >= '{0}'", oData.SearchCondition.StartDate);
}
if (!string.IsNullOrEmpty(oData.SearchCondition.EndDate))
{
criteria.Condition += string.Format(" and AddTime < '{0}'", Convert.ToDateTime(oData.SearchCondition.EndDate).AddDays(1));
}
criteria.CurrentPage = oData.PageIndex + 1;//adminlte 加载的datatable起始页为0
criteria.Fields = "[DetailedID],[DType],c.[VenueID],c.[CoachID],c.[StudentID],s.FullName as studentfullname,c2.FullName as fullname,c.[AddTime],[Remark],[DNumber],[CMoney],[PKType]";
criteria.PageSize = oData.PageSize;
criteria.TableName = "[dbo].[ClassHoursDetailed] as c left join Student as s on c.studentid=s.studentid left join coach as c2 on c.CoachID=c2.CoachID";
criteria.PrimaryKey = "c.[DetailedID]";
var r = DapperHelper.GetPageData <Models.ResponseModel.ClassHoursDetailedResponse>(criteria);
string sumSql = "SELECT COALESCE(SUM(CMoney),0) FROM " + criteria.TableName + " where " + criteria.Condition;
var sumResult = DapperHelper.Instance.Query <decimal>(sumSql);
return(Ok(new Comm.ResponseModel.ResponseModel4Page <Models.ResponseModel.ClassHoursDetailedResponse>()
{
data = r.Items,
recordsFiltered = r.TotalNum,
recordsTotal = r.TotalNum,
SumMoney = sumResult.FirstOrDefault(),
}));
}
catch (Exception ex)
{
logs.Error("收入流水查询失败", ex);
return(BadRequest());
}
}
public IHttpActionResult Page(string query)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
try
{
Comm.RequestModel.RequestModelBase <Sys.Models.FeedBackLog> oData = Newtonsoft.Json.JsonConvert.DeserializeObject <Comm.RequestModel.RequestModelBase <Sys.Models.FeedBackLog> >(query);
if (oData.PageIndex < 0 || oData.PageSize <= 0 || oData.SearchCondition == null || oData.SearchCondition.VenueID <= 0)
{
return(BadRequest());
}
PageCriteria criteria = new PageCriteria();
criteria.Condition = "1=1";
if (oData.SearchCondition.VenueID > 0)
{
criteria.Condition += string.Format(" and f.VenueID = {0}", oData.SearchCondition.VenueID);
}
if (oData.SearchCondition.StudentID > 0)
{
criteria.Condition += string.Format(" and f.[StudentID] = {0}", oData.SearchCondition.StudentID);
}
if (oData.SearchCondition.State > -1)
{
criteria.Condition += string.Format(" and f.[State] = {0}", oData.SearchCondition.State);
}
//if (!string.IsNullOrEmpty(oData.SearchCondition.UserName))
// criteria.Condition += string.Format(" and c.UserName = '******'", oData.SearchCondition.UserName);
if (!string.IsNullOrEmpty(oData.SearchCondition.FullName))
{
criteria.Condition += string.Format(" and s.FullName like '%{0}%'", oData.SearchCondition.FullName);
}
criteria.CurrentPage = oData.PageIndex + 1;//adminlte 加载的datatable起始页为0
criteria.Fields = "[FDId],f.[UserId],f.[UserName],[FDMsg],f.[AddTime],f.[VenueID],f.[StudentID],s.fullname as [FullName],f.[State],[ReplyMsg],[ReplyTime]";
criteria.PageSize = oData.PageSize;
criteria.TableName = "[dbo].[FeedBackLog] as f join student as s on f.studentid=s.studentid";
criteria.PrimaryKey = "f.[FDId]";
var r = Comm.Helper.DapperHelper.GetPageData <YY.Edu.Sys.Models.FeedBackLog>(criteria);
return(Ok(new Comm.ResponseModel.ResponseModel4Page <YY.Edu.Sys.Models.FeedBackLog>()
{
data = r.Items,
recordsFiltered = r.TotalNum,
recordsTotal = r.TotalNum,
}));
//IList<IPredicate> predList = new List<IPredicate>();
//predList.Add(Predicates.Field<Sys.Models.FeedBackLog>(f => f.VenueID, Operator.Eq, oData.SearchCondition.VenueID));
//if (oData.SearchCondition.StudentID > 0)
// predList.Add(Predicates.Field<Sys.Models.FeedBackLog>(f => f.StudentID, Operator.Eq, oData.SearchCondition.StudentID));
//if (!string.IsNullOrWhiteSpace(oData.SearchCondition.FullName))
// predList.Add(Predicates.Field<Sys.Models.FeedBackLog>(f => f.FullName, Operator.Like, "%" + oData.SearchCondition.FullName + "%"));
//if (oData.SearchCondition.State > 0)
// predList.Add(Predicates.Field<Sys.Models.FeedBackLog>(f => f.State, Operator.Eq, oData.SearchCondition.State));
//IPredicateGroup predGroup = Predicates.Group(GroupOperator.And, predList.ToArray());
//var result = Comm.Helper.DapperHelper.Instance.GetPage<Sys.Models.FeedBackLog>(
// predGroup,
// new List<ISort>() {
// new Sort { PropertyName = "FDId", Ascending = false},
// },
// oData.PageIndex,
// oData.PageSize
//);
//long allRowsCount = Comm.Helper.DapperHelper.Instance.Count<YY.Edu.Sys.Models.FeedBackLog>(predGroup);
//return Ok(new Comm.ResponseModel.ResponseModel4Page<YY.Edu.Sys.Models.FeedBackLog>()
//{
// data = result.AsList(),
// recordsFiltered = allRowsCount,
// recordsTotal = allRowsCount,
//});
}
catch (Exception ex)
{
logs.Error("公告分页查询失败", ex);
return(BadRequest());
}
}
