public async Task <ResultData <QZ_Inquiry> > Update(QZ_Inquiry qZ_Inquiry) { string message = "事件不存在"; var query = from e in ModelQZ.DatabaseContext.QZ_Inquiry where e.InquiryId == qZ_Inquiry.InquiryId select e; QZ_Inquiry data = query.FirstOrDefault(); if (data != null) { ReflectionHelper.CopyProperties <QZ_Inquiry>(qZ_Inquiry, data, new String[] { "EventId" }); data.ModifyTime = DateTime.Now.ToString(); ModelQZ.DatabaseContext.Entry(data).State = System.Data.Entity.EntityState.Modified; await ModelQZ.DatabaseContext.SaveChangesAsync(); message = string.Empty; } ResultData <QZ_Inquiry> result = new ResultData <QZ_Inquiry> { IsSuccessed = data != null, Message = message, Data = data }; return(result); }
public ResultData <IEnumerable <QZ_Inquiry> > Qurey(string inquiry = "", string eventId = "", string partyId = "", string createUserId = "", string createDepartmentId = "") { var query = from e in ModelQZ.DatabaseContext.QZ_Inquiry where (partyId == "" || e.PartyId == partyId) && (createUserId == "" || e.CreateUserId == createUserId) && (createDepartmentId == "" || e.CreateDepartmentId == createDepartmentId) && (eventId == "" || e.EventId == eventId) && (partyId == "" || e.PartyId == partyId) select e; IEnumerable <QZ_Inquiry> data = query.ToList(); List <QZ_Inquiry> resultData = new List <QZ_Inquiry>(); foreach (var d in data) { QZ_Inquiry t = new QZ_Inquiry(); ReflectionHelper.CopyProperties <QZ_Inquiry>(d, t, new String[] { }); resultData.Add(t); } ResultData <IEnumerable <QZ_Inquiry> > result = new ResultData <IEnumerable <QZ_Inquiry> > { IsSuccessed = true, Message = "", Data = data }; return(result); }
public async Task <ResultData <QZ_Inquiry> > Add(QZ_Inquiry qZ_Inquiry) { string message = "添加信息失败"; try { qZ_Inquiry.InquiryId = Guid.NewGuid().ToString(); qZ_Inquiry.CreateTime = DateTime.Now.ToString(); qZ_Inquiry.ModifyTime = DateTime.Now.ToString(); ModelQZ.DatabaseContext.QZ_Inquiry.Add(qZ_Inquiry); await ModelQZ.DatabaseContext.SaveChangesAsync(); message = string.Empty; } catch (Exception ex) { } ResultData <QZ_Inquiry> result = new ResultData <QZ_Inquiry> { IsSuccessed = true, Message = message, Data = qZ_Inquiry }; return(result); }
public NewTalkViewModel() { _party = new QZ_Party { PartySex = "男", }; _inquiry = new QZ_Inquiry { InquiryDate = DateTime.Now.Date.ToString() }; }
public ResultData <IEnumerable <QZ_Inquiry> > QureyByDate(DateTime startDateTime, DateTime endDataTime) { var query = from i in ModelQZ.DatabaseContext.QZ_Inquiry //where i.InquiryDate >= startDateTime && (i.InquiryDate) <= endDataTime orderby i.InquiryDate select i; IEnumerable <QZ_Inquiry> data = query.ToList(); List <QZ_Inquiry> resultData = new List <QZ_Inquiry>(); foreach (var d in data) { QZ_Inquiry t = new QZ_Inquiry(); ReflectionHelper.CopyProperties <QZ_Inquiry>(d, t, new String[] { }); resultData.Add(t); } ResultData <IEnumerable <QZ_Inquiry> > result = new ResultData <IEnumerable <QZ_Inquiry> > { IsSuccessed = true, Message = "", Data = data }; return(result); }