public ActionResult IndexPartialAddNew([Bind(Include = "GG,DS,QT,Date")] tcpjw3.oa.Models.QuoteStatistic item) { var model = db.QuoteStatistic; item.XS = item.DS; item.Type = 1; var fixItem = model.FirstOrDefault(it => it.Date.CompareTo(item.Date.ToString("yyyy-MM-dd")) >= 0 && it.Date.CompareTo(item.Date.AddDays(1).ToString("yyyy-MM-dd")) <= 0); if (fixItem == null) { if (ModelState.IsValid) { try { model.Add(item); db.SaveChanges(); } catch (Exception e) { ViewData["EditError"] = e.Message; } } else { ViewData["EditError"] = "Please, correct all errors."; } } else { ViewData["EditError"] = "该日期已经添加过了."; } return(PartialView("_IndexPartial", model.OrderByDescending(i => i.Date))); }
public ActionResult ShowAritclesGVPartialAddNew(tcpjw3.oa.Models.NewsList item) { var model = db.NewsList; if (ModelState.IsValid) { try { model.Add(item); db.SaveChanges(); } catch (Exception e) { ViewData["EditError"] = e.Message; } } else { ViewData["EditError"] = "Please, correct all errors."; } return(PartialView("_ShowAritclesGVPartial", model.ToList())); }
//[Bind(Include = "ProvinceID,CityID")] public ActionResult IndexPartialUpdate(tcpjw3.oa.Models.TicketDiscount item, FormCollection Form) { //string aa = Form["ProvinceID"].ToString(); string cbPush = Form["dASPxCheckBoxPush"].ToString();//C-选中 I-未选中 string cbData = Form["cbDate"].ToString(); //string aa = Form["comboCs"].ToString(); List <viewUserDetail> agentList = new List <viewUserDetail>(); List <TicketPush> pushList = new List <TicketPush>(); var model = db.TicketDiscount; if (ModelState.IsValid) { try { var modelItem = model.FirstOrDefault(it => it.TicketID == item.TicketID); if (modelItem != null) { this.UpdateModel(modelItem);//修改模型必须在此之后 modelItem.TicketCategory = StaticDictiory.getCategory((int)modelItem.TicketType, modelItem.TicketPrice); modelItem.TermType = StaticDictiory.getTerm((int)modelItem.TicketType, (int)modelItem.TicketCategory, Convert.ToDateTime(Convert.ToDateTime(modelItem.PublishTime).ToString("yyyy-MM-dd 23:59:59"))); modelItem.TicketEndTime = Convert.ToDateTime(Convert.ToDateTime(modelItem.TicketEndTime).ToString("yyyy-MM-dd 23:59:59")); modelItem.AuditTime = DateTime.Now; modelItem.AuditorID = 0; modelItem.AuditorName = "管理员"; #region 审核通过 if (item.AuditState == 2) { #region if (modelItem.TradeState == 128) { string yyTime = string.Format("{0} {1}:00", DateTime.Now.ToString("yyyy-MM-dd"), cbData); modelItem.YykbTime = Convert.ToDateTime(yyTime); } else if (modelItem.TradeState == 1) { modelItem.JjzTime = DateTime.Now; modelItem.YykbTime = DateTime.Now; } switch (modelItem.TradeState) { case 128: #region 推送实体 if (cbPush == "C") { agentList = db.viewUserDetail.ToList(); foreach (viewUserDetail agent in agentList) { TicketPush push = new TicketPush(); push.BankName = modelItem.BankName; push.BankType = modelItem.BankType; push.CityID = modelItem.CityID; push.ProvinceID = modelItem.ProvinceID; push.PushTime = DateTime.Now; push.State = 1;//新推送 push.TermType = modelItem.TermType; push.TicketType = (int)modelItem.TicketType; push.TicketCategory = modelItem.TicketCategory; push.TicketEndTime = (DateTime)modelItem.TicketEndTime; push.TicketID = modelItem.TicketID; push.TicketPrice = modelItem.TicketPrice; push.ToUserID = agent.ID; push.UserID = modelItem.UserID; pushList.Add(push); } } #endregion #region 推送 -- 票源推送, 电票, 预约开标 #endregion break; case 1: #region 给上传汇票的用户发送审核通过提醒 #endregion #region 推送实体 if (cbPush == "C") { agentList = db.viewUserDetail.ToList(); foreach (viewUserDetail agent in agentList) { TicketPush push = new TicketPush(); push.BankName = modelItem.BankName; push.BankType = modelItem.BankType; push.CityID = modelItem.CityID; push.ProvinceID = modelItem.ProvinceID; push.PushTime = DateTime.Now; push.State = 1;//新推送 push.TermType = modelItem.TermType; push.TicketType = (int)modelItem.TicketType; push.TicketCategory = modelItem.TicketCategory; push.TicketEndTime = (DateTime)modelItem.TicketEndTime; push.TicketID = modelItem.TicketID; push.TicketPrice = modelItem.TicketPrice; push.ToUserID = agent.ID; push.UserID = modelItem.UserID; pushList.Add(push); } } #endregion #region 推送 -- 票源审核通知, 电票, 竞价中 #endregion break; } #endregion #region 新增推送 var pushModel = db.TicketPush; foreach (TicketPush push in pushList) { pushModel.Add(push); } #endregion } #endregion else if (item.AuditState == 4) #region 审核不通过 { if (string.IsNullOrEmpty(modelItem.BankName)) { modelItem.BankName = "未填写"; } #region 给发票人发送消息推送 #endregion } #endregion db.SaveChanges(); } } catch (Exception e) { ViewData["EditError"] = e.Message; } var query = (from discount in db.TicketDiscount join pro in db.SysStatic on discount.ProvinceID equals pro.Value.ToString() join city in db.SysStatic on discount.CityID equals city.Value.ToString() where discount.UploadChannel.Equals(2) //orderby discount.PublishTime descending select new { #region MyRegion CityName = city.Text, ProvinceName = pro.Text, discount.TicketID, discount.TicketType, discount.BankType, discount.BankName, discount.TicketCategory, discount.TermType, discount.TicketPrice, discount.TicketStartTime, discount.TicketEndTime, discount.TicketFaceImg, discount.TicketBackImg, discount.ProvinceID, discount.CityID, discount.TradeState, discount.PublishTime, discount.LastEditTime, discount.UserID, discount.UserName, discount.AuditorID, discount.PublishTunes, discount.AuditTime, discount.AuditNote, discount.AuditorName, discount.AuditState, discount.BidPrice, discount.BidId, discount.ToAccount, discount.Hits, discount.UserNote, discount.UploadChannel, discount.JjzTime, #endregion } ).Distinct().OrderByDescending(p => p.PublishTime); return(Content("<script>alert('编辑成功!');window.parent.location.href='/Discount/Index'</script>")); } else { ViewData["EditError"] = "Please, correct all errors."; var query = (from discount in db.TicketDiscount join pro in db.SysStatic on discount.ProvinceID equals pro.Value.ToString() join city in db.SysStatic on discount.CityID equals city.Value.ToString() where discount.UploadChannel.Equals(2) //orderby discount.PublishTime descending select new { #region MyRegion CityName = city.Text, ProvinceName = pro.Text, discount.TicketID, discount.TicketType, discount.BankType, discount.BankName, discount.TicketCategory, discount.TermType, discount.TicketPrice, discount.TicketStartTime, discount.TicketEndTime, discount.TicketFaceImg, discount.TicketBackImg, discount.ProvinceID, discount.CityID, discount.TradeState, discount.PublishTime, discount.LastEditTime, discount.UserID, discount.UserName, discount.AuditorID, discount.PublishTunes, discount.AuditTime, discount.AuditNote, discount.AuditorName, discount.AuditState, discount.BidPrice, discount.BidId, discount.ToAccount, discount.Hits, discount.UserNote, discount.UploadChannel, discount.JjzTime, #endregion } ).Distinct().OrderByDescending(p => p.PublishTime); return(Content("<script>alert('编辑失败!');window.parent.location.href='/Discount/Index'</script>")); } //return RedirectToAction("Index"); //return null; //return PartialView("DiscountTicketInformation", query.ToList()); }