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