public bool editConsumable(ConsumableMaterialModel item) { string connString = ConfigurationManager.ConnectionStrings["consumable"].ConnectionString; OleDbConnection oledb = new OleDbConnection(connString); try { oledb.Open(); OleDbCommand command = new OleDbCommand("UPDATE [Sheet1$] SET [耗材名稱] = '" + item.materialName + "',[ECS系統料號] = '" + item.materialECSCode + "',[ECS名稱] = '" + item.materialECSName + "',[型號] = '" + item.materialSpecification + "',[單位] = '" + item.materialUnit + "',[存放位置] = '" + item.materialStorageLocation + "',[適用機種] = '" + item.materialKind + "',[廠家] = '" + item.materialSupplier + "',[參考價值] = '" + item.materialReferenceValue + "',[購買] = '" + item.materialTimeCanGet + "',[請購數量] = '" + item.materialQuantity + "',[安全] = '" + item.materialSafety + "',[領用數量] = '" + item.materialNumberRecipient + "',[退庫良品數量] = '" + item.materialGoodNumberReturn + "',[退庫不良數量] = '" + item.materialBadNumberReturn + "',[庫存] = '" + (Int32.Parse(item.materialQuantity) - Int32.Parse(item.materialNumberRecipient) + Int32.Parse(item.materialGoodNumberReturn)).ToString() + "',[備註] = '" + item.materialRemark + "',[ImagePath] = '" + item.materialImagePath + "' WHERE [耗材料號] = '" + item.materialCode + "'", oledb); int result = command.ExecuteNonQuery(); if (result > 0) { return(true); } else { return(false); } } catch (Exception ex) { return(false); } finally { oledb.Close(); } }
public ActionResult AddOrEditConsumable(string id) { ConsumableMaterialModel emp = new ConsumableMaterialModel(); JSONReadWrite ex = new JSONReadWrite(); emp = ex.getConsumableById(id); return(View(emp)); }
public ActionResult AddOrEditConsumable(ConsumableMaterialModel model) { try { if (Int32.Parse(model.materialNumberRecipient) > Int32.Parse(model.materialQuantity)) { return(Json(new { success = false, message = "Value of 領用數量 cannot be greqter than 請購數量" }, JsonRequestBehavior.AllowGet)); } if (Int32.Parse(model.materialGoodNumberReturn) > Int32.Parse(model.materialNumberRecipient)) { return(Json(new { success = false, message = "Value of 退庫良品數量 cannot be greqter than 領用數量" }, JsonRequestBehavior.AllowGet)); } if (Int32.Parse(model.materialBadNumberReturn) > Int32.Parse(model.materialNumberRecipient)) { return(Json(new { success = false, message = "Value of 退庫不良數量 cannot be greqter than 領用數量" }, JsonRequestBehavior.AllowGet)); } if (model.ImageUpload != null && model.materialImagePath != null) { string fileName = Path.GetFileNameWithoutExtension(model.ImageUpload.FileName); string extension = Path.GetExtension(model.ImageUpload.FileName); fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension; model.materialImagePath = "~/AppFiles/Images/" + fileName; model.ImageUpload.SaveAs(Path.Combine(Server.MapPath("~/AppFiles/Images/"), fileName)); } JSONReadWrite ex = new JSONReadWrite(); if (!ex.checkCodeExistOrNot(model.materialCode)) { var result = ex.addNewConsumable(model); if (result) { return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAlll", GetAllConsumableMaterial()), message = "Submitted Successfully" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, message = "Add new Fail" }, JsonRequestBehavior.AllowGet)); } } else { var result = ex.editConsumable(model); if (result) { return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAlll", GetAllConsumableMaterial()), message = "Submitted Successfully" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, message = "Edit Fail" }, JsonRequestBehavior.AllowGet)); } } } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public bool addNewConsumable(ConsumableMaterialModel prod) { var path = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/AppFiles/Database/ComsumableItem.json")); string jsonResult = Read(path); List <ConsumableMaterialModel> list = JsonConvert.DeserializeObject <List <ConsumableMaterialModel> >(jsonResult); list.Add(prod); string jSONString = JsonConvert.SerializeObject(list, Formatting.Indented); Write(path, jSONString); return(true); }
public ConsumableMaterialModel getConsumableById(string id) { ConsumableMaterialModel model = new ConsumableMaterialModel(); string connString = ConfigurationManager.ConnectionStrings["consumable"].ConnectionString; OleDbConnection oledb = new OleDbConnection(connString); try { oledb.Open(); OleDbCommand command = new OleDbCommand("SELECT * FROM [Sheet1$] WHERE [耗材料號] = '" + id + "'", oledb); OleDbDataAdapter adapter = new OleDbDataAdapter(); adapter.SelectCommand = command; DataSet ds = new DataSet(); adapter.Fill(ds); model.materialCode = ds.Tables[0].Rows[0].ItemArray[0].ToString().Trim(); model.materialName = ds.Tables[0].Rows[0].ItemArray[1].ToString(); model.materialECSCode = ds.Tables[0].Rows[0].ItemArray[2].ToString(); model.materialECSName = ds.Tables[0].Rows[0].ItemArray[3].ToString(); model.materialSpecification = ds.Tables[0].Rows[0].ItemArray[4].ToString(); model.materialUnit = ds.Tables[0].Rows[0].ItemArray[5].ToString(); model.materialStorageLocation = ds.Tables[0].Rows[0].ItemArray[6].ToString(); model.materialKind = ds.Tables[0].Rows[0].ItemArray[7].ToString(); model.materialSupplier = ds.Tables[0].Rows[0].ItemArray[8].ToString(); model.materialReferenceValue = ds.Tables[0].Rows[0].ItemArray[9].ToString(); model.materialTimeCanGet = ds.Tables[0].Rows[0].ItemArray[10].ToString(); model.materialQuantity = ds.Tables[0].Rows[0].ItemArray[11].ToString(); model.materialSafety = ds.Tables[0].Rows[0].ItemArray[12].ToString(); model.materialNumberRecipient = ds.Tables[0].Rows[0].ItemArray[13].ToString(); model.materialGoodNumberReturn = ds.Tables[0].Rows[0].ItemArray[14].ToString(); model.materialBadNumberReturn = ds.Tables[0].Rows[0].ItemArray[15].ToString(); model.materialRemainQuantity = ds.Tables[0].Rows[0].ItemArray[16].ToString(); model.materialRemark = ds.Tables[0].Rows[0].ItemArray[17].ToString(); model.materialImagePath = String.IsNullOrEmpty(ds.Tables[0].Rows[0].ItemArray[18].ToString()) ? "~/AppFiles/Images/default.png" : ds.Tables[0].Rows[0].ItemArray[18].ToString(); model.needToBuyMore = (bool)(Int32.Parse(ds.Tables[0].Rows[0].ItemArray[16].ToString()) < Int32.Parse(ds.Tables[0].Rows[0].ItemArray[12].ToString())); return(model); } catch (Exception ex) { return(model); } finally { oledb.Close(); } }
public bool editConsumable(ConsumableMaterialModel item) { try { var path = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/AppFiles/Database/ComsumableItem.json")); string jsonResult = Read(path); List <ConsumableMaterialModel> list = JsonConvert.DeserializeObject <List <ConsumableMaterialModel> >(jsonResult); int index = list.FindIndex(x => x.materialCode.Equals(item.materialCode)); if (index == -1) { return(false); } list[index] = item; string jSONString = JsonConvert.SerializeObject(list, Formatting.Indented); Write(path, jSONString); return(true); } catch (Exception ex) { return(false); } }