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));
}
