private static DataDictionary GetDataDictionaryByName(string parentName, string childName)
{
using (CupcakeEntities entity = new CupcakeEntities())
{
var query = entity.DataDictionary;
var root = query.FirstOrDefault(p => p.Name == "Root" && p.ParentId == null && p.IsDelete == false);
if (root == null)
{
throw new Exception("没有找到Root数据字典");
}
var dataDictionary = query.FirstOrDefault(p => p.Name == parentName && p.ParentId == root.Id && p.IsDelete == false);
if (dataDictionary != null)
{
var childDataDictionary = query.FirstOrDefault(p => p.Name == childName && p.ParentId == dataDictionary.Id && p.IsDelete == false);
if (childDataDictionary != null)
{
return(childDataDictionary);
}
else
{
throw new Exception("没有该子数据字典:" + childName);
}
}
else
{
throw new Exception("没有配置数据字典:" + parentName);
}
}
}
public int Add(string RegistrationName, string RegistrationTel, string UserId, string Id)
{
using (CupcakeEntities entity = new CupcakeEntities())
{
Activity_RegistrationStatus info = new Activity_RegistrationStatus();
info.Id = Guid.NewGuid();
info.RegistrationDate = DateTime.Now;
info.RegistrationName = RegistrationName;
info.RegistrationTel = RegistrationTel;
info.SubordinateActivitiesID = new Guid(Id);
info.UpdateDate = DateTime.Now;
info.CreateDate = DateTime.Now;
info.UserId = new Guid(UserId);
entity.Activity_RegistrationStatus.Add(info);
var count = entity.SaveChanges();
if (count > 0)
{
return(0);
}
else
{
return(1);
}
}
}
/// <summary>
/// 根据过滤条件获取单个
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public virtual TModel Get(Expression <Func <TModel, bool> > filter)
{
using (CupcakeEntities entity = new CupcakeEntities())
{
return(entity.Set <TModel>().Where(filter).SingleOrDefault());
}
}
public ActionResult TwoPlAddJson()
{
//var user = Session["User"] as User;
//User user1 = new User();
//if (user == null)
//{
var userName = "******";
var userId = Guid.Parse("9393ed42-7b3f-e711-afa3-002564ba5c19");
//}
string Content = Request.Form["Content"];
Guid ToTwoCommentsId = Guid.Parse(Request.Form["ToTwoCommentsId"]);
Guid ToCommentsId = Guid.Parse("00000000-0000-0000-0000-000000000000");
if (!string.IsNullOrEmpty(Request.Form["ChildId"]))
{
ToCommentsId = Guid.Parse(Request.Form["ChildId"]);
}
ServiceComments service = new ServiceComments();
bool isWhere = service.GetTwoPlAdd(ToCommentsId, ToTwoCommentsId, Content, userId, userName);
int ReplyNum = 0;
if (isWhere == true)
{
//新增回复数量
service.GetGetTwoReplyNum(ToCommentsId);
using (CupcakeEntities db = new CupcakeEntities())
{
ReplyNum = db.Comments.Where(m => m.Id == ToCommentsId && m.IsDelete == false).SingleOrDefault().ReplyNum;
}
}
return(Json(new { isWhere = isWhere, ReplyNum = ReplyNum }));
}
public Activity_Activitys GetbyActivity(Guid id)
{
using (CupcakeEntities entity = new CupcakeEntities())
{
return(entity.Activity_Activitys.Where(p => p.Id == id && p.IsDelete == false).FirstOrDefault());
}
}
//public virtual int Modify(TModel model)
//{
// using (CupcakeEntities entity = new CupcakeEntities())
// {
// entity.Set<TModel>().(model);
// return entity.SaveChanges();
// }
//}
/// <summary>
/// 获取所有
/// </summary>
/// <returns></returns>
public virtual List <TModel> GetAll()
{
using (CupcakeEntities entity = new CupcakeEntities())
{
return(entity.Set <TModel>().AsNoTracking().ToList());
}
}
public int GetRegistrationCount(Guid id)
{
using (CupcakeEntities entity = new CupcakeEntities())
{
return(entity.Activity_RegistrationStatus.Where(n => n.SubordinateActivitiesID == id && n.IsDelete == false).Count());
}
}
/// <summary>
/// 点赞+1/-1
/// </summary>
/// <param name="ChildId"></param>
/// <returns></returns>
public int PraisePlusOne(Guid Id, int result1)
{
using (CupcakeEntities db = new CupcakeEntities())
{
//result1 =1 新增 +1
//result1 =2 删除 -1
var info = db.Comments.Where(m => m.Id == Id && m.IsDelete == false).SingleOrDefault();
int result = 0;
if (result1 == 1)
{
info.PraiseNum = info.PraiseNum + 1;
}
if (result1 == 2)
{
info.PraiseNum = info.PraiseNum - 1;
}
int bc = db.SaveChanges();
if (bc > 0 && result1 == 1)
{
result = 1;
}
else if (bc > 0 && result1 == 2)
{
result = 2;
}
return(result);
}
}
/// <summary>
/// 新增二级评论
/// </summary>
/// <returns></returns>
public bool GetTwoPlAdd(Guid ToCommentsId, Guid ToTwoCommentsId, string Content, Guid UserId, string UserName)
{
using (CupcakeEntities db = new CupcakeEntities())
{
Comments model = new Comments();
model.Id = Guid.NewGuid();
model.IsDelete = false;
model.PublicDate = DateTime.Now;
model.ToCommentsId = ToCommentsId;
model.ToTwoCommentsId = ToTwoCommentsId;
model.ChildId = null;
model.CreateDate = DateTime.Now;
model.UpdateDate = DateTime.Now;
model.UserId = UserId;
model.Name = UserName;
model.Content = Content;
model.ImgUrl = null;
model.PraiseNum = 0;
model.ReplyNum = 0;
model.MessageName = db.Comments.Where(m => m.Id == ToCommentsId && m.IsDelete == false).SingleOrDefault().MessageName;
model.TypeChildId = Guid.Parse("00000000-0000-0000-0000-000000000000");
model.CreatorId = null;
db.Comments.Add(model);
db.Configuration.ValidateOnSaveEnabled = false;
return(db.SaveChanges() > 0);
}
}
/// <summary>
/// 根据过滤条件
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public virtual List <TModel> GetList(Expression <Func <TModel, bool> > filter)
{
using (CupcakeEntities entity = new CupcakeEntities())
{
return(entity.Set <TModel>().AsNoTracking().Where(filter).ToList());
}
}
public News_News GetbyNews(Guid id)
{
using (CupcakeEntities entity = new CupcakeEntities())
{
return(entity.News_News.Where(p => p.Id == id && p.IsDelete == false).FirstOrDefault());
}
}
/// <summary>
/// 根据ID来获取信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Users Get(Guid id)
{
using (CupcakeEntities entity = new CupcakeEntities())
{
return(entity.Users.Where(p => p.Id == id).SingleOrDefault());
}
}
public int GetIsRegistration(Guid Id, Guid ActivityId)
{
using (CupcakeEntities entity = new CupcakeEntities())
{
return(entity.Activity_RegistrationStatus.Where(n => n.UserId == Id && n.SubordinateActivitiesID == ActivityId && n.IsDelete == false).Count());
}
}
public int AddMessage(string MessageName, string MessageConent, string UserId, string Id)
{
using (CupcakeEntities entity = new CupcakeEntities())
{
Activity_MessageManagements info = new Activity_MessageManagements();
info.Id = Guid.NewGuid();
info.MessageDate = DateTime.Now;
info.MessageName = MessageName;
info.MessageConent = MessageConent;
info.SubordinateActivitiesID = new Guid(Id);
info.UpdateDate = DateTime.Now;
info.CreateDate = DateTime.Now;
//info.UserId = new Guid(UserId);
entity.Activity_MessageManagements.Add(info);
var count = entity.SaveChanges();
if (count > 0)
{
return(1);
}
else
{
return(0);
}
}
}
public int GetByMessageManagements(Guid id)
{
using (CupcakeEntities entity = new CupcakeEntities())
{
return(entity.Activity_MessageManagements.Where(p => p.IsDelete == false && p.SubordinateActivitiesID == id).Count());
}
}
public Members_Members Verify(string userName, string password)
{
using (CupcakeEntities entity = new CupcakeEntities())
{
Guid statusid = DataDictionaryHelper.GetId("用户状态>启用");
return(entity.Members_Members.Where(u => u.UserName == userName && u.Password == password && u.failLoginCount <= 15 && u.Status == statusid && u.IsDelete == false).SingleOrDefault());
}
}
public bool Add(Questionnaire_QuestionStatistic model)
{
using (CupcakeEntities entity = new CupcakeEntities())
{
entity.Questionnaire_QuestionStatistic.Add(model);
return(entity.SaveChanges() > 0);
}
}
/// <summary>
/// 所有评论数
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int GetReplyNum(Guid?Chlidid)
{
using (CupcakeEntities db = new CupcakeEntities())
{
int Count = db.Comments.Where(m => m.ChildId == Chlidid || m.ToTwoCommentsId == Chlidid).Count();
return(Count);
}
}
public List <Activity_ActivityStyle> GetActivityStylelist()
{
using (CupcakeEntities entity = new CupcakeEntities())
{
string sqlstr = string.Format(" select top 5* from [Cupcake].[dbo].[Activity_ActivityStyle] where IsDelete=0 order by UpdateDate desc");
return(entity.Database.SqlQuery <Activity_ActivityStyle>(sqlstr).ToList());
}
}
public List <Activity_Activitys> GetListActivityBytype(Guid id)
{
using (CupcakeEntities entity = new CupcakeEntities())
{
string sqlstr = string.Format(" select * from [Cupcake].[dbo].[Activity_Activitys] where [ActityType]='{0}'and IsDelete=0 order by UpdateDate desc", id);
return(entity.Database.SqlQuery <Activity_Activitys>(sqlstr).ToList());
}
}
public IList <Questionnaire_QuestionStatistic> GetListById(Guid QuestionSurveyId, Guid CreatorId)
{
using (CupcakeEntities entity = new CupcakeEntities())
{
string sqlstr = string.Format(" select * from Questionnaire_QuestionStatistic where IsDelete=0 and QuestionSurveyId='{0}' and UserId='{1}' order by CreateDate ", QuestionSurveyId, CreatorId);
return(entity.Database.SqlQuery <Questionnaire_QuestionStatistic>(sqlstr).ToList());
}
}
public List <Activity_Activitys> GetListActivityByid(Guid id)
{
using (CupcakeEntities entity = new CupcakeEntities())
{
string sqlstr = string.Format("select * from [Cupcake].[dbo].[Activity_Activitys] where [ActityType]=(select [ActityType] from [Cupcake].[dbo].[Activity_Activitys] where id='{0}') and not(Id='{1}') order by UpdateDate desc", id, id);
return(entity.Database.SqlQuery <Activity_Activitys>(sqlstr).ToList());
}
}
public Members_Members LoginTempPwd(Guid?userId, string tempPassword)
{
using (CupcakeEntities entity = new CupcakeEntities())
{
Guid statusid = DataDictionaryHelper.GetId("用户状态>启用");
return(entity.Members_Members.Where(u => u.Id == userId && u.Password == tempPassword && u.IsDelete == false && u.Status == statusid).SingleOrDefault());
}
}
public IList <Questionnaire_QuestionResult> GetListByQuestionInfoId(Guid questionInfoId)
{
using (CupcakeEntities entity = new CupcakeEntities())
{
string sqlstr = string.Format(" select * from Questionnaire_QuestionResult where IsDelete=0 and QuestionInfoId='{0}' order by CreateDate ", questionInfoId);
return(entity.Database.SqlQuery <Questionnaire_QuestionResult>(sqlstr).ToList());
}
}
public List <Questionnaire_QuestionSurvey> GetAll()
{
using (CupcakeEntities entity = new CupcakeEntities())
{
string sqlstr = string.Format(" select * from Questionnaire_QuestionSurvey where IsDelete=0 and IsRelease=1 order by CreateDate ");
return(entity.Database.SqlQuery <Questionnaire_QuestionSurvey>(sqlstr).ToList());
}
}
public List <News_News> GetNewslist()
{
using (CupcakeEntities entity = new CupcakeEntities())
{
string sqlstr = string.Format(" select top 5* from [Cupcake].[dbo].[News_News] where IsDelete=0 order by UpdateDate desc");
return(entity.Database.SqlQuery <News_News>(sqlstr).ToList());
}
}
/// <summary>
/// 删除实例
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public virtual int Remove(TModel model)
{
using (CupcakeEntities entity = new CupcakeEntities())
{
entity.Set <TModel>().Remove(model);
return(entity.SaveChanges());
}
}
/// <summary>
/// 删除单个收藏
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public bool HasComments_CollectDelete(Guid Id)
{
using (CupcakeEntities db = new CupcakeEntities())
{
var info = db.Comments_Collect.Where(m => m.IsDelete == false && m.Id == Id).SingleOrDefault();
db.Comments_Collect.Remove(info);
return(db.SaveChanges() > 0);
}
}
/// <summary>
/// 新增回复数量
/// </summary>
/// <param name="ChildId"></param>
/// <returns></returns>
public bool GetGetTwoReplyNum(Guid ToCommentsId)
{
using (CupcakeEntities db = new CupcakeEntities())
{
var list = db.Comments.Where(m => m.Id == ToCommentsId && m.IsDelete == false).SingleOrDefault();
list.ReplyNum = list.ReplyNum + 1;
return(db.SaveChanges() > 0);
}
}
/// <summary>
/// 添加并返回实例
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public virtual TModel AddReturn(TModel model)
{
using (CupcakeEntities entity = new CupcakeEntities())
{
entity.Set <TModel>().Add(model);
entity.SaveChanges();
return(model);
}
}
