public bool InsertNonOpMi(NonOpMiVo vo) { int CheckNum = 0; using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = new SqlConnection(ConnectionString); cmd.CommandText = @"Insert into Nop_Mi_Master(Nop_Mi_Code, Nop_Mi_Name, Nop_Ma_Code, Remark, Use_YN, Ins_Date, Ins_Emp, Up_Date, Up_Emp) values (@Nop_Mi_Code, @Nop_Mi_Name, @Nop_Ma_Code, @Remark, @USE_YN, @Ins_Date, @Ins_Emp, @Ins_Date, @Ins_Emp)"; cmd.Parameters.AddWithValue("@Nop_Ma_Code", vo.Nop_Ma_Code); cmd.Parameters.AddWithValue("@Nop_Mi_Code", vo.Nop_Mi_Code); cmd.Parameters.AddWithValue("@Nop_Mi_Name", vo.Nop_Mi_Name); cmd.Parameters.AddWithValue("@USE_YN", vo.Use_YN); cmd.Parameters.AddWithValue("@Remark", vo.Remark); 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 InsertNonOpMi(NonOpMiVo vo) { NonOperationDAC dac = new NonOperationDAC(); return(dac.InsertNonOpMi(vo)); }