public bool InsertNonOperationMa(NonOperationVO vo) { int CheckNum = 0; using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = new SqlConnection(ConnectionString); cmd.CommandText = @"Insert into Nop_Ma_Master(Nop_Ma_Code, Nop_Ma_Name, Use_YN, Ins_Date, Ins_Emp, Up_Date, Up_Emp) values (@Nop_Ma_Code, @Nop_Ma_Name, @USE_YN, @Ins_Date, @Ins_Emp, @Ins_Date, @Ins_Emp)"; cmd.Parameters.AddWithValue("@Nop_Ma_Code", vo.Nop_Ma_Code); cmd.Parameters.AddWithValue("@Nop_Ma_Name", vo.Nop_Ma_Name); cmd.Parameters.AddWithValue("@USE_YN", vo.Use_YN); cmd.Parameters.AddWithValue("@Ins_Date", DateTime.Now); cmd.Parameters.AddWithValue("@Ins_Emp", "김민우"); cmd.Connection.Open(); CheckNum = cmd.ExecuteNonQuery(); cmd.Connection.Close(); } return(CheckNum == 1 ? true : false); }
public bool InsertNonOperationMa(NonOperationVO vo) { NonOperationDAC dac = new NonOperationDAC(); return(dac.InsertNonOperationMa(vo)); }