/// <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)); } }
/// <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)); }