public bool SaveDef(Def_HistoryVO definfo) //불량 등록 { { string sql = @"insert into Def_History (Workorderno,Def_Mi_Code,Def_Date,Def_Qty,Def_Image_Name,Def_Image_Path,Ins_Emp,Up_Emp) values(@Workorderno,@Def_Mi_Code,@Def_Date,@Def_Qty,@Def_Image_Name,@Def_Image_Path,@Ins_Emp,@Up_Emp)"; using (SqlConnection conn = new SqlConnection(Connstr)) { SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@Workorderno", definfo.Workorderno); cmd.Parameters.AddWithValue("@Def_Mi_Code", definfo.Def_Mi_Code); cmd.Parameters.AddWithValue("@Def_Date", definfo.Def_Date); cmd.Parameters.AddWithValue("@Def_Qty", definfo.Def_Qty); cmd.Parameters.AddWithValue("@Def_Image_Name", definfo.FileUploadFile.FileName); cmd.Parameters.AddWithValue("@Def_Image_Path", definfo.FileUploadFilePath); cmd.Parameters.AddWithValue("@Ins_Emp", definfo.Ins_Emp); cmd.Parameters.AddWithValue("@Up_Emp", definfo.Up_Emp); conn.Open(); int iResult = cmd.ExecuteNonQuery(); conn.Close(); return(iResult > 0); } } }
public ActionResult DefectiveCreate(Def_HistoryVO definfo) { try { definfo.Up_Emp = UserInfo.User_Name; definfo.Ins_Emp = UserInfo.User_Name; string filename = definfo.FileUploadFile.FileName; var fileName = Path.GetFileName(definfo.FileUploadFile.FileName); var path = Path.Combine(Server.MapPath("~/uploads"), fileName); definfo.FileUploadFilePath = path; definfo.FileUploadFile.SaveAs(path); // TODO: Add insert logic here Def_HistoryDAC def = new Def_HistoryDAC(); if (def.SaveDef(definfo)) { return(RedirectToAction("Index", "Home")); //인서트가 성공적으로 됐다면. 목록으로 가라 indexview가 목록임. } else { return(View(definfo)); //인서트가성공안되면 내가 써논 값을 가지고 create를 하기위해서 } } catch (Exception err) { string sss = err.Message; return(View()); } }