public IActionResult viewProduct(string id) { productModel pd = new productModel(); pd.select_product("pd_id = '" + id + "'"); ViewData["pd_id"] = id; ViewData["pd_img"] = pd.pd_img; ViewData["pd_code"] = pd.pd_code; ViewData["pd_name"] = pd.pd_name; ViewData["pd_color"] = pd.pd_color; ViewData["pd_width"] = pd.pd_width; ViewData["pd_long"] = pd.pd_long; ViewData["pd_detail"] = pd.pd_detail; ViewData["pd_price"] = pd.pd_price; ViewData["pd_sale"] = pd.pd_sale; groupPoductModel gp = new groupPoductModel(); ViewData["gp"] = gp.drop_gp(pd.pd_ref_group_product); ViewData["gp_2"] = gp.drop_gp(pd.pd_ref_group_product_sale); unitModel un = new unitModel(); ViewData["unit"] = un.drop_unit(pd.pd_unit); return(View()); }
public void del_gp(string id) { groupPoductModel gp = new groupPoductModel(); gp.gp_id = id; gp.del_gp(); }
public string select_gp(string id) { groupPoductModel gp = new groupPoductModel(); gp.select_gp("gp_id = '" + id + "'"); return(gp.gp_code + "^" + gp.gp_name + "^" + gp.gp_unit + "^" + gp.gp_type_cal); }
public string gp_code(string id) { groupPoductModel gp = new groupPoductModel(); gp.gp_code = id; gp.check_code(); return(gp.count); }
public IActionResult insert_gp(string gp_code, string gp_name, string gp_unit, string gp_cal) { groupPoductModel gp = new groupPoductModel(); gp.gp_code = gp_code; gp.gp_name = gp_name; gp.gp_unit = gp_unit; gp.gp_type_cal = gp_cal; gp.insert_gp(); return(RedirectToAction("groupProduct", "Information")); }
public IActionResult addProduct() { groupPoductModel gp = new groupPoductModel(); ViewData["gp"] = gp.drop_gp(""); unitModel un = new unitModel(); ViewData["unit"] = un.drop_unit(""); return(View()); }
public IActionResult update_gp(string gp_code_edit, string gp_name_edit, string gp_unit_edit, string gp_cal_edit, string gp_id) { groupPoductModel gp = new groupPoductModel(); gp.gp_id = gp_id; gp.gp_code = gp_code_edit; gp.gp_name = gp_name_edit; gp.gp_unit = gp_unit_edit; gp.gp_type_cal = gp_cal_edit; gp.update_gp(); return(RedirectToAction("groupProduct", "Information")); }
public IActionResult addFormula() { groupPoductModel gp = new groupPoductModel(); ViewData["group_product"] = gp.drop_gp(""); groupMaterialModel gm = new groupMaterialModel(); ViewData["group_material"] = gm.drop_gm(""); unitModel ut = new unitModel(); ViewData["unit"] = ut.drop_unit(""); return(View()); }
public IActionResult editFormula(string id) { FormulaModel fm = new FormulaModel(); fm.select_formula("fm_id = '" + id + "'"); groupPoductModel gp = new groupPoductModel(); ViewData["group_product"] = gp.drop_gp(fm.fm_ref_group_product_id); groupMaterialModel gm = new groupMaterialModel(); ViewData["group_material"] = gm.drop_gm(fm.fm_ref_group_material_id); unitModel ut = new unitModel(); ViewData["unit"] = ut.drop_unit(fm.fm_ref_unit_id); ViewData["fm_id"] = id; checkVal ck = new checkVal(); ViewData["result_width"] = ck.turnTF(fm.fm_result_width); ViewData["result_long"] = ck.turnTF(fm.fm_result_long); ViewData["width_action_a"] = ck.ckFormula(fm.fm_width_action_a); ViewData["width_action_a_val"] = fm.fm_width_action_a_val; ViewData["width_action_b"] = ck.ckFormula(fm.fm_width_action_b); ViewData["width_action_b_val"] = fm.fm_width_action_b_val; ViewData["long_action_a"] = ck.ckFormula(fm.fm_long_action_a); ViewData["long_action_a_val"] = fm.fm_long_action_a_val; ViewData["long_action_b"] = ck.ckFormula(fm.fm_long_action_b); ViewData["long_action_b_val"] = fm.fm_long_action_b_val; ViewData["result_num"] = ck.turnTF(fm.fm_result_num); ViewData["width_x_long"] = fm.fm_width_x_long; ViewData["use_num"] = fm.fm_use_num; return(View()); }