public int UpdateSaleMan(dynamic requestData) { string query = JsonConvert.SerializeObject(requestData); RegistSaleMan saleman = JsonConvert.DeserializeObject <RegistSaleMan>(query); EntityState statebefore = db.Entry(saleman).State; db.Entry(saleman).State = EntityState.Modified; return(db.SaveChanges()); }
public string UpdateDrawPrize(dynamic requestData) { string query = JsonConvert.SerializeObject(requestData); DrawPrize model = JsonConvert.DeserializeObject <DrawPrize>(query); EntityState statebefore = db.Entry(model).State; db.Entry(model).State = EntityState.Modified; db.SaveChanges(); return("Excute Success"); }
public int UpdateMember(dynamic requestData) { string query = JsonConvert.SerializeObject(requestData); RegistMember model = JsonConvert.DeserializeObject <RegistMember>(query); EntityState statebefore = db.Entry(model).State; db.Entry(model).State = EntityState.Modified; return(db.SaveChanges()); }
public int UpdateMemberResume(dynamic requestData) { string query = JsonConvert.SerializeObject(requestData); MemberResume model = JsonConvert.DeserializeObject <MemberResume>(query); EntityState statebefore = db.Entry(model).State; db.Entry(model).State = EntityState.Modified; db.SaveChanges(); return(model.ResumeId); }
public string RealAuthUpdate(dynamic requestData) { string query = JsonConvert.SerializeObject(requestData); MemberRealAuth model = JsonConvert.DeserializeObject <MemberRealAuth>(query); model.AuthTime = DateTime.Now; EntityState statebefore = db.Entry(model).State; db.Entry(model).State = EntityState.Modified; db.SaveChanges(); return("Exc Success"); }
public string AddSigninCredit(dynamic requestData) { try { int MemberId = JsonConvert.DeserializeObject <int>(JsonConvert.SerializeObject(requestData.MemberId)); var datatime = DateTime.Today; var q = (from v in db.SigninCreditLog where v.MemberId == MemberId && v.SigninData == datatime select v ).FirstOrDefault(); if (q == null) { SigninCreditLog s = new SigninCreditLog(); s.SigninData = datatime; s.MemberId = MemberId; db.SigninCreditLog.Add(s); SigninCredit sC = new SigninCredit(); var sccun = (from v in db.SigninCredit where v.MemberId == MemberId select v ).FirstOrDefault(); if (sccun == null) { sC.MemberId = MemberId; sC.CreditsCount = 1; sC.CreateTime = DateTime.Now; sC.UpdateTime = DateTime.Now; db.SigninCredit.Add(sC); } else { sccun.CreditsCount = sccun.CreditsCount + 1; sccun.UpdateTime = DateTime.Now; db.Entry <SigninCredit>(sccun).State = EntityState.Modified; } db.SaveChanges(); return("OK"); } else { return("2"); } } catch (Exception) { return("No"); } }
public string UpdateSingle(dynamic bannerDate) { try { string updateSingle = JsonConvert.SerializeObject(bannerDate); Banner q = JsonConvert.DeserializeObject <Banner>(updateSingle); var d = (from v in db.Banner where v.BannerId == q.BannerId select v).FirstOrDefault(); q.BannerId = 0; d.PicUrl = q.PicUrl; d.Link = q.Link; d.PriorityId = q.PriorityId; d.IsDisplay = q.IsDisplay; d.BannerType = q.BannerType; d.UpdatePerson = q.UpdatePerson; d.UpdateTime = DateTime.Now; db.Entry <Banner>(d).State = EntityState.Modified; db.SaveChanges(); return("OK"); } catch (Exception) { return("No"); } }
public int UpdateAddress(dynamic requestData) { string query = JsonConvert.SerializeObject(requestData); Address model = JsonConvert.DeserializeObject <Address>(query); if (model.IsDefault == 1) { string sql = string.Format("Update [Address] Set IsDefault = 0 Where MemberId = {0}", model.MemberId); dataContext.ExecuteNonQuery(CommandType.Text, sql); } EntityState statebefore = db.Entry(model).State; db.Entry(model).State = EntityState.Modified; db.SaveChanges(); return(model.AddressId); }
public string AddECWXTranspondDetails(dynamic requestData) { try { string BrowseDetails = JsonConvert.SerializeObject(requestData); var q = JsonConvert.DeserializeObject <ECWXTranspondDetails>(BrowseDetails); //是否包含 var IsUV = (from v in db.ECWXTranspondDetails where v.ECBrowseURL == q.ECBrowseURL && v.OpenId == q.OpenId select v).FirstOrDefault(); //查找EC总的是否有 var qECBrowse = (from v in db.ECBrowse where v.ECURL == q.ECBrowseURL select v).FirstOrDefault(); if (IsUV == null) { if (qECBrowse == null) { ECBrowse newqECBrowse = new ECBrowse(); newqECBrowse.ECURL = q.ECBrowseURL; newqECBrowse.Transpond = 1; db.ECBrowse.Add(newqECBrowse); } else { qECBrowse.Transpond = qECBrowse.Transpond + 1; db.Entry <ECBrowse>(qECBrowse).State = EntityState.Modified; } } else { qECBrowse.Transpond = qECBrowse.Transpond + 1; db.Entry <ECBrowse>(qECBrowse).State = EntityState.Modified; } db.ECWXTranspondDetails.Add(q); db.SaveChanges(); return("OK"); } catch (Exception) { return("No"); } }
public ActionResult Edit([Bind(Include = "CreditId,Head,Period,Sum,Procent")] Credit credit) { if (ModelState.IsValid) { db.Entry(credit).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(credit)); }
public ActionResult Edit([Bind(Include = "BidId,Name,CreditHead,bidDate")] Bid bid) { if (ModelState.IsValid) { db.Entry(bid).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(bid)); }
public string UpdateCultivate(CultivateInterflow cu) { var q = (from v in db.CultivateInterflow where v.CuInterId == cu.CuInterId select v).FirstOrDefault(); cu.CuInterId = 0; q.CurriculumName = cu.CurriculumName; q.CurriculumType = cu.CurriculumType; q.Url = cu.Url; q.Priority = cu.Priority; q.IsDisplay = cu.IsDisplay; q.Introduce = cu.Introduce; if (q.Introduce.IndexOf("base64") > 0) { string d = q.Introduce; foreach (string a in imgHandel.GetHtmlImageUrlList(d)) { if (a.IndexOf(ImgHandle.DNS) < 0) { string[] asplit = a.Split(','); string imgtype = asplit[0].Substring(11, asplit[0].Length - 18); string filepath = imgHandel.Base64StringToImage(asplit[1], imgtype, "/pic/Lecturer"); d = d.Replace(a, filepath); } } q.Introduce = d; } q.UpdatePerson = cu.UpdatePerson; q.UpdateTime = DateTime.Now; db.Entry <CultivateInterflow>(q).State = EntityState.Modified; db.SaveChanges(); return(null); }
public string AddMatchRegion(dynamic requestData) { try { string addMatchRegion = JsonConvert.SerializeObject(requestData); List <MatchRegion> model = JsonConvert.DeserializeObject <List <MatchRegion> >(addMatchRegion); ////var allDel = string.Format(@"DELETE MatchRegion where ChefActivityId={0}", model[0].ChefActivityId); //dataContext.ExecuteNonQuery(CommandType.Text, allDel); foreach (MatchRegion m in model) { var q = (from v in db.MatchRegion where v.MatchRegionId == m.MatchRegionId select v).FirstOrDefault(); if (q != null) { m.CityName = m.AreaName; // m.CreateTime = DateTime.Now; m.UpdateTime = DateTime.Now; q.AreaName = m.AreaName; q.BeginTime = m.BeginTime; q.CityName = m.AreaName; q.EndTime = m.EndTime; q.ProvinceName = m.ProvinceName; q.UpdatePerson = m.UpdatePerson; q.UpdateTime = DateTime.Now; m.MatchRegionId = 0; db.Entry <MatchRegion>(q).State = EntityState.Modified; } else { m.CityName = m.AreaName; m.CreateTime = DateTime.Now; m.UpdateTime = DateTime.Now; //db.MatchRegion.Add(m); //db.SaveChanges(); var sql = string.Format("INSERT INTO [dbo].[MatchRegion]([ProvinceName],[CityName],[AreaName],[ChefActivityId],[BeginTime],[EndTime],[CreatePerson],[UpdatePerson],[CreateTime],[UpdateTime],[Remark])VALUES('{0}','{1}','{2}',{3},'{4}','{5}','{6}','{7}','{8}','{9}','{10}')", m.ProvinceName, m.CityName, m.AreaName, m.ChefActivityId, m.BeginTime, m.EndTime, m.CreatePerson, m.UpdatePerson, m.CreateTime, m.UpdateTime, m.Remark); dataContext.ExecuteNonQuery(CommandType.Text, sql); } } db.SaveChanges(); return("OK"); } catch (Exception) { return("No"); } }
public string UpdateSingle(dynamic bannerDate) { try { string updateSingle = JsonConvert.SerializeObject(bannerDate); var model = JsonConvert.DeserializeObject <Tutor>(updateSingle); if (model.Introduce.IndexOf("base64") > 0) { string d = model.Introduce; GetHtmlImageUrlList(d); foreach (string a in GetHtmlImageUrlList(d)) { if (a.IndexOf(ImgHandle.DNS) < 0) { string[] asplit = a.Split(','); string imgtype = asplit[0].Substring(11, asplit[0].Length - 18); string filepath = Base64StringToImage(asplit[1], imgtype); d = d.Replace(a, filepath); } } model.Introduce = d; } model.UpdateTime = DateTime.Now; db.Entry <Tutor>(model).State = EntityState.Modified; db.Entry <Tutor>(model).Property <DateTime>(v => v.CreateTime).IsModified = false; db.Entry <Tutor>(model).Property <string>(v => v.CreatePerson).IsModified = false; db.Entry <Tutor>(model).Property <int>(v => v.IsDel).IsModified = false; db.Entry <Tutor>(model).Property <string>(v => v.TutorComment).IsModified = false; db.SaveChanges(); return("OK"); } catch (Exception) { return("No"); } }
public string AddChef(Chef requestData) { try { //string query = JsonConvert.SerializeObject(requestData); //Chef model = JsonConvert.DeserializeObject<Chef>(query); Chef model = requestData; if (model.Birthday == Convert.ToDateTime("0001/1/1 0:00:00")) { model.Birthday = Convert.ToDateTime("1900-1-1"); } var q = (from v in db.Chef where v.MemberId == model.MemberId && v.ChefActivityId == model.ChefActivityId select v ).FirstOrDefault(); if (q == null) { db.Chef.Add(model); db.SaveChanges(); return(model.ChefId.ToString()); } else { q.MemberId = model.MemberId; q.ChefActivityId = model.ChefActivityId; q.MatchRegionId = model.MatchRegionId; q.ApplyType = model.ApplyType; q.ReferrerName = model.ReferrerName; q.Birthday = model.Birthday; q.ChefPicUrl = model.ChefPicUrl; //q.ChefHotelName = model.ChefHotelName; q.ChefHotelPicUrl = model.ChefHotelPicUrl; db.Entry <Chef>(q).State = EntityState.Modified; db.SaveChanges(); string update = "update DishChef set IsApply=0 where ChefId=" + q.ChefId; dataContext.ExecuteNonQuery(CommandType.Text, update); return(q.ChefId.ToString()); } } catch (Exception) { return("No"); } }
public string UpdateIsEnable(dynamic requestDate) { try { var qchefActivity = (from v in db.ChefActivity where v.IsEnable == 1 select v).FirstOrDefault(); if (qchefActivity != null) { if (qchefActivity.IsEnable == 1) { if (qchefActivity != null) { qchefActivity.IsEnable = 0; db.Entry <ChefActivity>(qchefActivity).State = EntityState.Modified; db.SaveChanges(); } } } ChefActivity chefActivity = new ChefActivity(); chefActivity.ChefActivityId = requestDate.ChefActivityId; chefActivity.ChefActivityName = requestDate.ChefActivityName; chefActivity.IsEnable = requestDate.IsEnable; chefActivity.UpdatePerson = requestDate.UpdatePerson; chefActivity.UpdateTime = DateTime.Now; //db.Entry<ChefActivity>(chefActivity).State = EntityState.Modified; //db.Entry<ChefActivity>(chefActivity).Property("CreatePerson").IsModified = false; //db.Entry<ChefActivity>(chefActivity).Property("CreateTime").IsModified = false; //db.SaveChanges(); var sql = string.Format(@"update ChefActivity set ChefActivityName='{0}',IsEnable={1},UpdatePerson='{2}',UpdateTime='{3}' where ChefActivityId={4}", chefActivity.ChefActivityName, chefActivity.IsEnable, chefActivity.UpdatePerson, chefActivity.UpdateTime, chefActivity.ChefActivityId); dataContext.ExecuteNonQuery(CommandType.Text, sql); return("OK"); } catch (Exception e) { return("No"); } }
public string AddDishTutor(dynamic requestData) { try { string addDishTutor = JsonConvert.SerializeObject(requestData); DishTutor model = JsonConvert.DeserializeObject <DishTutor>(addDishTutor); var IsExist = (from v in db.DishTutor where v.TutorId == model.TutorId && v.DishType == model.DishType select v).FirstOrDefault(); //等于空就增加 if (IsExist == null) { if (model.DishStory.IndexOf("base64") > 0) { string d = model.DishStory; foreach (string a in imgHandel.GetHtmlImageUrlList(d)) { if (a.IndexOf(ImgHandle.DNS) < 0) { string[] asplit = a.Split(','); string imgtype = asplit[0].Substring(11, asplit[0].Length - 18); string filepath = imgHandel.Base64StringToImage(asplit[1], imgtype, "/pic/Dishtutor"); d = d.Replace(a, filepath); } } model.DishStory = d; } model.CreateTime = DateTime.Now; model.UpdateTime = DateTime.Now; model.VisitCount = 0; model.PrasieCount = 0; model.ShareCount = 0; db.DishTutor.Add(model); db.SaveChanges(); return(model.TutorDishId.ToString()); } //不为空就是修改 else { IsExist.UpdateTime = DateTime.Now; IsExist.DishName = model.DishName; IsExist.DishStory = model.DishStory; if (IsExist.DishStory.IndexOf("base64") > 0) { string d = IsExist.DishStory; foreach (string a in imgHandel.GetHtmlImageUrlList(d)) { if (a.IndexOf(ImgHandle.DNS) < 0) { string[] asplit = a.Split(','); string imgtype = asplit[0].Substring(11, asplit[0].Length - 18); string filepath = imgHandel.Base64StringToImage(asplit[1], imgtype, "/pic/Dishtutor"); d = d.Replace(a, filepath); } } IsExist.DishStory = d; } IsExist.DishPicUrl = model.DishPicUrl; IsExist.UpdatePerson = model.UpdatePerson; db.Entry <DishTutor>(IsExist).State = EntityState.Modified; db.SaveChanges(); return(IsExist.TutorDishId.ToString()); } } catch (Exception) { return("No"); } }