public ActionResult ItemsAbout(string Items, string Remark, double Price, int Amount, string Puid, string Uid, string Status) { Budget_Items items = new Budget_Items(); items.Items = Items; items.Remark = Remark; items.Price = Convert.ToDecimal(Price); items.Amount = Amount; items.Total = Convert.ToInt32(Price * Amount); items.Puid = new Guid(Puid); if (Status == "create") { items.Uid = Guid.NewGuid(); new GetBudgetModel().ItemeCreate(items); return(RedirectToAction("Items", "Home", new { Puid })); } else { items.Uid = new Guid(Uid); new GetBudgetModel().ItemeUpdate(items); return(RedirectToAction("Items", "Home", new { Puid })); } }
public JsonResult InsertCustomers(List <Itemslist> customers) { string Puid = customers[0].Puid; Budget_Items item = new Budget_Items(); foreach (var oRow in customers) { // edit if (oRow.sctrl.ToString() == "X") { // 舊資料update if (!string.IsNullOrEmpty(oRow.Uid.ToString())) { item.Items = oRow.Items; item.Remark = oRow.Remark; item.Amount = oRow.Amount; item.Price = oRow.Price; item.Total = oRow.Total; item.Puid = new Guid(Puid); item.Uid = new Guid(oRow.Uid); item.sctrl = oRow.sctrl; item.eduser = Session["account"].ToString(); item.eddate = DateTime.Now; new GetBudgetModel().ItemeUpdate(item); } } else { // 舊資料update if (!string.IsNullOrEmpty(oRow.Uid)) { if (ModelState.IsValid) { item.Items = oRow.Items; item.Remark = oRow.Remark; item.Amount = oRow.Amount; item.Price = oRow.Price; item.Total = oRow.Total; item.Puid = new Guid(Puid); item.Uid = new Guid(oRow.Uid); item.sctrl = oRow.sctrl; item.eduser = Session["account"].ToString(); item.eddate = DateTime.Now; new GetBudgetModel().ItemeUpdate(item); } } else { item.Items = oRow.Items; item.Remark = oRow.Remark; item.Amount = oRow.Amount; item.Price = oRow.Price; item.Total = oRow.Total; item.Puid = new Guid(Puid); item.Uid = Guid.NewGuid(); item.sctrl = "N"; item.cruser = Session["account"].ToString(); item.crdate = DateTime.Now; new GetBudgetModel().ItemeCreate(item); } } // update Total db.UpdateTotal(Puid); } return(Json(1)); }