/// <summary>

  /// 更新一条数据

  /// </summary>

  public void Update(ZPY.Model.News model)

  {

   StringBuilder strSql=new StringBuilder();

   strSql.Append("update News set ");

   strSql.Append("NewsTitle=@NewsTitle,");

   strSql.Append("NewsContent=@NewsContent,");

   strSql.Append("NewsFrom=@NewsFrom,");

   strSql.Append("NewsTime=@NewsTime,");

   strSql.Append("DefaultPic=@DefaultPic,");

   strSql.Append("BigClassID=@BigClassID,");

   strSql.Append("SmallClassID=@SmallClassID,");

   strSql.Append("Hits=@Hits,");

   strSql.Append("IsTop=@IsTop,");

   strSql.Append("IsPass=@IsPass,");

   strSql.Append("AddMan=@AddMan");

   strSql.Append(" where ID=@ID ");

   OleDbParameter[] parameters = {

     // 注意里面参数的顺利一定要和Update语句里面参数是顺序一致，比如Update语句里面第一个参数

// 是@NewTitle，这里也是，Update语句里面最后一个参数是@ID，这样最后一个参数一定要是@ID

     new OleDbParameter("@NewsTitle", OleDbType.VarChar,),

     new OleDbParameter("@NewsContent", OleDbType.VarChar,),

     new OleDbParameter("@NewsFrom", OleDbType.VarChar,),

     new OleDbParameter("@NewsTime", OleDbType.Date),

     new OleDbParameter("@DefaultPic", OleDbType.VarChar,),

     new OleDbParameter("@BigClassID", OleDbType.Integer,),

     new OleDbParameter("@SmallClassID", OleDbType.Integer,),

     new OleDbParameter("@Hits", OleDbType.Integer,),

     new OleDbParameter("@IsTop", OleDbType.Boolean,),

     new OleDbParameter("@IsPass", OleDbType.Boolean,),

     new OleDbParameter("@AddMan", OleDbType.VarChar,),

                    new OleDbParameter("@ID", OleDbType.Integer,),

            };

   parameters[].Value = model.NewsTitle;

   parameters[].Value = model.NewsContent;

   parameters[].Value = model.NewsFrom;

   parameters[].Value = model.NewsTime;

   parameters[].Value = model.DefaultPic;

   parameters[].Value = model.BigClassID;

   parameters[].Value = model.SmallClassID;

   parameters[].Value = model.Hits;

   parameters[].Value = model.IsTop;

   parameters[].Value = model.IsPass;

   parameters[].Value = model.AddMan;

            parameters[].Value = model.ID;

   DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);

  }

            //插入一条数据

            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into TH_MapMark(");

            strSql.Append("ExtendName,ExtendDate,BottomLeftX,BottomLeftY,TopRightX,TopRightY,ImgPreview,IsDefaultMark)");

            strSql.Append(" values (");

            strSql.Append("@ExtendName,@ExtendDate,@BottomLeftX,@BottomLeftY,@TopRightX,@TopRightY,@ImgPreview,@IsDefaultMark)");

            OleDbParameter[] parameters = {

                         new OleDbParameter("@ExtendName", OleDbType.VarChar),

                         new OleDbParameter("@ExtendDate", OleDbType.Date),

                         new OleDbParameter("@BottomLeftX", OleDbType.VarChar),

                         new OleDbParameter("@BottomLeftY", OleDbType.VarChar),

                         new OleDbParameter("@TopRightX", OleDbType.VarChar),

                         new OleDbParameter("@TopRightY", OleDbType.VarChar),

                         new OleDbParameter("@ImgPreview", OleDbType.Binary),

                         new OleDbParameter("@IsDefaultMark", OleDbType.Integer)};

            parameters[].Value = name;

            parameters[].Value = DateTime.Now;

            parameters[].Value = lowerLeftX;

            parameters[].Value = lowerLeftY;

            parameters[].Value = upperRightX;

            parameters[].Value = upperRightY;

            parameters[].Value = images;

            parameters[].Value = ;

            ExecuteSql(strSql.ToString(), parameters);