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