public string GetCultivateDetail(dynamic requestData)
{
CultivateVisit cuVisit = JsonConvert.DeserializeObject <CultivateVisit>(JsonConvert.SerializeObject(requestData));
//先增加看过数量
db.CultivateVisit.Add(cuVisit);
var sql = string.Format(@"Update CultivateInterflow set VisitCount=VisitCount+1 where CuInterId={0}", cuVisit.CuInterId);
dataContext.ExecuteNonQuery(CommandType.Text, sql);
//查询活动基本信息
var qtest = (from v in db.CultivatePraise
where v.OpenId == cuVisit.OpenId
select v);
var q = (from v in db.CultivateInterflow
join p in qtest on v.CuInterId equals p.CuInterId into temp
from tt in temp.DefaultIfEmpty()
where v.CuInterId == cuVisit.CuInterId
select new
{
CuInterId = v.CuInterId,
CurriculumType = v.CurriculumType,
Url = v.Url,
Introduce = v.Introduce,
CurriculumName = v.CurriculumName,
PraiseCount = v.PraiseCount,
VisitCount = v.VisitCount,
CreateTime = v.CreateTime,
IsPraise = tt.Id == null ? "f" : "t"
}).FirstOrDefault();
//活动下面带的讲师
var qLecturer = (from v in db.Lecturer
where v.CuInterId == cuVisit.CuInterId
select new {
LecturerId = v.LecturerId,
HeadPicUrl = v.HeadPicUrl,
LecturerName = v.LecturerName,
Post = v.Post,
HotelName = v.HotelName
});
return("{\"Cultivate\":" + JsonConvert.SerializeObject(q, DateTimeConvent.DateTimedd()) + ",\"Lecturer\":" + JsonConvert.SerializeObject(qLecturer) + "}");
}
public string GetMySelfFR()
{
try
{
string sql = "select MySelfFRId,FRName,FRPicUrl from MySelfFR where BeginTime<GETDATE() and EndTime>GETDATE() order by CreateTime";
var q = dataContext.ExecuteDataTable(CommandType.Text, sql);
return(JsonConvert.SerializeObject(q, DateTimeConvent.DateTimehh()));
}
catch (Exception)
{
return("No");
}
}
public string GetChefByMBIdCAId(int mbId, int caId)
{
var q = (from v in db.Chef
join p in db.MatchRegion on v.MatchRegionId equals p.MatchRegionId
where v.MemberId == mbId && v.ChefActivityId == caId
select new
{
ChefId = v.ChefId,
MemberId = v.MemberId,
ChefActivityId = v.ChefActivityId,
MatchRegionId = v.MatchRegionId,
AreaName = p.AreaName,
ApplyType = v.ApplyType,
ReferrerName = v.ReferrerName,
Birthday = v.Birthday,
ChefPicUrl = v.ChefPicUrl,
//ChefHotelName = v.ChefHotelName,
ChefHotelPicUrl = v.ChefHotelPicUrl
});
return(JsonConvert.SerializeObject(q, DateTimeConvent.DateTimedd()));
}
public string GetBannerList(int pageIndex, int pageCount)
{
try
{
if (pageIndex < 1)
{
pageIndex = 1;
}
var q = (from v in db.Banner
orderby v.BannerId
select new
{
BannerId = v.BannerId,
BannerType = v.BannerType,
PicUrl = v.PicUrl,
Link = v.Link,
IsDisplay = v.IsDisplay == 1 ? "是" : "否",
PriorityId = v.PriorityId,
});
var count = q.Count();
var lastq = q.OrderBy(v => v.BannerId).Skip((pageIndex - 1) * pageCount).Take(pageCount);
return("{ \"Count\":\"" + count + "\",\"data\":" + JsonConvert.SerializeObject(lastq, DateTimeConvent.DateTimehh()) + "}");
}
catch (Exception)
{
return("No");
}
}
public string GetDishChefComment(int dishId, int index, int pageSize)
{
var q = (from v in db.DishComment
where v.DishId == dishId
select v);
var count = q.Count();
var lastq = q.OrderByDescending(v => v.CreateTime).Skip((index - 1) * pageSize).Take(pageSize);
//查找HotelName
var lastResult = (from v in lastq
join p in db.OpenIdAssociated on v.OpenId equals p.OpenId
join n in db.RegistMember on p.UserId equals n.MemberId
select new
{
HeadPicUrl = v.HeadPicUrl,
MemebName = v.MemberName,
Comment = v.Comment,
CreateTime = v.CreateTime,
HotelName = n.HotelName
});
count = lastResult.Count();
return("{ \"Count\":\"" + count + "\",\"data\":" + JsonConvert.SerializeObject(lastResult, DateTimeConvent.DateTimehh()) + "}");
}
public string AddDishComment(dynamic requestData)
{
try
{
//增加留言
string addDishComment = JsonConvert.SerializeObject(requestData);
DishComment model = JsonConvert.DeserializeObject <DishComment>(addDishComment);
db.DishComment.Add(model);
db.SaveChanges();
var q = (from v in db.DishComment
where v.DishId == model.DishId
select v);
var count = q.Count();
var lastq = q.OrderByDescending(v => v.CreateTime).Skip(0).Take(3);
//查找HotelName
var lastResult = (from v in lastq
join p in db.OpenIdAssociated on v.OpenId equals p.OpenId
join n in db.RegistMember on p.UserId equals n.MemberId
select new
{
HeadPicUrl = v.HeadPicUrl,
MemebName = v.MemberName,
Comment = v.Comment,
CreateTime = v.CreateTime,
HotelName = n.HotelName
});
return("{ \"Count\":\"" + count + "\",\"data\":" + JsonConvert.SerializeObject(lastResult, DateTimeConvent.DateTimehh()) + "}");
}
catch (Exception)
{
return("{\"Count\":0}");
}
}
public string GetChefStarAll(dynamic requestData)
{
try
{
//var d = ImgHandle.DNS;
string name = JsonConvert.DeserializeObject <string>(JsonConvert.SerializeObject(requestData.Name));
string city = JsonConvert.DeserializeObject <string>(JsonConvert.SerializeObject(requestData.City));
int pageIndex = JsonConvert.DeserializeObject <int>(JsonConvert.SerializeObject(requestData.pageIndex));
int chefActivityId = JsonConvert.DeserializeObject <int>(JsonConvert.SerializeObject(requestData.ChefActivityId));
//获取当前活动ID
var qcaID = (from v in db.ChefActivity
where v.IsEnable == 1
select v
).FirstOrDefault();
chefActivityId = qcaID.ChefActivityId;
//获取赛区下城市列表
var sql = string.Format("select AreaName from MatchRegion where ChefActivityId={0} group by AreaName", chefActivityId);
var CityNameList = dataContext.ExecuteDataTable(CommandType.Text, sql);
if (pageIndex == null || pageIndex <= 0)
{
pageIndex = 1;
}
var q = (from v in db.ChefStar
where v.ChefActivityId == chefActivityId
orderby v.PriorityId
select new
{
ChefStarId = v.ChefStarId,
HeadPicUrl = v.HeadPicUrl,
ChefStarName = v.ChefStarName,
ChefStarPosition = v.ChefStarPosition,
ChefActivityId = v.ChefActivityId,
HotelName = v.HotelName,
CityName = v.CityName
});
if (name != null && !string.IsNullOrWhiteSpace(name))
{
q = q.Where(v => v.ChefStarName.Contains(name) || v.HotelName.Contains(name));
//q = q.Where(v => v.HotelName.Contains(name));
}
if (city != null && !string.IsNullOrWhiteSpace(city))
{
q = q.Where(v => v.CityName == city);
}
var count = q.Count();
q = q.Skip((pageIndex - 1) * 6).Take(6);
return("{ \"Count\":\"" + count + "\",\"data\":" + JsonConvert.SerializeObject(q, DateTimeConvent.DateTimehh()) + ",\"CityNameList\":" + JsonConvert.SerializeObject(CityNameList) + "}");
}
catch (Exception)
{
return("No");
}
}
public string FootPirntMember(dynamic requestData)
{
try
{
string openId = JsonConvert.DeserializeObject <string>(JsonConvert.SerializeObject(requestData.OpenId));
int pageIndex = JsonConvert.DeserializeObject <int>(JsonConvert.SerializeObject(requestData.PageIndex));
int userType = JsonConvert.DeserializeObject <int>(JsonConvert.SerializeObject(requestData.UserType));
string name = JsonConvert.DeserializeObject <string>(JsonConvert.SerializeObject(requestData.Name));
string sql = "";
//会员
if (userType == 2)
{
sql = string.Format(@"select ECD.PageShort,ECD.PageDetail,ECD.CreateTime,ECD.OpenId,RM.MemberName,RM.MemberId from ECBrowseDetails as ECD
left join OpenIdAssociated as OI on ECD.OpenId=OI.OpenId
left join RegistMember as RM on RM.MemberId=OI.UserId
where ECD.PageType=1 and ECD.OpenId='{0}'
", openId);
}
//队员
else
{
sql = string.Format(@"select ECD.PageShort,ECD.PageDetail,ECD.CreateTime,ECD.OpenId,RM.MemberName,RM.MemberId from ECBrowseDetails as ECD
left join OpenIdAssociated as OI on ECD.OpenId=OI.OpenId
left join RegistMember as RM on RM.MemberId=OI.UserId
where ECD.PageType=1
and ECD.OpenId in ( select OpenIdAssociated.OpenId from OpenIdAssociated join ( select MemberId from OpenIdAssociated
left join RegistCode on OpenIdAssociated.UserId=RegistCode.SalemanId
where OpenIdAssociated.OpenId='{0}')A on OpenIdAssociated.UserId=A.MemberId)
", openId);
}
// order by ECD.CreateTime desc
if (!string.IsNullOrEmpty(name))
{
//会员
if (userType == 2)
{
sql = sql + "and ( ECD.PageShort like '%" + name + "%' or ECD.PageDetail like '%" + name + "%' ) order by ECD.CreateTime desc";
}
//队员
if (userType == 1)
{
sql = sql + "and ( ECD.PageShort like '%" + name + "%' or ECD.PageDetail like '%" + name + "%' or RM.MemberName like '%" + name + "%' ) order by ECD.CreateTime desc";
}
}
else
{
sql += " order by ECD.CreateTime desc";
}
var q = dataContext.ExecuteDataTable(CommandType.Text, sql);
var lastq = q;
if (pageIndex > 0)
{
lastq = imgHandle.GetPagedTable(q, pageIndex, 10);
}
return(JsonConvert.SerializeObject(lastq, DateTimeConvent.DateTimehh()));
}
catch (Exception)
{
return("No");
}
}
public string GetSignin(dynamic requestData)
{
#region 最近7天签到情况
int MemberId = JsonConvert.DeserializeObject <int>(JsonConvert.SerializeObject(requestData.MemberId));
var datatime = DateTime.Today;
List <SigninCreditLog> listSCLog = new List <SigninCreditLog>();
for (int i = 0; i < 7; i++)
{
var list = (from v in db.SigninCreditLog
where v.MemberId == MemberId && v.SigninData == datatime
select v).FirstOrDefault();
if (list == null)
{
SigninCreditLog sclog = new SigninCreditLog();
sclog.Id = 0;
sclog.IsDraw = 2;
sclog.SigninData = datatime;
sclog.MemberId = MemberId;
listSCLog.Add(sclog);
}
else
{
listSCLog.Add(list);
}
datatime = datatime.AddDays(-1);
}
var d = (from v in listSCLog
select new
{
MemberId = v.MemberId,
SigninData = v.SigninData,
IsDraw = v.IsDraw
});
#endregion
#region 计算连续签到天数
int continuousDay = 0;
for (int i = 0; i < 7; i++)
{
if (i == 0 && listSCLog[i].SigninData == DateTime.Today && listSCLog[i].IsDraw == 2)
{
continue;
}
if (listSCLog[i].IsDraw == 0)
{
continuousDay = continuousDay + 1;
}
else
{
break;
}
}
#endregion
#region 当天是否签到
datatime = DateTime.Today;
var isSigninData = "f";
var scl = (from v in db.SigninCreditLog
where v.MemberId == MemberId && v.SigninData == datatime
select v).FirstOrDefault();
if (scl == null)
{
isSigninData = "f";
}
else
{
isSigninData = "t";
}
#endregion
//return JsonConvert.SerializeObject(d, DateTimeConvent.DateTimedd());
return("{\"SigninCredit\":" + JsonConvert.SerializeObject(d, DateTimeConvent.DateTimedd()) + ",\"IsSiginCredit\":\"" + isSigninData + "\",\"ContinuousDay\":" + continuousDay + "}");
}
public string GetCultivateInterflowList(dynamic requestData)
{
try
{
// var orderBy = requestData.OrderBy;
string orderBy = JsonConvert.DeserializeObject <string>(JsonConvert.SerializeObject(requestData.OrderBy));
if (orderBy != "time" && orderBy != "count")
{
orderBy = "time";
}
string isDesc = JsonConvert.DeserializeObject <string>(JsonConvert.SerializeObject(requestData.IsDesc));
if (isDesc != "f" && isDesc != "t")
{
isDesc = "f";
}
string openId = JsonConvert.DeserializeObject <string>(JsonConvert.SerializeObject(requestData.OpenId));
int pageIndex = JsonConvert.DeserializeObject <int>(JsonConvert.SerializeObject(requestData.PageIndex));
if (pageIndex <= 0)
{
pageIndex = 1;
}
// var sql = string.Format(@"select C.CuInterId,C.CurriculumType,C.Url,C.CurriculumName,C.VisitCount,C.PraiseCount,C.CreateTime,case when CP.Id is null then 'f' else 't' end as isPraise from CultivateInterflow C left join( select * from CultivatePraise where OpenId={0}) as CP on C.CuInterId=CP.CuInterId
//where C.IsDisplay=1
//order By C.Priority ",openId);
var qtest = (from v in db.CultivatePraise
where v.OpenId == openId
select v);
var q = (from v in db.CultivateInterflow
join p in qtest on v.CuInterId equals p.CuInterId into temp
from tt in temp.DefaultIfEmpty()
where v.IsDisplay == 1
select new
{
CuInterId = v.CuInterId,
CurriculumType = v.CurriculumType,
Url = v.Url,
CurriculumName = v.CurriculumName,
PraiseCount = v.PraiseCount,
VisitCount = v.VisitCount,
CreateTime = v.CreateTime,
IsPraise = tt.Id == null ? "f" : "t"
});
var count = q.Count();
//if (isDesc == "f")
//{
// var lastq = q.OrderBy(v => orderBy).Skip((pageIndex - 1) * 4).Take(4);
// return "{ \"Count\":\"" + count + "\",\"data\":" + JsonConvert.SerializeObject(lastq) + "}";
//}
//else
//{
// var lastq = q.OrderByDescending(v => orderBy).Skip((pageIndex - 1) * 4).Take(4);
// return "{ \"Count\":\"" + count + "\",\"data\":" + JsonConvert.SerializeObject(lastq) + "}";
//}
if (orderBy == "time")
{
if (isDesc == "t")
{
q = q.OrderByDescending(v => v.CreateTime);
}
if (isDesc == "f")
{
q = q.OrderBy(v => v.CreateTime);
}
}
if (orderBy == "count")
{
if (isDesc == "t")
{
q = q.OrderByDescending(v => v.VisitCount);
}
if (isDesc == "f")
{
q = q.OrderBy(v => v.VisitCount);
}
}
q = q.Skip((pageIndex - 1) * 4).Take(4);
return("{ \"Count\":\"" + count + "\",\"data\":" + JsonConvert.SerializeObject(q, DateTimeConvent.DateTimedd()) + "}");
}
catch (Exception)
{
return("No");
}
}
public string GetDishComment(int dishId, int index, int pageSize)
{
try
{
var q = (from v in db.DishComment
where v.DishId == dishId
select new
{
MemberName = v.MemberName,
HeadPicUrl = v.HeadPicUrl,
CreateTime = v.CreateTime,
Comment = v.Comment
});
var count = q.Count();
var lastq = q.OrderByDescending(v => v.CreateTime).Skip((index - 1) * pageSize).Take(pageSize);
return("{ \"Count\":\"" + count + "\",\"data\":" + JsonConvert.SerializeObject(lastq, DateTimeConvent.DateTimehh()) + "}");
}
catch (Exception)
{
return("No");
}
}
public string GetMyCollect(dynamic requestData)
{
try
{
string openId = JsonConvert.DeserializeObject <string>(JsonConvert.SerializeObject(requestData.OpenId));
int memberId = JsonConvert.DeserializeObject <int>(JsonConvert.SerializeObject(requestData.MemberId));
int pageIndex = JsonConvert.DeserializeObject <int>(JsonConvert.SerializeObject(requestData.PageIndex));
string sql = string.Format(@"select * from
(
select DCL.DishId,DCL.OpenId,DCL.DishType,DCL.CreateTime,DT.DishName,DT.DishPicUrl,DT.VisitCount,T.TutorName as PeopleName,T.TutorHotel as HotelName,1 as PeopleType from DishCollectLog as DCL
left join DishTutor as DT on DCL.DishId=DT.TutorDishId
left join Tutor as T on DT.TutorId=T.TutorId
where 1=1 and DCL.DishId between 200000 and 500000-1
and DCL.OpenId='{0}'
union all
---收藏厨师菜品
select DCL.DishId,DCL.OpenId,DCL.DishType,DCL.CreateTime,DC.DishName,DC.DishPicUrl,DC.VisitCount,RM.MemberName as PeopleName,RM.HotelName as HotelName, 2 as PeopleType from DishCollectLog as DCL
left join DishChef as DC on DCL.DishId=DC.DishChefId
left join Chef as C on DC.ChefId=C.ChefId
left join RegistMember as RM on C.MemberId=RM.MemberId
where 1=1 and DCL.DishId between 500000 and 1000000
and DCL.OpenId='{0}'
union all
---收藏星厨菜品
select DCL.DishId,DCL.OpenId,DCL.DishType,DCL.CreateTime,DCS.DishName,DCS.DishPicUrl,DCS.VisitCount,CS.ChefStarName as PeopleName,CS.HotelName as HotelName, 3 as PeopleType from DishCollectLog as DCL
left join DishChefStar as DCS on DCL.DishId=DCS.DishChefStarId
left join ChefStar as CS on DCS.ChefStarId=CS.ChefStarId
where 1=1 and DCL.DishId between 80000 and 150000
and DCL.OpenId='{0}'
) as Collect
order by Collect.CreateTime desc", openId);
var q = dataContext.ExecuteDataTable(CommandType.Text, sql);
int totalCount = q.Rows.Count;
if (pageIndex > 0)
{
q = imgHandle.GetPagedTable(q, pageIndex, 10);
}
return("{\"totalCount\":" + totalCount + ",\"Info\":" + JsonConvert.SerializeObject(q, DateTimeConvent.DateTimehh()) + "}");
}
catch (Exception)
{
return("No");
}
//return null;
}
public string GetMy(dynamic requestData)
{
try
{
string openId = JsonConvert.DeserializeObject <string>(JsonConvert.SerializeObject(requestData.OpenId));
int memberId = JsonConvert.DeserializeObject <int>(JsonConvert.SerializeObject(requestData.MemberId));
int pageIndex = JsonConvert.DeserializeObject <int>(JsonConvert.SerializeObject(requestData.PageIndex));
string sql = string.Format(@"select * from(
select DC.DishChefId as DishId, C.MemberId,DC.DishType,DC.ApplyTime ,DC.DishName,DC.DishPicUrl,DC.VisitCount ,2 as PeopleType ,case when DCL.DishId is not null then 't' else 'f' end as IsCollect
from DishChef as DC
left join Chef as C on DC.ChefId=C.ChefId
left join
(select * from DishCollectLog where OpenId='{0}')as DCL on DC.DishChefId=DCL.DishId
where C.MemberId={1} and DC.IsApply=1
union all
select MS.MySelfDishId as DishId,MS.MemberId,MS.DishType,MS.ApplyTime,MS.DishName,MS.DishPicUrl,MS.VisitCount,4 as PeopleType ,case when DCL.DishId is not null then 't' else 'f' end as IsCollect from MySelfDishKu as MS
left join
(select * from DishCollectLog where OpenId='{0}')as DCL on MS.MySelfDishId=DCL.DishId
where MS.MemberId={1} and MS.IsApply=1
) as my order by my.ApplyTime desc", openId, memberId);
var q = dataContext.ExecuteDataTable(CommandType.Text, sql);
int totalCount = q.Rows.Count;
if (pageIndex > 0)
{
q = imgHandle.GetPagedTable(q, pageIndex, 10);
}
return("{\"totalCount\":" + totalCount + ",\"Info\":" + JsonConvert.SerializeObject(q, DateTimeConvent.DateTimehh()) + "}");
}
catch (Exception)
{
return("No");
}
}
public string GetCultivateComment(dynamic requestData)
{
try
{
int cuId = JsonConvert.DeserializeObject <int>(JsonConvert.SerializeObject(requestData.CuInterId));
int pageIndex = JsonConvert.DeserializeObject <int>(JsonConvert.SerializeObject(requestData.PageIndex));
if (pageIndex <= 0)
{
pageIndex = 1;
}
var q = (from v in db.CultivateComment
where v.CuInterId == cuId
select new
{
HeadPicUrl = v.HeadPicUrl,
NickName = v.NickName,
Comment = v.Comment,
CreateTime = v.CreateTime
});
var count = q.Count();
q = q.OrderByDescending(v => v.CreateTime).Skip((pageIndex - 1) * 3).Take(3);
return("{ \"Count\":\"" + count + "\",\"data\":" + JsonConvert.SerializeObject(q, DateTimeConvent.DateTimehh()) + "}");
}
catch (Exception)
{
return("No");
}
}
public string GetMyTrack(dynamic requestData)
{
string openId = JsonConvert.DeserializeObject <string>(JsonConvert.SerializeObject(requestData.OpenId));
int memeberId = JsonConvert.DeserializeObject <int>(JsonConvert.SerializeObject(requestData.MemberId));
int pageIndex = JsonConvert.DeserializeObject <int>(JsonConvert.SerializeObject(requestData.pageIndex));
string keyword = JsonConvert.DeserializeObject <string>(JsonConvert.SerializeObject(requestData.KeyWord));
string sql = string.Format(@"select * from
(
select '知味报名' as module,c.CreateTime as CreateTime,CA.ChefActivityName as Name from Chef as c join ChefActivity as CA on c.ChefActivityId=CA.ChefActivityId where MemberId={0}
union all
select '菜品投票' as module ,DSL.CreateTime as CreateTime , CA.ChefActivityName as Name from DishSelectedLog as DSL join ChefActivity as CA on DSL.ChefActivityId=CA.ChefActivityId where OpenId='{1}'
) as a where 1=1 ", memeberId, openId);
if (!string.IsNullOrEmpty(keyword))
{
sql += "and a.module like '%" + keyword + "%' or a.Name like '%" + keyword + "%' ";
}
var q = dataContext.ExecuteDataTable(CommandType.Text, sql);
var count = q.Rows.Count;
if (pageIndex <= 0 || string.IsNullOrEmpty(keyword))
{
pageIndex = 1;
}
var lastq = imgHandle.GetPagedTable(q, pageIndex, 10);
return("{ \"Count\":\"" + count + "\",\"data\":" + JsonConvert.SerializeObject(lastq, DateTimeConvent.DateTimedd()) + "}");
}
public string GetMySelfDishKu(dynamic requestData)
{
try
{
//审核状态，-1，表示全部，0、待审核 1、审核通过 2、审核不通过
int isApply = JsonConvert.DeserializeObject <int>(JsonConvert.SerializeObject(requestData.IsApply));
//上传时间
string beginTime = JsonConvert.DeserializeObject <string>(JsonConvert.SerializeObject(requestData.BeginTime));
string endTime = JsonConvert.DeserializeObject <string>(JsonConvert.SerializeObject(requestData.EndTime));
//会员姓名，菜品名，产品名称
string name = JsonConvert.DeserializeObject <string>(JsonConvert.SerializeObject(requestData.Name));
//页数
int pageIndex = JsonConvert.DeserializeObject <int>(JsonConvert.SerializeObject(requestData.PageIndex));
string sql = string.Format(@"select MyDK.MemberId,RM.MemberName,MyDK.MySelfDishId,MyDK.DishName,FR.FRName,MyDK.CreateTime,MyDK.IsApply ,MyDK.PhoneNum from MySelfDishKu as MyDK
left join RegistMember as RM on MyDK.MemberId=RM.MemberId
left join ( select B.MySelfDishKuId , FRName=(stuff( (select ' '+A.FRName from (select role.*,FR.FRName from MySelfFRRole as role left join MySelfFR as FR on role.MySelfFRId=FR.MySelfFRId)as A where B.MySelfDishKuId=A .MySelfDishKuId for xml path('')),1, 1, ''))
from ( select role.*,FR.FRName from MySelfFRRole as role left join MySelfFR as FR on role.MySelfFRId=FR.MySelfFRId) as B group by B.MySelfDishKuId) As FR on MyDK.MySelfDishId=FR.MySelfDishKuId where 1=1");
if (isApply > -1)
{
sql = sql + " and MyDK.IsApply= " + isApply;
}
if (!string.IsNullOrEmpty(beginTime))
{
sql = sql + " and MyDK.CreateTime>='" + beginTime + "' ";
}
if (!string.IsNullOrEmpty(endTime))
{
sql = sql + " and MyDK.CreateTime<='" + endTime + "' ";
}
if (!string.IsNullOrEmpty(name))
{
sql = sql + " and (RM.MemberName like '%" + name + "%' or MyDK.DishName like '%" + name + "%' or FR.FRName like '%" + name + "%') ";
}
sql = sql + " order by MyDK.CreateTime desc";
var q = dataContext.ExecuteDataTable(CommandType.Text, sql);
int totalCount = q.Rows.Count;
if (pageIndex > 0)
{
q = imgHandle.GetPagedTable(q, pageIndex, 10);
}
return("{\"totalCount\":" + totalCount + ",\"Info\":" + JsonConvert.SerializeObject(q, DateTimeConvent.DateTimehh()) + "}");
}
catch (Exception)
{
return("No");
}
}
public string UpdateIsDel(dynamic requestData)
{
try
{
int bannerId = JsonConvert.DeserializeObject <int>(JsonConvert.SerializeObject(requestData.BannerId));
//先查询
var banner = (from v in db.Banner
where v.BannerId == bannerId
select v).Single();
db.Banner.Remove(banner);
var count = db.SaveChanges();
if (count > 0)
{
var q = (from v in db.Banner
orderby v.BannerId
select new
{
BannerId = v.BannerId,
BannerType = v.BannerType,
PicUrl = v.PicUrl,
Link = v.Link,
IsDisplay = v.IsDisplay == 1 ? "是" : "否",
PriorityId = v.PriorityId
});
var count1 = q.Count();
var lastq = q.Skip(0).Take(10);
return("{ \"Count\":\"" + count1 + "\",\"data\":" + JsonConvert.SerializeObject(lastq, DateTimeConvent.DateTimehh()) + "}");
}
else
{
return("No");
}
}
catch (Exception)
{
return("No");
}
}
public string GetCultivateList(dynamic requestData)
{
try
{
string sql = "select * from (select c.CuInterId,c.CurriculumName,c.CreateTime, STUFF((SELECT ' '+LecturerName FROM Lecturer where CuInterId=c.CuInterId FOR XML PATH('')), 1, 1, '') lecturer,c.CurriculumType,c.IsDisplay,c.Priority from CultivateInterflow c ) as d where 1=1";
var StarTime = JsonConvert.DeserializeObject <string>(JsonConvert.SerializeObject(requestData.StarTime));
var EndTime = JsonConvert.DeserializeObject <string>(JsonConvert.SerializeObject(requestData.EndTime));
var Name = JsonConvert.DeserializeObject <string>(JsonConvert.SerializeObject(requestData.Name));
var pageIndex = JsonConvert.DeserializeObject <int>(JsonConvert.SerializeObject(requestData.PageIndex));
if (!string.IsNullOrEmpty(StarTime))
{
sql += " and d.CreateTime>'" + StarTime + "'";
}
if (!string.IsNullOrEmpty(EndTime))
{
sql += " and d.CreateTime<'" + EndTime + "'";
}
if (!string.IsNullOrEmpty(Name))
{
sql += " and (d.CurriculumName like '%" + Name + "%' or d.lecturer like '%" + Name + "%')";
}
sql = sql + " Order by d.Priority";
var q = dataContext.ExecuteDataTable(CommandType.Text, sql);
var count = q.Rows.Count;
if (pageIndex <= 0)
{
pageIndex = 1;
}
var lastq = imgHandel.GetPagedTable(q, pageIndex, 10);
return("{ \"Count\":\"" + count + "\",\"data\":" + JsonConvert.SerializeObject(lastq, DateTimeConvent.DateTimedd()) + "}");
}
catch (Exception)
{
return("No");
}
}