Example #1
0
        /// <summary>
        /// ��SqlDataReader�ж�ȡ���ݵ�Modelʵ������
        /// </summary>
        /// <param name="rdr">SqlDataReader����</param>
        /// <returns>����ʵ�����</returns>
        private XYECOM.Model.AttachmentInfo SetInfo(SqlDataReader rdr)
        {
            XYECOM.Model.AttachmentInfo info = new XYECOM.Model.AttachmentInfo();

            info.At_FileFormat = rdr["At_FileFormat"].ToString();
            info.At_FileType = rdr["At_FileType"].ToString();
            info.At_ID = Core.MyConvert.GetInt64(rdr["At_ID"].ToString());
            info.At_Index = Core.MyConvert.GetInt32(rdr["At_Index"].ToString());
            info.At_Path = rdr["At_Path"].ToString();
            info.At_PulishDate = Core.MyConvert.GetDateTime(rdr["At_PulishDate"].ToString());
            info.At_Remark = rdr["At_Remark"].ToString();
            info.DescTabID = Core.MyConvert.GetInt64(rdr["DescTabID"].ToString());
            info.DescTabName = rdr["DescTabName"].ToString();
            info.S_ID = Core.MyConvert.GetInt32(rdr["S_ID"].ToString());
            info.ThumbnailImg = rdr["ThumbnailImg"].ToString();

            //��ȡ��������Ϣ
            info.Server = new Server().GetItem(info.S_ID);
            return info;
        }
Example #2
0
        /// <summary>
        /// д�����ݿ�
        /// </summary>
        /// <param name="tabName">Ŀ�����</param>
        /// <param name="id">���Id</param>
        /// <param name="fileFormat">�洢��ʽ</param>
        /// <param name="fileType">�ļ�����</param>
        /// <param name="fileURL">�����</param>
        /// <param name="sconfigid">���������</param>
        /// <returns>Ӱ������</returns>
        private static Int64 SaveDataBase(string tabName, Int64 id, string fileFormat, Model.UploadFileType fileType,string fileURL, int sconfigid)
        {
            XYECOM.Model.AttachmentInfo fileinfo = new XYECOM.Model.AttachmentInfo();

            Int64 atid = 0;

            if (0 < id)
            {
                fileinfo = new XYECOM.Business.Attachment().GetItem(id);
                if (fileinfo == null)
                {
                    fileinfo = new XYECOM.Model.AttachmentInfo();
                    id = 0;
                }
            }

            fileinfo.At_FileFormat = fileFormat;

            if (0 < id)
            {
                //ɾ��ԭ��ͼƬ
                XYECOM.Model.ServerInfo ffileconfig = new XYECOM.Business.Server().GetItem(fileinfo.S_ID);
                if (null != ffileconfig)
                {
                    string filepath = ffileconfig.S_Path + fileinfo.At_Path;
                    if (File.Exists(filepath))
                        File.Delete(filepath);

                    foreach (string ifile in fileinfo.SmallImg.Images)
                    {
                        filepath = ffileconfig.S_Path + ifile;
                        if (File.Exists(filepath))
                            File.Delete(filepath);
                    }
                }
                fileinfo.S_ID = sconfigid;
                fileinfo.At_Path = fileURL;
                fileinfo.ThumbnailImg = "";
                fileinfo.At_ID = id;
                fileinfo.At_Index = 0;
                new XYECOM.Business.Attachment().Update(fileinfo);
            }
            else
            {
                fileinfo.At_Path = fileURL;
                fileinfo.DescTabID = -1;
                fileinfo.At_FileType = fileType == Model.UploadFileType.Image?"image":"file";
                fileinfo.DescTabName = tabName;
                fileinfo.S_ID = sconfigid;
                fileinfo.At_Remark = "";
                new XYECOM.Business.Attachment().Insert(fileinfo, out atid);
            }
            return atid;
        }
Example #3
0
        public Model.AttachmentInfo GetItemInfoOfVideo(int userid)
        {
            string sql = "select * from pl_attachment where DescTabName='Video' and DescTabId=" + userid;

            XYECOM.Model.AttachmentInfo info = null;

            using (SqlDataReader rdr = XYECOM.Core.Data.SqlHelper.ExecuteReader(CommandType.Text, sql))
            {
                if (rdr.Read())
                {
                    info = new XYECOM.Model.AttachmentInfo();
                    info.At_FileFormat = rdr["At_FileFormat"].ToString();
                    info.At_FileType = rdr["At_FileType"].ToString();
                    info.At_ID = Core.MyConvert.GetInt64(rdr["At_ID"].ToString());
                    info.At_Index = Core.MyConvert.GetInt32(rdr["At_Index"].ToString());
                    info.At_Path = rdr["At_Path"].ToString();
                    info.At_PulishDate = Core.MyConvert.GetDateTime(rdr["At_PulishDate"].ToString());
                    info.At_Remark = rdr["At_Remark"].ToString();
                    info.DescTabID = Core.MyConvert.GetInt64(rdr["DescTabID"].ToString());
                    info.DescTabName = rdr["DescTabName"].ToString();
                    info.S_ID = Core.MyConvert.GetInt32(rdr["S_ID"].ToString());
                    info.ThumbnailImg = rdr["ThumbnailImg"].ToString();

                    //��ȡ��������Ϣ
                    info.Server = new Server().GetItem(info.S_ID);
                }
            }
            return info;
        }