C#之 如何使用SqlParameter执行SQL

一个简单的demo，SQL帮助类见：
C# 之SqlServer帮助类（SQLHelper），可以直接调用

string sqlCon = "server=.;uid=sa;pwd=sa;database=AssociationsManagementDb";
            MySQLHelper.connectionString = sqlCon;
            try
            {
                
                string insertSql = @"INSERT INTO AssociationsManagement.t_Department (name, Remark,ParentId,CreationTime,IsDeleted)  
                                   VALUES (@name, @Remark,@ParentId,@CreationTime,@IsDeleted) ;";
                

                SqlParameter[] sqlParameter = new SqlParameter[]
                {
                    new SqlParameter("@name","生活部4"),
                    new SqlParameter("@Remark","生活部生活部4"),
                    new SqlParameter("@ParentId","0"),
                    new SqlParameter("@CreationTime",DateTime.Now),
                    new SqlParameter("@IsDeleted","0")
                };
                int i = MySQLHelper.ExecteNonQuery(CommandType.Text, insertSql, sqlParameter);//使用SQL帮助类进行数据库操作
                Console.WriteLine($"{i}");
                Console.ReadLine();

            }
            catch (Exception x)
            {
                var str = x;
                
                throw;

            }