public ActionResult NewCellType(AsrsWarehouseModel model) { using (SqlConnection sql = new SqlConnection(AsrsHMIApplication.MSSQL_CONNECT_STRING)) { try { sql.Open(); string query = $"INSERT INTO [cell_costum_type] ([type_id], [color]) VALUES ('{model.CostumCellType.CellTypeId}', '{((model.CostumCellType.CellTypeColor.StartsWith("#")) ? model.CostumCellType.CellTypeColor.Substring(1) : model.CostumCellType.CellTypeColor)}');"; SqlCommand cmd = new SqlCommand(query, sql); bool isSuccess = cmd.ExecuteNonQuery() > 0; if (isSuccess) { return(RedirectToAction("Index", "AsrsWarehouse")); } else { ViewBag.Error = "無新增動作"; return(PartialView("~/Views/Shared/Error.cshtml")); } } catch (Exception e) { Console.WriteLine(e.Message); ViewBag.Error = e.Message; return(PartialView("~/Views/Shared/Error.cshtml")); } finally { sql.Close(); } } }
// GET: AsrsWarehouse public async Task <ActionResult> Index(int currentRow = 1) { ViewBag.CurrentRow = currentRow; var response = JsonConvert.DeserializeObject <JObject>(await HttpHelper.GETRequest("http://localhost:32000/km/warehouse/info")); ViewBag.Row = response["isSuccess"].Value <bool>() ? response["Data"]["ROW"].Value <int>() : 10; ViewBag.Bay = response["isSuccess"].Value <bool>() ? response["Data"]["BAY"].Value <int>() : 10; ViewBag.Level = response["isSuccess"].Value <bool>() ? response["Data"]["LEVEL"].Value <int>() : 10; AsrsWarehouseModel model = new AsrsWarehouseModel() { CostumCellTypeList = JsonConvert.DeserializeObject <List <CostumCellTypeModel> >(this.GetCostumCellTypeList()) }; return(View(model)); }