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