使用泛型参数传递对数据库进行增删改查

使用泛型参数传递对数据库进行增删改查

 string sql = "insert into  WisdomInformation(title,contents,type)values('@title','@contents','@type')";//一定需要加单引号，我曾经在这上面犯过错

   Dictionary<string, string> dic = new Dictionary<string, string>();

            dic.Add("@content", contents);
       dic.Add("@type",option);

       dic.Add("@title", title);

int rows = SqlHelper.ExecuteNonQuey1(sql, dic);//自己写的方法

方法1

  public static int ExecuteNonQuey1(string sql, Dictionary<string ,string> dic )
        {
                SqlParameter[] ps = new SqlParameter[dic.Count];
                int index = 0;
                foreach (var item in dic)
                {
                    ps[index++] = new SqlParameter(item.Key, item.Value);
                }
              return ExecuteNonQuery2(sql,CommandType.Text, ps);//方法2
              
        }

方法2

  public   static int ExecuteNonQuery2(string sql,CommandType  type, SqlParameter []ps)
        {
          int rows=0;
           using (SqlConnection con = Getcon())
            {
            con.Open();
            foreach (SqlParameter var in ps)
            {
                sql = sql.Replace(var.ParameterName, var.Value.ToString());
            }
            SqlCommand cmd = new SqlCommand(sql, con);
            cmd.CommandType = type;
            cmd.Parameters.AddRange(ps);          
            rows = cmd.ExecuteNonQuery();
             }
        return  rows;

        }