public ActionResult Details(Item_Master_and_woreqtVO notice) { // TODO: Add insert logic here Item_MasterDAC dac = new Item_MasterDAC(); if (dac.InsertItem_Master_and_woreqtVO(notice)) { return(RedirectToAction("Index")); //인서트가 성공적으로 됐다면. 목록으로 가라 indexview가 목록임. } else { return(RedirectToAction("Details")); } }
/// <summary> /// 생산의뢰 등록 /// </summary> /// <param name="notice"></param> /// <returns></returns> public bool InsertItem_Master_and_woreqtVO(Item_Master_and_woreqtVO notice) { string sql = "Insert into Wo_Req ( Wo_Req_No, Item_Code, Req_Qty, Prd_Plan_Date, Cust_Name, Project_Name, Sale_Emp, Req_Status, Ins_Date, Ins_Emp)" + " values( @Wo_Req_No, @Item_Code, @Req_Qty, @Prd_Plan_Date, @Cust_Name, @Project_Name, '김이박', '대기', @Ins_Date, @Ins_Emp)"; using (SqlConnection conn = new SqlConnection(Connstr)) { SqlCommand cmd = new SqlCommand(sql, conn); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Wo_Req_No", notice.Wo_Req_No); cmd.Parameters.AddWithValue("@Item_Code", notice.Item_Code); cmd.Parameters.AddWithValue("@Req_Qty", notice.Req_Qty); cmd.Parameters.AddWithValue("@Prd_Plan_Date", notice.Prd_Plan_Date); cmd.Parameters.AddWithValue("@Cust_Name", notice.Cust_Name); cmd.Parameters.AddWithValue("@Project_Name", notice.Project_Name); cmd.Parameters.AddWithValue("@Ins_Date", DateTime.Now); cmd.Parameters.AddWithValue("@Ins_Emp", UserInfo.User_Name); conn.Open(); int iResult = cmd.ExecuteNonQuery(); conn.Close(); return(iResult > 0); } }