//Insert Expense public ActionResult InsertExpense([Bind(Include = "STId,TradeType,TradeDate,UserName")] SummaryTable summaryTable, [Bind(Include = "ExCashID,UserName,ExCashType,ExAmount,ExDate,ExNote")] CashExpense cashExpense) { if (Session["User"] == null) { return(RedirectToRoute("Default", new { Controller = "Home", Action = "Index" })); } summaryTable.TradeType = cashExpense.ExCashType; summaryTable.TradeDate = cashExpense.ExDate; summaryTable.UserName = cashExpense.UserName; db.SummaryTable.Add(summaryTable); if (ModelState.IsValid) { db.CashExpense.Add(cashExpense); try { db.SaveChanges(); } catch (Exception er) { throw er; } return(RedirectToAction("Index")); } return(View(cashExpense)); }
//Insert Income public ActionResult InsertIncome([Bind(Include = "STId,TradeType,TradeDate,UserName")] SummaryTable summaryTable, [Bind(Include = "InCashID,UserName,InCashType,InAmount,InDate,InNote")] CashIncome cashIncome) { if (Session["User"] == null) { return(RedirectToRoute("Default", new { Controller = "Home", Action = "Index" })); } if (ModelState.IsValid) { var username = Convert.ToString(Session["User"]); var Esum = db.CashExpense.Sum(c => c.ExAmount).HasValue? db.CashExpense.Sum(c => c.ExAmount):0; var Isum = (db.CashIncome.Sum(c => c.InAmount) + Convert.ToInt32(cashIncome.InAmount)).HasValue? db.CashIncome.Sum(c => c.InAmount) + Convert.ToInt32(cashIncome.InAmount):0; var net = Isum - Esum; //算出現金淨值,更新至userdata的cashvalue var userdata = db.UsersData.Where(c => c.UserName == username).Select(c => c).SingleOrDefault(); userdata.CashValue = (double)net; db.Entry(userdata).State = EntityState.Modified; //新增總表資料 summaryTable.TradeType = cashIncome.InCashType; summaryTable.TradeDate = cashIncome.InDate; summaryTable.UserName = cashIncome.UserName; db.SummaryTable.Add(summaryTable); db.SaveChanges(); //新增現金資產 cashIncome.OID = summaryTable.STId; db.CashIncome.Add(cashIncome); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cashIncome)); }
public ActionResult Withdraw(Insurances insurances) { if (Session["User"] == null) { return(RedirectToRoute("Default", new { Controller = "Home", Action = "Index" })); } Insurances olddata = db.Insurances.Find(insurances.SerialNumber); olddata.Withdrawed = true; db.SaveChanges(); insurances.CashFlow = insurances.Withdrawal; insurances.PurchaseOrWithdraw = false; insurances.Withdrawed = true; insurances.RelateCash = true; insurances.UserID = Session["User"].ToString(); SummaryTable ST = new SummaryTable { TradeType = "保險", TradeDate = insurances.WithdrawDate, UserName = insurances.UserID }; db.SummaryTable.Add(ST); db.SaveChanges(); var id = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault(); insurances.STID = id; db.Insurances.Add(insurances); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Withdraw(Insurances insurances) { insurances.CashFlow = insurances.Withdrawal; insurances.PurchaseOrWithdraw = false; //insurances.UserID = Session["User"].ToString(); db.Insurances.Add(insurances); db.SaveChanges(); return(RedirectToAction("Index")); }
//Insert Income public ActionResult InsertExpense([Bind(Include = "ExCashID,UserID,ExCashType,ExAmount,ExDate,ExNote")] CashExpense cashExpense) { if (ModelState.IsValid) { db.CashExpense.Add(cashExpense); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cashExpense)); }
public ActionResult Create([Bind(Include = "SerialNumber,UserID,FundName,BuyOrSell,Fee,Units,Date,NAV,CashFlow")] Fund fund) { if (ModelState.IsValid) { db.Fund.Add(fund); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(fund)); }
//Insert Expense public ActionResult InsertExpense([Bind(Include = "STId,TradeType,TradeDate,UserName")] SummaryTable summaryTable, [Bind(Include = "ExCashID,UserName,ExCashType,ExAmount,ExDate,ExNote")] CashExpense cashExpense) { if (Session["User"] == null) { return(RedirectToRoute("Default", new { Controller = "Home", Action = "Index" })); } if (ModelState.IsValid) { var username = Convert.ToString(Session["User"]); var Esum = (db.CashExpense.Sum(c => c.ExAmount) + Convert.ToInt32(cashExpense.ExAmount)).HasValue? db.CashExpense.Sum(c => c.ExAmount) + Convert.ToInt32(cashExpense.ExAmount):0; var Isum = db.CashIncome.Sum(c => c.InAmount).HasValue? db.CashIncome.Sum(c => c.InAmount):0; var net = Isum - Esum; //如果淨資產小於零,不給新增支出項目 if (net - cashExpense.ExAmount < 0) { return(Json(net - cashExpense.ExAmount, JsonRequestBehavior.AllowGet)); } else { //更新userdata的cashvalue var userdata = db.UsersData.Where(c => c.UserName == username).Select(c => c).SingleOrDefault(); userdata.CashValue = (double)net; db.Entry(userdata).State = EntityState.Modified; //新增總表資料 summaryTable.TradeType = cashExpense.ExCashType; summaryTable.TradeDate = cashExpense.ExDate; summaryTable.UserName = cashExpense.UserName; db.SummaryTable.Add(summaryTable); //新增支出表資料 cashExpense.OID = summaryTable.STId; db.CashExpense.Add(cashExpense); try { db.SaveChanges(); } catch (Exception er) { throw er; } return(RedirectToAction("Index")); } } return(View(cashExpense)); }
//Insert Income public ActionResult InsertIncome([Bind(Include = "STId,TradeType,TradeDate,UserName")] SummaryTable summaryTable, [Bind(Include = "InCashID,UserName,InCashType,InAmount,InDate,InNote")] CashIncome cashIncome) { summaryTable.TradeType = cashIncome.InCashType; summaryTable.TradeDate = cashIncome.InDate; summaryTable.UserName = cashIncome.UserName; db.SummaryTable.Add(summaryTable); db.SaveChanges(); cashIncome.OID = summaryTable.STId; if (ModelState.IsValid) { db.CashIncome.Add(cashIncome); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cashIncome)); }
//[ValidateAntiForgeryToken] public ActionResult Create(FXtradeTable tradeTable, SummaryTable summaryTable) { if (ModelState.IsValid) { //var x = Session["User"].ToString(); //var x = "5566"; //summaryTable.UserName = x; db.SummaryTable.Add(summaryTable); db.SaveChanges(); //summaryTable.UserName = "******"; var uid = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault(); tradeTable.SummaryId = uid; db.FXtradeTable.Add(tradeTable); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tradeTable)); }
public ActionResult Create([Bind(Include = "TradeType,date,userID")] SummaryTable summaryTable, [Bind(Include = "stockID,stockPrice,stockAmount,stockTP,stockFee,stockTax,stockNetincome,stockNote")] StockHistory stockHistory) // public ActionResult Create([Bind(Include = "TradeType,userID,date")]SummaryTable summaryTable) { MyInvestEntities db = new MyInvestEntities(); if (ModelState.IsValid) { summaryTable.UserName = Session["User"].ToString(); db.SummaryTable.Add(summaryTable); db.SaveChanges(); var id = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault(); stockHistory.STId = id; db.StockHistory.Add(stockHistory); db.SaveChanges(); ViewBag.state = "ok"; return(RedirectToAction("Index")); } return(RedirectToAction("Index")); }
//Insert Income public ActionResult InsertIncome([Bind(Include = "STId,TradeType,TradeDate,UserName")] SummaryTable summaryTable, [Bind(Include = "InCashID,UserName,InCashType,InAmount,InDate,InNote")] CashIncome cashIncome) { if (Session["User"] == null) { return(RedirectToRoute("Default", new { Controller = "Home", Action = "Index" })); } summaryTable.TradeType = cashIncome.InCashType; summaryTable.TradeDate = cashIncome.InDate; summaryTable.UserName = cashIncome.UserName; db.SummaryTable.Add(summaryTable); db.SaveChanges(); cashIncome.OID = summaryTable.STId; if (ModelState.IsValid) { db.CashIncome.Add(cashIncome); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cashIncome)); }
public ActionResult Register(UsersData model) { MyInvestEntities db = new MyInvestEntities(); var member = db.UsersData.Where(c => c.UserName == model.UserName || c.Email == model.Email).FirstOrDefault(); //if (member == null) //{ //雜湊 byte[] enc = System.Text.Encoding.Default.GetBytes(model.Password); HashAlgorithm ha = HashAlgorithm.Create("SHA256"); byte[] ans = ha.ComputeHash(enc); model.Password = BitConverter.ToString(ans); model.CashValue = 0; model.StockValue = 0; model.FXValue = 0; model.InsuranceValue = 0; model.FundValue = 0; //將會員記錄新增到Users資料表 db.UsersData.Add(model); //儲存資料庫變更 try { db.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { throw ex; } Session["User"] = model.UserName; if (Session["User"].ToString() == "msit119") { return(RedirectToRoute("BStage_default", new { Controller = "BS", Action = "Index" })); } //執行Home控制器的Login動作方法 return(RedirectToRoute("Main_default", new { Controller = "Home", Action = "Index" })); }
public ActionResult ChangePasswordAdmin(ChangePasswordViewModel model) { //if (ModelState.IsValid) //{ MyInvestEntities db = new MyInvestEntities(); byte[] enc = System.Text.Encoding.Default.GetBytes(model.OPassword); HashAlgorithm ha = HashAlgorithm.Create("SHA256"); byte[] ans = ha.ComputeHash(enc); model.OPassword = BitConverter.ToString(ans); var item = db.UsersData.Where(c => c.Password == model.OPassword).FirstOrDefault(); if (item != null) { byte[] nenc = System.Text.Encoding.Default.GetBytes(model.Password); byte[] nans = ha.ComputeHash(nenc); model.Password = BitConverter.ToString(nans); item.Password = model.Password; item.RememberMe = true; try { db.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { throw ex; } return(RedirectToAction("Admin", "Account")); } else { ViewBag.Message = "原密碼錯誤"; return(View("Index2")); } }
// GET: Funds public ActionResult Index() { if (Session["User"] == null) { return(RedirectToRoute("Default", new { Controller = "Home", Action = "Index" })); } var UID = Session["User"].ToString(); var query = db.Fund.Where(F => F.UserID == UID); foreach (var item in query) { Fund fund = db.Fund.Find(item.SerialNumber); string FundName = item.FundName; var CurrentNAVstr = db.fund_data.Where(D => D.FundName == FundName).Select(D => D.FundNAV).ToArray(); double CurrentNAV = Convert.ToDouble(CurrentNAVstr[0]); fund.CurrentNAV = CurrentNAV; } db.SaveChanges(); return(View(db.Fund.ToList())); }
public ActionResult ForgotPassword(ForgotPasswordViewModel model) { //if (ModelState.IsValid) //{ MyInvestEntities db = new MyInvestEntities(); var item = db.UsersData.Where(c => (c.UserName == model.UserName && c.Email == model.Email)).FirstOrDefault(); if (item != null) { Random r = new Random(); string code = ""; for (int i = 0; i < 10; ++i) { switch (r.Next(0, 3)) { //數字0~9 case 0: code += r.Next(0, 10); break; //小寫a-z case 1: code += (char)r.Next(65, 91); break; //大寫A-Z case 2: code += (char)r.Next(97, 122); break; } } System.Net.Mail.MailMessage msg = new System.Net.Mail.MailMessage(); msg.To.Add(model.Email); //msg.CC.Add("*****@*****.**");可以抄送副本給多人 //這裡可以隨便填,不是很重要 msg.From = new MailAddress("*****@*****.**", "$$$", System.Text.Encoding.UTF8); /* 上面3個參數分別是發件人地址(可以隨便寫),發件人姓名,編碼*/ msg.Subject = "測試標題"; //郵件標題 msg.SubjectEncoding = System.Text.Encoding.UTF8; //郵件標題編碼 msg.Body = $"新密碼為:<span style='color:red'>{code}</span><br> 請依此登入重新設定密碼!"; //郵件內容 msg.BodyEncoding = System.Text.Encoding.UTF8; //郵件內容編碼 //msg.Attachments.Add(new Attachment(@"D:\test2.docx")); //附件 msg.IsBodyHtml = true; //是否是HTML郵件 //msg.Priority = MailPriority.High;//郵件優先級 SmtpClient client = new SmtpClient(); client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "msit1199"); //這裡要填正確的帳號跟密碼 client.Host = "smtp.gmail.com"; //設定smtp Server client.Port = 25; //設定Port client.EnableSsl = true; //gmail預設開啟驗證 client.Send(msg); //寄出信件 client.Dispose(); msg.Dispose(); //System.Timers.Timer timer = new System.Timers.Timer(); //timer.Enabled = true; //timer.Interval = 3000000; // 5分鐘後驗證碼失效 //timer.Start(); //timer.Elapsed += Timer_Elapsed; //timer.AutoReset = false; //return RedirectToAction("ConfirmEmail","Account"); byte[] enc = System.Text.Encoding.Default.GetBytes(code); HashAlgorithm ha = HashAlgorithm.Create("SHA256"); byte[] ans = ha.ComputeHash(enc); item.Password = BitConverter.ToString(ans); //item.Password = code; try { db.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { throw ex; } TempData["Request"] = "已於Email寄出新密碼"; TempData["Request2"] = "請以新密碼登入並修改密碼"; return(RedirectToAction("Index", "Home")); } else { ViewBag.Message = "查無此人,請確認使用者名稱或Email正確"; //return View("Index2"); return(View()); } }
public ActionResult CreateStockBuy([Bind(Include = "TradeType,TradeDate,UserName")] SummaryTable summaryTable, [Bind(Include = "stockID,stockPrice,stockAmount,stockFee,stockTax,stockTP,stockNetincome,stockNote,CashAccount")] StockHistory stockHistory, UsersData userdata) { if (Session["User"] == null) { return(RedirectToRoute("Default", new { Controller = "Home", Action = "Index" })); } if (ModelState.IsValid) { //存入總表獲得交易序號 db.SummaryTable.Add(summaryTable); db.SaveChanges(); var id = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault(); bool cashflag = false; if (stockHistory.CashAccount) { CashExpense expense = new CashExpense(); expense.OID = id; expense.UserName = summaryTable.UserName; expense.ExCashType = summaryTable.TradeType; expense.ExAmount = (stockHistory.stockNetincome) * (-1); expense.ExDate = summaryTable.TradeDate; expense.ExNote = "買進股票"; cashflag = true; db.CashExpense.Add(expense); db.SaveChanges(); } //存入股票交易紀錄表 stockHistory.STId = id; stockHistory.stockAmount = stockHistory.stockAmount * 1000; AVGCalculator calculator = new AVGCalculator(); string _username = Session["User"].ToString(); string _searchid = stockHistory.stockID.ToString(); int _invchange = (int)stockHistory.stockAmount; int _cashflow = (int)stockHistory.stockNetincome; stockHistory.stockLastAVG = calculator.GetAvg(_username, _searchid, _invchange, _cashflow); db.StockHistory.Add(stockHistory); db.SaveChanges(); //計算股票現值 var name = summaryTable.UserName; decimal pvsum = calculator.getPVsum(name); var ud = calculator.GetUserdata(name); userdata.StockValue = (double)pvsum; userdata.UserName = ud[0].UserName; userdata.CashValue = (cashflag)? (ud[0].CashValue + Math.Abs((double)stockHistory.stockNetincome)): ud[0].CashValue; userdata.Password = ud[0].Password; userdata.Email = ud[0].Email; userdata.FXValue = ud[0].FXValue; userdata.InsuranceValue = ud[0].InsuranceValue; userdata.FundValue = ud[0].FundValue; db.Entry(userdata).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(RedirectToAction("Index")); }
public void Post([FromBody] FXtradeTable tt) { dc.FXtradeTable.Add(tt); dc.SaveChanges(); }
public ActionResult Withdraw(Insurances insurances) { if (Session["User"] == null) { return(RedirectToRoute("Default", new { Controller = "Home", Action = "Index" })); } if (ModelState.IsValid) { SummaryTable ST = new SummaryTable { TradeType = "保險", TradeDate = insurances.WithdrawDate, UserName = Session["User"].ToString() }; Insurances olddata = db.Insurances.Find(insurances.SerialNumber); olddata.Withdrawed = true; db.SaveChanges(); insurances.PurchaseOrWithdraw = false; insurances.Withdrawed = true; insurances.UserID = Session["User"].ToString(); if (insurances.RelateCash == true) { insurances.CashFlow = insurances.Withdrawal; db.SummaryTable.Add(ST); db.SaveChanges(); var id = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault(); insurances.STID = id; db.Insurances.Add(insurances); db.SaveChanges(); var User = db.UsersData.Where(U => U.UserName == insurances.UserID).Select(U => U).SingleOrDefault(); User.InsuranceValue -= insurances.Withdrawal; User.CashValue += insurances.Withdrawal; db.SaveChanges(); CashIncome CI = new CashIncome { OID = id, UserName = insurances.UserID, InCashType = "保險", InAmount = insurances.CashFlow, InDate = insurances.WithdrawDate, InNote = insurances.InsuranceName + "解約金" }; db.CashIncome.Add(CI); db.SaveChanges(); return(RedirectToAction("Index")); } else { insurances.CashFlow = 0; db.SummaryTable.Add(ST); db.SaveChanges(); var id = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault(); insurances.STID = id; db.Insurances.Add(insurances); db.SaveChanges(); var User = db.UsersData.Where(U => U.UserName == insurances.UserID).Select(U => U).SingleOrDefault(); User.InsuranceValue -= insurances.Withdrawal; User.CashValue += insurances.Withdrawal; db.SaveChanges(); return(RedirectToAction("Index")); } } return(View(insurances)); }
public ActionResult CreateStockBuy([Bind(Include = "TradeType,TradeDate,UserName")] SummaryTable summaryTable, [Bind(Include = "stockID,stockPrice,stockAmount,stockFee,stockTax,stockNetincome,stockNote,CashAccount")] StockHistory stockHistory) { if (ModelState.IsValid) { //存入總表獲得交易序號 db.SummaryTable.Add(summaryTable); db.SaveChanges(); var id = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault(); if (stockHistory.CashAccount) { CashExpense expense = new CashExpense(); expense.OID = id; expense.UserName = summaryTable.UserName; expense.ExCashType = summaryTable.TradeType; expense.ExAmount = (stockHistory.stockNetincome) * (-1); expense.ExDate = summaryTable.TradeDate; expense.ExNote = "買進股票"; db.CashExpense.Add(expense); db.SaveChanges(); } //存入股票交易紀錄表 stockHistory.STId = id; stockHistory.stockAmount = stockHistory.stockAmount * 1000; db.StockHistory.Add(stockHistory); db.SaveChanges(); ViewBag.Alert = "alert('新增成功')"; return(RedirectToAction("Index")); } return(RedirectToAction("Index")); }
//[ValidateAntiForgeryToken] public ActionResult Create(FXtradeTable tradeTable, SummaryTable summaryTable, UsersData usersData) { if (ModelState.IsValid) { //存總表 db.SummaryTable.Add(summaryTable); db.SaveChanges(); //存外匯交易表 var uid = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault(); tradeTable.SummaryId = uid; db.FXtradeTable.Add(tradeTable); db.SaveChanges(); if (tradeTable.TradeClass == "賣出") { CashIncome cashincome = new CashIncome(); cashincome.UserName = Session["User"].ToString(); cashincome.OID = uid; cashincome.InCashType = summaryTable.TradeType; cashincome.InDate = summaryTable.TradeDate; cashincome.InNote = tradeTable.TradeClass; var change = tradeTable.NTD * -1; cashincome.InAmount = Convert.ToInt32(change); db.CashIncome.Add(cashincome); db.SaveChanges(); //更新個人資產表 TestHomeController th = new TestHomeController(); var name = summaryTable.UserName; var ud = th.GetUsersData(name); usersData.FXValue = th.SaveUserdata(name); usersData.UserName = ud[0].UserName; var cv = Math.Abs(tradeTable.NTD.Value); usersData.CashValue = ud[0].CashValue + tradeTable.NTD; usersData.InsuranceValue = ud[0].InsuranceValue; usersData.StockValue = ud[0].StockValue; usersData.FundValue = ud[0].FundValue; usersData.Email = ud[0].Email; usersData.Password = ud[0].Password; db.Entry(usersData).State = EntityState.Modified; db.SaveChanges(); } else { CashExpense cashexpense = new CashExpense(); cashexpense.UserName = Session["User"].ToString(); cashexpense.OID = uid; cashexpense.ExCashType = summaryTable.TradeType; cashexpense.ExDate = summaryTable.TradeDate; cashexpense.ExNote = tradeTable.TradeClass; if (tradeTable.TradeClass == "買入(不要連動新臺幣帳戶)") { cashexpense.ExAmount = 0; } else { cashexpense.ExAmount = Convert.ToInt32(tradeTable.NTD); } db.CashExpense.Add(cashexpense); db.SaveChanges(); //更新個人資產表 TestHomeController th = new TestHomeController(); var name = summaryTable.UserName; var ud = th.GetUsersData(name); usersData.FXValue = th.SaveUserdata(name); usersData.UserName = ud[0].UserName; var cv = Math.Abs(tradeTable.NTD.Value); if (tradeTable.TradeClass == "買入(不要連動新臺幣帳戶)") { usersData.CashValue = ud[0].CashValue; } else { usersData.CashValue = ud[0].CashValue - tradeTable.NTD; } usersData.InsuranceValue = ud[0].InsuranceValue; usersData.StockValue = ud[0].StockValue; usersData.FundValue = ud[0].FundValue; usersData.Email = ud[0].Email; usersData.Password = ud[0].Password; db.Entry(usersData).State = EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("Index")); } return(View(tradeTable)); }
public ActionResult CreateStockBuy([Bind(Include = "TradeType,TradeDate,UserName")] SummaryTable summaryTable, [Bind(Include = "stockID,stockPrice,stockAmount,stockFee,stockTax,stockNetincome,stockNote,CashAccount")] StockHistory stockHistory) { if (Session["User"] == null) { return(RedirectToRoute("Default", new { Controller = "Home", Action = "Index" })); } if (ModelState.IsValid) { //存入總表獲得交易序號 db.SummaryTable.Add(summaryTable); db.SaveChanges(); var id = db.SummaryTable.Select(c => c.STId).ToList().LastOrDefault(); if (stockHistory.CashAccount) { CashExpense expense = new CashExpense(); expense.OID = id; expense.UserName = summaryTable.UserName; expense.ExCashType = summaryTable.TradeType; expense.ExAmount = (stockHistory.stockNetincome) * (-1); expense.ExDate = summaryTable.TradeDate; expense.ExNote = "買進股票"; db.CashExpense.Add(expense); db.SaveChanges(); } //存入股票交易紀錄表 stockHistory.STId = id; stockHistory.stockAmount = stockHistory.stockAmount * 1000; AVGCalculator calculator = new AVGCalculator(); string _username = Session["User"].ToString(); string _searchid = stockHistory.stockID.ToString(); int _invchange = (int)stockHistory.stockAmount; int _cashflow = (int)stockHistory.stockNetincome; stockHistory.stockLastAVG = calculator.GetAvg(_username, _searchid, _invchange, _cashflow); db.StockHistory.Add(stockHistory); db.SaveChanges(); ViewBag.Alert = "alert('新增成功')"; return(RedirectToAction("Index")); } return(RedirectToAction("Index")); }