[ValidateAntiForgeryToken] //防止跨網站偽造請求攻擊 public ActionResult Delete(decimal Seq, string ReportType) { SI_ResearcherVisit visit = visitService.Get(Seq); if (visit != null) { visitService.Delete(visit); } //ResearcherVisitRepository.Delete(visit); try { if (ReportType.Equals("2") || ReportType.Equals("3")) { SI_StocksReport Stocks = reportService.Get(Seq); if (Stocks != null) { reportService.Delete(Stocks); } //SIReportRepository.Delete(Stocks); } } catch (Exception ex) { TempData["SuccessYN"] = "刪除失敗"; return(View("Index")); throw; } TempData["SuccessYN"] = "刪除成功"; return(RedirectToAction("Index")); }
public void Update(CreateNewViewModel CreateNewViewModel) { SI_StocksReport Stocks = SIReportRepository.Get(CreateNewViewModel.Seq); Stocks.Seq = CreateNewViewModel.Seq; Stocks.CompanyId = CreateNewViewModel.CompanyId; Stocks.CompanyName = CreateNewViewModel.CompanyName; Stocks.CapitalStock = CreateNewViewModel.CapitalStock; Stocks.ClosePrice = CreateNewViewModel.ClosePrice; Stocks.Buy_Price = CreateNewViewModel.Buy_Price; Stocks.Sell_Price = CreateNewViewModel.Sell_Price; Stocks.Targetprice = CreateNewViewModel.Targetprice; if (CreateNewViewModel.PER == null) { Stocks.PER = 0; } else { Stocks.PER = CreateNewViewModel.PER; } if (CreateNewViewModel.PBR == null) { Stocks.PBR = 0; } else { Stocks.PBR = CreateNewViewModel.PBR; } if (CreateNewViewModel.EPS_ThisYear == null) { Stocks.EPS_ThisYear = 0; } else { Stocks.EPS_ThisYear = CreateNewViewModel.EPS_ThisYear; } if (CreateNewViewModel.EPS_NextYear == null) { Stocks.EPS_NextYear = 0; } else { Stocks.EPS_NextYear = CreateNewViewModel.EPS_NextYear; } Stocks.Reason = CreateNewViewModel.Reason; Stocks.ReportType_BS = CreateNewViewModel.ReportType_BS; Stocks.Flag = "Y"; Stocks.Next_Flag = "E"; Stocks.CreateUser = "******"; Stocks.CreateDate = DateTime.Now; SIReportRepository.Update(Stocks); }
public void Create(CreateNewViewModel CreateNewViewModel) { //var num = ResearcherVisitRepository.GetAll().Select(x => x.Seq).Max() ; SI_StocksReport Stocks = new SI_StocksReport(); Stocks.Seq = CreateNewViewModel.Seq; Stocks.CompanyId = CreateNewViewModel.CompanyId; Stocks.CompanyName = CreateNewViewModel.CompanyName; Stocks.CapitalStock = CreateNewViewModel.CapitalStock; Stocks.ClosePrice = CreateNewViewModel.ClosePrice; Stocks.Buy_Price = CreateNewViewModel.Buy_Price; Stocks.Sell_Price = CreateNewViewModel.Sell_Price; Stocks.Targetprice = CreateNewViewModel.Targetprice; if (CreateNewViewModel.PER == null) { Stocks.PER = 0; } else { Stocks.PER = CreateNewViewModel.PER; } if (CreateNewViewModel.PBR == null) { Stocks.PBR = 0; } else { Stocks.PBR = CreateNewViewModel.PBR; } if (CreateNewViewModel.EPS_ThisYear == null) { Stocks.EPS_ThisYear = 0; } else { Stocks.EPS_ThisYear = CreateNewViewModel.EPS_ThisYear; } if (CreateNewViewModel.EPS_NextYear == null) { Stocks.EPS_NextYear = 0; } else { Stocks.EPS_NextYear = CreateNewViewModel.EPS_NextYear; } Stocks.Reason = CreateNewViewModel.Reason; Stocks.ReportType_BS = CreateNewViewModel.ReportType_BS; Stocks.Flag = "Y"; Stocks.Next_Flag = "E"; Stocks.CreateUser = "******"; Stocks.CreateDate = DateTime.Now; SIReportRepository.Create(Stocks); }
public ActionResult Edit(decimal Seq) { CreateNewViewModel CreateNewViewModel = new CreateNewViewModel(); SI_ResearcherVisit VisitTemp = visitService.Get(Seq); if (VisitTemp == null) { return(HttpNotFound()); //404查無此頁面 } CreateSelectList(); CreateNewViewModel.DataDate = VisitTemp.DataDate; CreateNewViewModel.CompanyId = VisitTemp.CompanyId; CreateNewViewModel.CompanyName = VisitTemp.CompanyName; CreateNewViewModel.ReportType = VisitTemp.ReportType; CreateNewViewModel.EmpName = VisitTemp.EmpName; CreateNewViewModel.CreateDate = VisitTemp.CreateDate; CreateNewViewModel.CreateUserId = VisitTemp.CreateUserId; if (CreateNewViewModel.ReportType.Equals("2") || CreateNewViewModel.ReportType.Equals("3")) { SI_StocksReport ReportTemp = reportService.Get(Seq); if (ReportTemp != null) { CreateNewViewModel.CapitalStock = ReportTemp.CapitalStock; CreateNewViewModel.Reason = ReportTemp.Reason; CreateNewViewModel.ClosePrice = ReportTemp.ClosePrice; CreateNewViewModel.PER = ReportTemp.PER; CreateNewViewModel.PBR = ReportTemp.PBR; CreateNewViewModel.EPS_ThisYear = ReportTemp.EPS_ThisYear; CreateNewViewModel.EPS_NextYear = ReportTemp.EPS_NextYear; CreateNewViewModel.Targetprice = ReportTemp.Targetprice; CreateNewViewModel.ReportType_BS = ReportTemp.ReportType_BS; CreateNewViewModel.Flag = ReportTemp.Flag; CreateNewViewModel.Buy_Price = ReportTemp.Buy_Price; CreateNewViewModel.Sell_Price = ReportTemp.Sell_Price; CreateNewViewModel.CreateUser = ReportTemp.CreateUser; CreateNewViewModel.Next_Flag = ReportTemp.Next_Flag; } } return(View(CreateNewViewModel)); }
public CreateNewViewModel GetEntity(SI_StocksReport ReportTemp) { //SI_StocksReport ReportTemp = this.Get(Seq); CreateNewViewModel CreateNewViewModel = new CreateNewViewModel(); CreateNewViewModel.Seq = ReportTemp.Seq; CreateNewViewModel.CapitalStock = ReportTemp.CapitalStock; CreateNewViewModel.Reason = ReportTemp.Reason; CreateNewViewModel.ClosePrice = ReportTemp.ClosePrice; CreateNewViewModel.PER = ReportTemp.PER; CreateNewViewModel.PBR = ReportTemp.PBR; CreateNewViewModel.EPS_ThisYear = ReportTemp.EPS_ThisYear; CreateNewViewModel.EPS_NextYear = ReportTemp.EPS_NextYear; CreateNewViewModel.Targetprice = ReportTemp.Targetprice; CreateNewViewModel.ReportType_BS = ReportTemp.ReportType_BS; CreateNewViewModel.Flag = ReportTemp.Flag; CreateNewViewModel.Buy_Price = ReportTemp.Buy_Price; CreateNewViewModel.Sell_Price = ReportTemp.Sell_Price; CreateNewViewModel.CreateUser = ReportTemp.CreateUser; CreateNewViewModel.Next_Flag = ReportTemp.Next_Flag; return(CreateNewViewModel); }
[ValidateAntiForgeryToken] //防止跨網站偽造請求攻擊 public ActionResult Edit(CreateNewViewModel CreateNewViewModel) { //using (var db = new FirstModel()) //{ //SI_ResearcherVisit visit = ResearcherVisitRepository.Get(CreateNewViewModel.Seq); SI_ResearcherVisit visit = visitService.Get(CreateNewViewModel.Seq); try { //visit.Seq = CreateNewViewModel.Seq; //visit.DataDate = CreateNewViewModel.DataDate; //visit.CompanyId = CreateNewViewModel.CompanyId; //visit.CompanyName = CreateNewViewModel.CompanyName; //visit.ReportType = CreateNewViewModel.ReportType; //visit.EmpName = CreateNewViewModel.EmpName; //visit.CreateDate = DateTime.Now; //visit.CreateUserId = "01520"; //ResearcherVisitRepository.Update(visit); visitService.Update(CreateNewViewModel); if (CreateNewViewModel.ReportType.Equals("2") || CreateNewViewModel.ReportType.Equals("3")) { SI_StocksReport Stocks = reportService.Get(CreateNewViewModel.Seq); if (Stocks == null) { if (CreateNewViewModel.ReportType_BS.Equals("K") || CreateNewViewModel.ReportType_BS.Equals("S")) { ModelState.Remove("Buy_Price"); ModelState.Remove("Targetprice"); } else if (CreateNewViewModel.ReportType_BS.Equals("R")) { ModelState.Remove("Buy_Price"); ModelState.Remove("Sell_Price"); ModelState.Remove("Targetprice"); ModelState.Remove("Reason"); } else if (CreateNewViewModel.ReportType_BS.Equals("B")) { ModelState.Remove("Sell_Price"); } if (ModelState.IsValid) { reportService.Create(CreateNewViewModel); //Stocks = new SI_StocksReport(); //Stocks.Seq = CreateNewViewModel.Seq; //Stocks.CompanyId = CreateNewViewModel.CompanyId; //Stocks.CompanyName = CreateNewViewModel.CompanyName; //Stocks.CapitalStock = CreateNewViewModel.CapitalStock; //Stocks.ClosePrice = CreateNewViewModel.ClosePrice; //Stocks.Buy_Price = CreateNewViewModel.Buy_Price; //Stocks.Sell_Price = CreateNewViewModel.Sell_Price; //Stocks.Targetprice = CreateNewViewModel.Targetprice; //if (CreateNewViewModel.PER == null) //{ // Stocks.PER = 0; //} //else //{ // Stocks.PER = CreateNewViewModel.PER; //} //if (CreateNewViewModel.PBR == null) //{ // Stocks.PBR = 0; //} //else //{ // Stocks.PBR = CreateNewViewModel.PBR; //} //if (CreateNewViewModel.EPS_ThisYear == null) //{ // Stocks.EPS_ThisYear = 0; //} //else //{ // Stocks.EPS_ThisYear = CreateNewViewModel.EPS_ThisYear; //} //if (CreateNewViewModel.EPS_NextYear == null) //{ // Stocks.EPS_NextYear = 0; //} //else //{ // Stocks.EPS_NextYear = CreateNewViewModel.EPS_NextYear; //} //Stocks.Reason = CreateNewViewModel.Reason; //Stocks.ReportType_BS = CreateNewViewModel.ReportType_BS; //Stocks.Flag = "Y"; //Stocks.Next_Flag = "E"; //Stocks.CreateUser = "******"; //Stocks.CreateDate = DateTime.Now; //SIReportRepository.Create(Stocks); TempData["SuccessYN"] = "修改成功"; return(RedirectToAction("Index")); } } else { if (CreateNewViewModel.ReportType_BS.Equals("K") || CreateNewViewModel.ReportType_BS.Equals("S")) { ModelState.Remove("Buy_Price"); ModelState.Remove("Targetprice"); } else if (CreateNewViewModel.ReportType_BS.Equals("R")) { ModelState.Remove("Buy_Price"); ModelState.Remove("Sell_Price"); ModelState.Remove("Targetprice"); ModelState.Remove("Reason"); } else if (CreateNewViewModel.ReportType_BS.Equals("B")) { ModelState.Remove("Sell_Price"); } if (ModelState.IsValid) { reportService.Update(CreateNewViewModel); //Stocks.Seq = CreateNewViewModel.Seq; //Stocks.CompanyId = CreateNewViewModel.CompanyId; //Stocks.CompanyName = CreateNewViewModel.CompanyName; //Stocks.CapitalStock = CreateNewViewModel.CapitalStock; //Stocks.ClosePrice = CreateNewViewModel.ClosePrice; //Stocks.Buy_Price = CreateNewViewModel.Buy_Price; //Stocks.Sell_Price = CreateNewViewModel.Sell_Price; //Stocks.Targetprice = CreateNewViewModel.Targetprice; //if (CreateNewViewModel.PER == null) //{ // Stocks.PER = 0; //} //else //{ // Stocks.PER = CreateNewViewModel.PER; //} //if (CreateNewViewModel.PBR == null) //{ // Stocks.PBR = 0; //} //else //{ // Stocks.PBR = CreateNewViewModel.PBR; //} //if (CreateNewViewModel.EPS_ThisYear == null) //{ // Stocks.EPS_ThisYear = 0; //} //else //{ // Stocks.EPS_ThisYear = CreateNewViewModel.EPS_ThisYear; //} //if (CreateNewViewModel.EPS_NextYear == null) //{ // Stocks.EPS_NextYear = 0; //} //else //{ // Stocks.EPS_NextYear = CreateNewViewModel.EPS_NextYear; //} //Stocks.Reason = CreateNewViewModel.Reason; //Stocks.ReportType_BS = CreateNewViewModel.ReportType_BS; //Stocks.Flag = "Y"; //Stocks.Next_Flag = "E"; //Stocks.CreateUser = "******"; //Stocks.CreateDate = DateTime.Now; //SIReportRepository.Update(Stocks); TempData["SuccessYN"] = "修改成功"; return(RedirectToAction("Index")); } } } else { SI_StocksReport Stocks = reportService.Get(CreateNewViewModel.Seq); if (Stocks != null) { reportService.Delete(Stocks); } } TempData["SuccessYN"] = "修改成功"; log.Info("修改成功--" + CreateNewViewModel); return(RedirectToAction("Index")); } catch (Exception ex) { CreateSelectList(); TempData["SuccessYN"] = "修改失敗"; return(View(CreateNewViewModel)); throw; } //} }
public void Delete(SI_StocksReport Stocks) { //SI_StocksReport Stocks = SIReportRepository.Get(Seq); SIReportRepository.Delete(Stocks); }