Ejemplo n.º 1
0
        /// <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);
        }
Ejemplo n.º 2
0
        /// <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);
        }
Ejemplo n.º 3
0
        /// <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;
        }
Ejemplo n.º 4
0
        /// <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);
        }
Ejemplo n.º 5
0
        /// <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);
        }
Ejemplo n.º 6
0
        /// <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;
        }
Ejemplo n.º 7
0
        /// <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;
        }
Ejemplo n.º 8
0
        /// <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);
        }
Ejemplo n.º 9
0
        /// <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;
        }
Ejemplo n.º 10
0
        /// <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;
        }
Ejemplo n.º 11
0
        /// <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;
        }
Ejemplo n.º 12
0
        /// <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);
        }