public void del_shelf(string id) { shelfModel sh = new shelfModel(); sh.shelf_id = id; sh.del_shelf(); }
public string select_shelf(string id) { shelfModel sh = new shelfModel(); sh.select_shelf("shelf_id = '" + id + "'"); return(sh.shelf_code + "^" + sh.shelf_ref_store + "^" + sh.shelf_name); }
public IActionResult update_shelf(string sh_store_edit, string sh_name_edit, string sh_id) { shelfModel sh = new shelfModel(); sh.shelf_id = sh_id; sh.shelf_name = sh_name_edit; sh.shelf_ref_store = sh_store_edit; sh.update_shelf(); return(RedirectToAction("shelf", "Information")); }
public IActionResult insert_shelf(string sh_store, string sh_name) { shelfModel sh = new shelfModel(); sh.create_code(); sh.shelf_name = sh_name; sh.shelf_ref_store = sh_store; sh.insert_shelf(); return(RedirectToAction("shelf", "Information")); }
public IActionResult shelf() { shelfModel sh = new shelfModel(); sh.create_code(); ViewData["sh_code"] = sh.shelf_code; ViewData["shelf"] = sh.list_shelf(); StoreModel st = new StoreModel(); ViewData["store"] = st.drop_store(""); return(View()); }
public IActionResult viewMaterial(string id) { ViewData["mtr_id"] = id; MaterialModel mt = new MaterialModel(); mt.select_mtr("mtr_id = '" + id + "'"); ViewData["mtr_img"] = mt.mtr_img; ViewData["mtr_code"] = mt.mtr_code; ViewData["mtr_name"] = mt.mtr_name; ViewData["mtr_detail"] = mt.mtr_detail; ViewData["mtr_keep_num"] = mt.mtr_keep_num; ViewData["mtr_width"] = mt.mtr_width; ViewData["mtr_long"] = mt.mtr_long; ViewData["mtr_side"] = mt.mtr_side; ViewData["mtr_roll"] = mt.mtr_roll; ViewData["mtr_noti"] = mt.mtr_noti; ViewData["mtr_noti_min"] = mt.mtr_noti_min; ViewData["mtr_noti_max"] = mt.mtr_noti_max; groupMaterialModel gm = new groupMaterialModel(); ViewData["group_material"] = gm.drop_gm(mt.mtr_ref_tm_id); unitModel un = new unitModel(); ViewData["unit_get"] = un.drop_unit(mt.mtr_unit_get); ViewData["unit_expose"] = un.drop_unit(mt.mtr_unit_expose); stickerModel stk = new stickerModel(); ViewData["sticker"] = stk.drop_con_pay(mt.mtr_sticker); shelfModel sh = new shelfModel(); ViewData["shelf"] = sh.drop_shelf(mt.mtr_shelf); return(View()); }
public IActionResult addMaterial() { groupMaterialModel gm = new groupMaterialModel(); ViewData["group_material"] = gm.drop_gm(""); unitModel un = new unitModel(); ViewData["unit"] = un.drop_unit(""); stickerModel stk = new stickerModel(); ViewData["sticker"] = stk.drop_con_pay(""); shelfModel sh = new shelfModel(); ViewData["shelf"] = sh.drop_shelf(""); return(View()); }