/// <summary> /// 编辑照片信息 /// </summary> /// <param name="_AlbumNo"></param> /// <param name="_photoinfo"></param> /// <returns></returns> public Model.ManagerStateMsg EditPhoto(string _AlbumNo, Model.PhotoInfo _photoinfo) { Model.ManagerStateMsg msg = new Model.ManagerStateMsg(false, "方法 EditPhoto 执行出现错误!"); IObjectContainer db = DataHelper.Instance.GetDbObj(typeof(RootAlbum)); try { IObjectSet _result = db.Query(typeof(RootAlbum)); RootAlbum root = (RootAlbum)_result.Next(); if (root.SubAlbums != null && root.SubAlbums.Count > 0) { foreach (Album _abm in root.SubAlbums) { if (_abm.AlbumNO == _AlbumNo) { int Imgindex = GetPhotoIndex(_abm.SubPhotos, _photoinfo.PhotoName);//返回照片索引 if (Imgindex > -1) { _abm.SubPhotos[Imgindex].PhotoName = _photoinfo.PhotoName; _abm.SubPhotos[Imgindex].PhotoRemark = _photoinfo.PhotoRemark; _abm.UpdateDate = DateTime.Now; msg.Statevalue = true; msg.MsgInfo = "编辑信息保存 成功!"; } else { msg.Statevalue = false; msg.MsgInfo = "未找到符合条件的照片!"; } break; } } if (msg.Statevalue) { db.Store(root);//保存 db.Commit(); } } else { msg.Statevalue = false; msg.MsgInfo = "不存在任何相册!"; } } catch (Exception ex) { msg.Statevalue = false; msg.MsgInfo = ex.Message; } finally { db.Close(); } return(msg); }
/// <summary> /// 添加照片 /// </summary> /// <param name="_AlbumNo">照片编号</param> /// <param name="_photoinfo">照片信息</param> /// <returns></returns> public Model.ManagerStateMsg AddPhoto(string _AlbumNo, Model.PhotoInfo _photoinfo) { Model.ManagerStateMsg msg = new Model.ManagerStateMsg(false, "方法 AddPhoto 执行出现错误!"); IObjectContainer db = DataHelper.Instance.GetDbObj(typeof(RootAlbum)); try { IObjectSet _result = db.Query(typeof(RootAlbum)); RootAlbum root = (RootAlbum)_result.Next(); if (root.SubAlbums != null && root.SubAlbums.Count > 0) { foreach (Album _abm in root.SubAlbums) { if (_abm.AlbumNO == _AlbumNo) { if (_abm.SubPhotos == null) { _abm.SubPhotos = new List <PhotoInfo>(); } if (_abm.SubPhotos.Count == 0) { _abm.AlbumTitleImg = _photoinfo.PhotoMiniData; _photoinfo.IsTitleImg = true; } _abm.SubPhotos.Add(_photoinfo); break; } } db.Store(root); db.Commit(); msg.ReturnValue = _photoinfo; msg.Statevalue = true; msg.MsgInfo = "保存成功"; } else { msg.Statevalue = false; msg.MsgInfo = "不存在任何相册!"; } } catch (Exception ex) { msg.Statevalue = false; msg.MsgInfo = ex.Message; } finally { db.Close(); } return(msg); }
/// <summary> /// 添加照片 /// </summary> /// <param name="_AlbumNo">照片编号</param> /// <param name="_photoinfo">照片信息</param> /// <returns></returns> public Model.ManagerStateMsg AddPhoto(string _AlbumNo, Model.PhotoInfo _photoinfo) { Model.ManagerStateMsg msg = new Model.ManagerStateMsg(false, "方法 AddPhoto 执行出现错误!"); IObjectContainer db = DataHelper.Instance.GetDbObj(typeof(RootAlbum)); try { IObjectSet _result = db.Query(typeof(RootAlbum)); RootAlbum root = (RootAlbum)_result.Next(); if (root.SubAlbums != null && root.SubAlbums.Count > 0) { foreach (Album _abm in root.SubAlbums) { if (_abm.AlbumNO == _AlbumNo) { if (_abm.SubPhotos == null) { _abm.SubPhotos = new List<PhotoInfo>(); } if (_abm.SubPhotos.Count == 0) { _abm.AlbumTitleImg = _photoinfo.PhotoMiniData; _photoinfo.IsTitleImg = true; } _abm.SubPhotos.Add(_photoinfo); break; } } db.Store(root); db.Commit(); msg.ReturnValue = _photoinfo; msg.Statevalue = true; msg.MsgInfo = "保存成功"; } else { msg.Statevalue = false; msg.MsgInfo = "不存在任何相册!"; } } catch (Exception ex) { msg.Statevalue = false; msg.MsgInfo = ex.Message; } finally { db.Close(); } return msg; }
/// <summary> /// 删除照片 /// </summary> /// <param name="_AlbumNo"></param> /// <param name="_photoNo"></param> /// <returns></returns> public Model.ManagerStateMsg DeletePhoto(string _AlbumNo, string _photoNo) { Model.ManagerStateMsg msg = new Model.ManagerStateMsg(false, "方法 EditPhoto 执行出现错误!"); try { SQLiteParameter[] pars = null; pars = new SQLiteParameter[1]; pars[0] = new SQLiteParameter("@PhotoNO", DbType.String); pars[0].Value = _photoNo; string strQuerySQL = "delete from Photo where PhotoNO=@PhotoNO"; int _upRowscount = SQLiteHelper.Instance.ExecuteNonQuery(strQuerySQL, pars); if (_upRowscount > 0) { strQuerySQL = "select count(PhotoNO) as 'PhotoTols' from Photo where IsTitleImg=1 and AlbumNo=@AlbumNo"; SQLiteParameter[] Titleimgpars = new SQLiteParameter[1]; Titleimgpars[0] = new SQLiteParameter("@AlbumNo", DbType.String); Titleimgpars[0].Value = _AlbumNo; DataTable _dt = SQLiteHelper.Instance.ExecuteDataTable(strQuerySQL, Titleimgpars); if (_dt != null && _dt.Rows.Count > 0) { } else { _dt = SQLiteHelper.Instance.ExecuteDataTable("select AlbumNo,PhotoNO from Photo order by PhotoCreateDate limit 0,1", null); if (_dt != null && _dt.Rows.Count > 0) { string strPhotoNO = _dt.Rows[0]["PhotoNO"].ToString(); string strAlbumNo = _dt.Rows[0]["AlbumNo"].ToString(); AlbumManager manager = new AlbumManager(); manager.ChangeTitleImg(strAlbumNo, strPhotoNO); } } } } catch (Exception ex) { msg.Statevalue = false; msg.MsgInfo = ex.Message; } return(msg); }
/// <summary> /// 编辑照片信息 /// </summary> /// <param name="_AlbumNo"></param> /// <param name="_photoinfo"></param> /// <returns></returns> public Model.ManagerStateMsg EditPhoto(string _AlbumNo, Model.PhotoInfo _photoinfo) { Model.ManagerStateMsg msg = new Model.ManagerStateMsg(false, "方法 EditPhoto 执行出现错误!"); try { SQLiteParameter[] pars = null; pars = new SQLiteParameter[4]; pars[0] = new SQLiteParameter("@PhotoName", DbType.String); pars[0].Value = _photoinfo.PhotoName; pars[1] = new SQLiteParameter("@PhotoRemark", DbType.String); pars[1].Value = _photoinfo.PhotoRemark; pars[2] = new SQLiteParameter("@PhotoUpdateDate", DbType.String); pars[2].Value = _photoinfo.PhotoUpdateDate; pars[3] = new SQLiteParameter("@PhotoNO", DbType.String); pars[3].Value = _photoinfo.PhotoNO; string strQuerySQL = "update Photo set PhotoName=@PhotoName,PhotoRemark=@PhotoRemark,PhotoUpdateDate=@PhotoUpdateDate where PhotoNO=@PhotoNO"; int _upRowscount = SQLiteHelper.Instance.ExecuteNonQuery(strQuerySQL, pars); if (_upRowscount > 0) { msg.MsgInfo = "编辑信息保存成功!"; msg.Statevalue = true; } else { msg.MsgInfo = "更新照片信息失败!"; } } catch (Exception ex) { msg.Statevalue = false; msg.MsgInfo = ex.Message; } return(msg); }
/// <summary> /// 删除照片 /// </summary> /// <param name="_AlbumNo"></param> /// <param name="_photoNo"></param> /// <returns></returns> public Model.ManagerStateMsg DeletePhoto(string _AlbumNo, string _photoNo) { Model.ManagerStateMsg msg = new Model.ManagerStateMsg(false, "方法 EditPhoto 执行出现错误!"); IObjectContainer db = DataHelper.Instance.GetDbObj(typeof(RootAlbum)); try { IObjectSet _result = db.Query(typeof(RootAlbum)); RootAlbum root = (RootAlbum)_result.Next(); if (root.SubAlbums != null && root.SubAlbums.Count > 0) { foreach (Album _abm in root.SubAlbums) { if (_abm.AlbumNO == _AlbumNo) { int Imgindex = GetPhotoIndex(_abm.SubPhotos, _photoNo);//返回照片索引 if (Imgindex > -1) { bool bolistitleimg = false; if (_abm.SubPhotos[Imgindex].IsTitleImg) { bolistitleimg = true; } _abm.SubPhotos.RemoveAt(Imgindex);//删除照片 if (_abm.SubPhotos.Count > 0) { if (bolistitleimg) { _abm.AlbumTitleImg = _abm.SubPhotos[0].PhotoMiniData; } } else { _abm.AlbumTitleImg = ""; } msg.Statevalue = true; msg.MsgInfo = "删除成功!"; } else { msg.Statevalue = false; msg.MsgInfo = "未找到符合条件的照片!"; } break; } } if (msg.Statevalue) { db.Store(root);//保存 db.Commit(); } } else { msg.Statevalue = false; msg.MsgInfo = "不存在任何相册!"; } } catch (Exception ex) { msg.Statevalue = false; msg.MsgInfo = ex.Message; } finally { db.Close(); } return msg; }
/// <summary> /// 编辑照片信息 /// </summary> /// <param name="_AlbumNo"></param> /// <param name="_photoinfo"></param> /// <returns></returns> public Model.ManagerStateMsg EditPhoto(string _AlbumNo, Model.PhotoInfo _photoinfo) { Model.ManagerStateMsg msg = new Model.ManagerStateMsg(false, "方法 EditPhoto 执行出现错误!"); IObjectContainer db = DataHelper.Instance.GetDbObj(typeof(RootAlbum)); try { IObjectSet _result = db.Query(typeof(RootAlbum)); RootAlbum root = (RootAlbum)_result.Next(); if (root.SubAlbums != null && root.SubAlbums.Count > 0) { foreach (Album _abm in root.SubAlbums) { if (_abm.AlbumNO == _AlbumNo) { int Imgindex = GetPhotoIndex(_abm.SubPhotos, _photoinfo.PhotoName);//返回照片索引 if (Imgindex >-1) { _abm.SubPhotos[Imgindex].PhotoName = _photoinfo.PhotoName; _abm.SubPhotos[Imgindex].PhotoRemark = _photoinfo.PhotoRemark; _abm.UpdateDate = DateTime.Now; msg.Statevalue = true; msg.MsgInfo = "编辑信息保存 成功!"; } else { msg.Statevalue = false; msg.MsgInfo = "未找到符合条件的照片!"; } break; } } if (msg.Statevalue) { db.Store(root);//保存 db.Commit(); } } else { msg.Statevalue = false; msg.MsgInfo = "不存在任何相册!"; } } catch (Exception ex) { msg.Statevalue = false; msg.MsgInfo = ex.Message; } finally { db.Close(); } return msg; }
/// <summary> /// 删除照片 /// </summary> /// <param name="_AlbumNo"></param> /// <param name="_photoNo"></param> /// <returns></returns> public Model.ManagerStateMsg DeletePhoto(string _AlbumNo, string _photoNo) { Model.ManagerStateMsg msg = new Model.ManagerStateMsg(false, "方法 EditPhoto 执行出现错误!"); IObjectContainer db = DataHelper.Instance.GetDbObj(typeof(RootAlbum)); try { IObjectSet _result = db.Query(typeof(RootAlbum)); RootAlbum root = (RootAlbum)_result.Next(); if (root.SubAlbums != null && root.SubAlbums.Count > 0) { foreach (Album _abm in root.SubAlbums) { if (_abm.AlbumNO == _AlbumNo) { int Imgindex = GetPhotoIndex(_abm.SubPhotos, _photoNo);//返回照片索引 if (Imgindex > -1) { bool bolistitleimg = false; if (_abm.SubPhotos[Imgindex].IsTitleImg) { bolistitleimg = true; } _abm.SubPhotos.RemoveAt(Imgindex);//删除照片 if (_abm.SubPhotos.Count > 0) { if (bolistitleimg) { _abm.AlbumTitleImg = _abm.SubPhotos[0].PhotoMiniData; } } else { _abm.AlbumTitleImg = ""; } msg.Statevalue = true; msg.MsgInfo = "删除成功!"; } else { msg.Statevalue = false; msg.MsgInfo = "未找到符合条件的照片!"; } break; } } if (msg.Statevalue) { db.Store(root);//保存 db.Commit(); } } else { msg.Statevalue = false; msg.MsgInfo = "不存在任何相册!"; } } catch (Exception ex) { msg.Statevalue = false; msg.MsgInfo = ex.Message; } finally { db.Close(); } return(msg); }
/// <summary> /// 添加照片 /// </summary> /// <param name="_AlbumNo">照片编号</param> /// <param name="_photoinfo">照片信息</param> /// <returns></returns> public Model.ManagerStateMsg AddPhoto(string _AlbumNo, Model.PhotoInfo _photoinfo) { Model.ManagerStateMsg msg = new Model.ManagerStateMsg(false, "方法 AddPhoto 执行出现错误!"); try { SQLiteParameter[] Ablumpars = new SQLiteParameter[1]; Ablumpars[0] = new SQLiteParameter("@AlbumNo", DbType.String); Ablumpars[0].Value = _photoinfo.PhotoNO; string strAblumTols="select count(PhotoNO) as 'PhotoTols' from Photo where AlbumNo=@AlbumNo group by AlbumNo"; DataTable dt = SQLiteHelper.Instance.ExecuteDataTable(strAblumTols, Ablumpars); int AblumPhotosCount = 0; if (dt != null && dt.Rows.Count > 0) { AblumPhotosCount = Convert.ToInt32(dt.Rows[0]["PhotoTols"]); } SQLiteParameter[] pars = new SQLiteParameter[9]; pars[0] = new SQLiteParameter("@PhotoNO", DbType.String); pars[0].Value = _photoinfo.PhotoNO; pars[1] = new SQLiteParameter("@AlbumNo", DbType.String); pars[1].Value = _AlbumNo; pars[2] = new SQLiteParameter("@PhotoName", DbType.String); pars[2].Value = _photoinfo.PhotoName; pars[3] = new SQLiteParameter("@PhotoRemark", DbType.String); pars[3].Value = _photoinfo.PhotoRemark; pars[4] = new SQLiteParameter("@IsTitleImg", DbType.Int32); if (AblumPhotosCount != 0) { pars[4].Value = 0; } else { pars[4].Value = 1; } pars[5] = new SQLiteParameter("@PhotoData", DbType.String); pars[5].Value = _photoinfo.PhotoData; pars[6] = new SQLiteParameter("@PhotoMiniData", DbType.String); pars[6].Value = _photoinfo.PhotoMiniData; pars[7] = new SQLiteParameter("@PhotoCreateDate", DbType.String); pars[7].Value = _photoinfo.PhotoCreateDate; pars[8] = new SQLiteParameter("@PhotoUpdateDate", DbType.String); pars[8].Value = _photoinfo.PhotoUpdateDate; string strSQL = @"insert into Photo (PhotoNO,AlbumNo,PhotoName,PhotoRemark,IsTitleImg,PhotoData,PhotoMiniData,PhotoCreateDate,PhotoUpdateDate) values (@PhotoNO,@AlbumNo,@PhotoName,@PhotoRemark,@IsTitleImg,@PhotoData,@PhotoMiniData,@PhotoCreateDate,@PhotoUpdateDate)"; int _uprows = SQLiteHelper.Instance.ExecuteNonQuery(strSQL, pars); if (_uprows > 0) { if (AblumPhotosCount == 0) { AlbumManager manager = new AlbumManager(); manager.ChangeTitleImg(_AlbumNo, _photoinfo.PhotoNO); } msg.ReturnValue = _photoinfo; msg.Statevalue = true; msg.MsgInfo = "保存成功"; } else { msg.MsgInfo = "写入数据库失败!"; } msg.ReturnValue = _photoinfo; msg.Statevalue = true; msg.MsgInfo = "保存成功"; } catch (Exception ex) { msg.Statevalue = false; msg.MsgInfo = ex.Message; } return msg; }
/// <summary> /// 编辑照片信息 /// </summary> /// <param name="_AlbumNo"></param> /// <param name="_photoinfo"></param> /// <returns></returns> public Model.ManagerStateMsg EditPhoto(string _AlbumNo, Model.PhotoInfo _photoinfo) { Model.ManagerStateMsg msg = new Model.ManagerStateMsg(false, "方法 EditPhoto 执行出现错误!"); try { SQLiteParameter[] pars = null; pars = new SQLiteParameter[4]; pars[0] = new SQLiteParameter("@PhotoName", DbType.String); pars[0].Value = _photoinfo.PhotoName; pars[1] = new SQLiteParameter("@PhotoRemark", DbType.String); pars[1].Value = _photoinfo.PhotoRemark; pars[2] = new SQLiteParameter("@PhotoUpdateDate", DbType.String); pars[2].Value = _photoinfo.PhotoUpdateDate; pars[3] = new SQLiteParameter("@PhotoNO", DbType.String); pars[3].Value = _photoinfo.PhotoNO; string strQuerySQL = "update Photo set PhotoName=@PhotoName,PhotoRemark=@PhotoRemark,PhotoUpdateDate=@PhotoUpdateDate where PhotoNO=@PhotoNO"; int _upRowscount = SQLiteHelper.Instance.ExecuteNonQuery(strQuerySQL, pars); if (_upRowscount > 0) { msg.MsgInfo = "编辑信息保存成功!"; msg.Statevalue = true; } else { msg.MsgInfo = "更新照片信息失败!"; } } catch (Exception ex) { msg.Statevalue = false; msg.MsgInfo = ex.Message; } return msg; }
/// <summary> /// 删除照片 /// </summary> /// <param name="_AlbumNo"></param> /// <param name="_photoNo"></param> /// <returns></returns> public Model.ManagerStateMsg DeletePhoto(string _AlbumNo, string _photoNo) { Model.ManagerStateMsg msg = new Model.ManagerStateMsg(false, "方法 EditPhoto 执行出现错误!"); try { SQLiteParameter[] pars = null; pars = new SQLiteParameter[1]; pars[0] = new SQLiteParameter("@PhotoNO", DbType.String); pars[0].Value = _photoNo; string strQuerySQL = "delete from Photo where PhotoNO=@PhotoNO"; int _upRowscount = SQLiteHelper.Instance.ExecuteNonQuery(strQuerySQL, pars); if (_upRowscount > 0) { strQuerySQL = "select count(PhotoNO) as 'PhotoTols' from Photo where IsTitleImg=1 and AlbumNo=@AlbumNo"; SQLiteParameter[] Titleimgpars = new SQLiteParameter[1]; Titleimgpars[0] = new SQLiteParameter("@AlbumNo", DbType.String); Titleimgpars[0].Value = _AlbumNo; DataTable _dt = SQLiteHelper.Instance.ExecuteDataTable(strQuerySQL, Titleimgpars); if (_dt != null && _dt.Rows.Count > 0) { } else { _dt = SQLiteHelper.Instance.ExecuteDataTable("select AlbumNo,PhotoNO from Photo order by PhotoCreateDate limit 0,1", null); if (_dt != null && _dt.Rows.Count > 0) { string strPhotoNO = _dt.Rows[0]["PhotoNO"].ToString(); string strAlbumNo=_dt.Rows[0]["AlbumNo"].ToString(); AlbumManager manager = new AlbumManager(); manager.ChangeTitleImg(strAlbumNo, strPhotoNO); } } } } catch (Exception ex) { msg.Statevalue = false; msg.MsgInfo = ex.Message; } return msg; }
/// <summary> /// 添加照片 /// </summary> /// <param name="_AlbumNo">照片编号</param> /// <param name="_photoinfo">照片信息</param> /// <returns></returns> public Model.ManagerStateMsg AddPhoto(string _AlbumNo, Model.PhotoInfo _photoinfo) { Model.ManagerStateMsg msg = new Model.ManagerStateMsg(false, "方法 AddPhoto 执行出现错误!"); try { SQLiteParameter[] Ablumpars = new SQLiteParameter[1]; Ablumpars[0] = new SQLiteParameter("@AlbumNo", DbType.String); Ablumpars[0].Value = _photoinfo.PhotoNO; string strAblumTols = "select count(PhotoNO) as 'PhotoTols' from Photo where AlbumNo=@AlbumNo group by AlbumNo"; DataTable dt = SQLiteHelper.Instance.ExecuteDataTable(strAblumTols, Ablumpars); int AblumPhotosCount = 0; if (dt != null && dt.Rows.Count > 0) { AblumPhotosCount = Convert.ToInt32(dt.Rows[0]["PhotoTols"]); } SQLiteParameter[] pars = new SQLiteParameter[9]; pars[0] = new SQLiteParameter("@PhotoNO", DbType.String); pars[0].Value = _photoinfo.PhotoNO; pars[1] = new SQLiteParameter("@AlbumNo", DbType.String); pars[1].Value = _AlbumNo; pars[2] = new SQLiteParameter("@PhotoName", DbType.String); pars[2].Value = _photoinfo.PhotoName; pars[3] = new SQLiteParameter("@PhotoRemark", DbType.String); pars[3].Value = _photoinfo.PhotoRemark; pars[4] = new SQLiteParameter("@IsTitleImg", DbType.Int32); if (AblumPhotosCount != 0) { pars[4].Value = 0; } else { pars[4].Value = 1; } pars[5] = new SQLiteParameter("@PhotoData", DbType.String); pars[5].Value = _photoinfo.PhotoData; pars[6] = new SQLiteParameter("@PhotoMiniData", DbType.String); pars[6].Value = _photoinfo.PhotoMiniData; pars[7] = new SQLiteParameter("@PhotoCreateDate", DbType.String); pars[7].Value = _photoinfo.PhotoCreateDate; pars[8] = new SQLiteParameter("@PhotoUpdateDate", DbType.String); pars[8].Value = _photoinfo.PhotoUpdateDate; string strSQL = @"insert into Photo (PhotoNO,AlbumNo,PhotoName,PhotoRemark,IsTitleImg,PhotoData,PhotoMiniData,PhotoCreateDate,PhotoUpdateDate) values (@PhotoNO,@AlbumNo,@PhotoName,@PhotoRemark,@IsTitleImg,@PhotoData,@PhotoMiniData,@PhotoCreateDate,@PhotoUpdateDate)"; int _uprows = SQLiteHelper.Instance.ExecuteNonQuery(strSQL, pars); if (_uprows > 0) { if (AblumPhotosCount == 0) { AlbumManager manager = new AlbumManager(); manager.ChangeTitleImg(_AlbumNo, _photoinfo.PhotoNO); } msg.ReturnValue = _photoinfo; msg.Statevalue = true; msg.MsgInfo = "保存成功"; } else { msg.MsgInfo = "写入数据库失败!"; } msg.ReturnValue = _photoinfo; msg.Statevalue = true; msg.MsgInfo = "保存成功"; } catch (Exception ex) { msg.Statevalue = false; msg.MsgInfo = ex.Message; } return(msg); }