Ejemplo n.º 1
0
 /// <summary>
 /// 插入图片数据
 /// </summary>
 /// <param name="picId"></param>
 /// <param name="picUrl"></param>
 /// <returns></returns>
 public int InsertPicUrl(PicCacheData model)
 {
     lock (obj)
     {
         string sql = "insert into PicCacheData(id,pictureID,pictureImage,pictureDatatime,picType) values(null," + model.pictureID + ",@fs,'" + DateTime.Now.ToString() + "','" + model.picType + "')";
         return(SQLiteDBHelperFactory.dhldesDB.ExecuteSqlInsertImg(sql, model.pictureImage));
     }
 }
Ejemplo n.º 2
0
        /// <summary>
        /// 更新图片地址
        /// </summary>
        /// <param name="picId"></param>
        /// <param name="picUrl"></param>
        /// <returns></returns>
        public int SetPicUrl(PicCacheData model)
        {
            string sql = "update PicCacheData set pictureImage=@fs where pictureID=" + model.pictureID + "and picType='" + model.picType + "'";

            return(SQLiteDBHelperFactory.dhldesDB.ExecuteSqlInsertImg(sql, model.pictureImage));
        }