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