コード例 #1
0
        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);
        }
コード例 #2
0
        public bool InsertNonOperationMa(NonOperationVO vo)
        {
            NonOperationDAC dac = new NonOperationDAC();

            return(dac.InsertNonOperationMa(vo));
        }