/// <summary> /// 获取资讯附件信息集合 /// </summary> /// <param name="listInfo"></param> /// <returns></returns> protected IList <MPeerNewsAttachInfo> GetAttachInfo(IList <MPeerNewsAttachInfo> listInfo) { IList <MPeerNewsAttachInfo> list = new List <MPeerNewsAttachInfo>(); MPeerNewsAttachInfo AttachInfoModel = new MPeerNewsAttachInfo(); string FilePath = Utils.GetFormValue("ImgupLoad$hidFileName"); if (FilePath != "") { AttachInfoModel.FileName = ""; AttachInfoModel.Id = Guid.NewGuid().ToString(); AttachInfoModel.Path = FilePath; AttachInfoModel.Remark = "图片"; AttachInfoModel.Type = AttachInfoType.图片; list.Add(AttachInfoModel); } else { if (listInfo.Where(Item => (Item.Type == AttachInfoType.图片)).Count() > 0) { list.Add(listInfo.First(Item => (Item.Type == AttachInfoType.图片))); } } FilePath = Utils.GetFormValue("DocUpLoad$hidFileName"); if (FilePath != "") { string[] Path = FilePath.Split('|'); AttachInfoModel.FileName = Path[0]; AttachInfoModel.Id = Guid.NewGuid().ToString(); AttachInfoModel.Path = Path[1]; AttachInfoModel.Remark = "文件"; AttachInfoModel.Type = AttachInfoType.文件; list.Add(AttachInfoModel); } else { if (listInfo.Where(Item => (Item.Type == AttachInfoType.文件)).Count() > 0) { list.Add(listInfo.First(Item => (Item.Type == AttachInfoType.文件))); } } return(list); }
/// <summary> /// 获取同业资讯信息 /// </summary> /// <param name="newId">资讯编号</param> /// <returns>返回同业资讯信息实体</returns> public MPeerNews GetPeerNews(string newId) { MPeerNews model = null; if (string.IsNullOrEmpty(newId)) { return(model); } var strSql = new StringBuilder(); strSql.Append(SqlPeerNewsSelect); strSql.Append(" where [NewId] = @NewId order by LastUpdateTime desc ; "); strSql.Append(SqlPeerNewsAttachInfoSelect); strSql.Append(" where [NewId] = @NewId order by Type desc ; "); DbCommand dc = _db.GetSqlStringCommand(strSql.ToString()); _db.AddInParameter(dc, "NewId", DbType.AnsiStringFixedLength, newId); model = new MPeerNews(); using (IDataReader dr = DbHelper.ExecuteReader(dc, _db)) { if (dr.Read()) { if (!dr.IsDBNull(dr.GetOrdinal("NewId"))) { model.NewId = dr.GetString(dr.GetOrdinal("NewId")); } if (!dr.IsDBNull(dr.GetOrdinal("Title"))) { model.Title = dr.GetString(dr.GetOrdinal("Title")); } if (!dr.IsDBNull(dr.GetOrdinal("TypeId"))) { model.TypeId = (PeerNewType)dr.GetByte(dr.GetOrdinal("TypeId")); } if (!dr.IsDBNull(dr.GetOrdinal("Content"))) { model.Content = dr.GetString(dr.GetOrdinal("Content")); } if (!dr.IsDBNull(dr.GetOrdinal("CompanyId"))) { model.CompanyId = dr.GetString(dr.GetOrdinal("CompanyId")); } if (!dr.IsDBNull(dr.GetOrdinal("CompanyName"))) { model.CompanyName = dr.GetString(dr.GetOrdinal("CompanyName")); } if (!dr.IsDBNull(dr.GetOrdinal("OperatorId"))) { model.OperatorId = dr.GetString(dr.GetOrdinal("OperatorId")); } if (!dr.IsDBNull(dr.GetOrdinal("OperatorName"))) { model.OperatorName = dr.GetString(dr.GetOrdinal("OperatorName")); } if (!dr.IsDBNull(dr.GetOrdinal("B2BDisplay"))) { model.B2BDisplay = (NewsB2BDisplay)dr.GetByte(dr.GetOrdinal("B2BDisplay")); } if (!dr.IsDBNull(dr.GetOrdinal("SortId"))) { model.SortId = dr.GetInt32(dr.GetOrdinal("SortId")); } if (!dr.IsDBNull(dr.GetOrdinal("ClickNum"))) { model.ClickNum = dr.GetInt32(dr.GetOrdinal("ClickNum")); } if (!dr.IsDBNull(dr.GetOrdinal("IP"))) { model.Ip = dr.GetString(dr.GetOrdinal("IP")); } if (!dr.IsDBNull(dr.GetOrdinal("IssueTime"))) { model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); } if (!dr.IsDBNull(dr.GetOrdinal("LastUpdateTime"))) { model.LastUpdateTime = dr.GetDateTime(dr.GetOrdinal("LastUpdateTime")); } if (!dr.IsDBNull(dr.GetOrdinal("AreaId"))) { model.AreaId = dr.GetInt32(dr.GetOrdinal("AreaId")); } if (!dr.IsDBNull(dr.GetOrdinal("AreaName"))) { model.AreaName = dr.GetString(dr.GetOrdinal("AreaName")); } if (!dr.IsDBNull(dr.GetOrdinal("AreaType"))) { model.AreaType = (Model.SystemStructure.AreaType)dr.GetByte(dr.GetOrdinal("AreaType")); } if (!dr.IsDBNull(dr.GetOrdinal("ScenicId"))) { model.ScenicId = dr.GetString(dr.GetOrdinal("ScenicId")); } } dr.NextResult(); model.AttachInfo = new List <MPeerNewsAttachInfo>(); MPeerNewsAttachInfo modelInfo; while (dr.Read()) { modelInfo = new MPeerNewsAttachInfo(); if (!dr.IsDBNull(dr.GetOrdinal("Id"))) { modelInfo.Id = dr.GetString(dr.GetOrdinal("Id")); } if (!dr.IsDBNull(dr.GetOrdinal("Type"))) { modelInfo.Type = (AttachInfoType)dr.GetByte(dr.GetOrdinal("Type")); } if (!dr.IsDBNull(dr.GetOrdinal("Path"))) { modelInfo.Path = dr.GetString(dr.GetOrdinal("Path")); } if (!dr.IsDBNull(dr.GetOrdinal("FileName"))) { modelInfo.FileName = dr.GetString(dr.GetOrdinal("FileName")); } if (!dr.IsDBNull(dr.GetOrdinal("Remark"))) { modelInfo.Remark = dr.GetString(dr.GetOrdinal("Remark")); } model.AttachInfo.Add(modelInfo); } } return(model); }
/// <summary> /// 编辑与添加的公共model部分 /// </summary> protected string CommonModel(MPeerNews Model) { StringBuilder str = new StringBuilder(); string txtTitle = Utils.GetFormValue(this.txtTitle.UniqueID).Trim(); //标题 string[] selectInfo = Utils.GetFormValue("selectInfo").Split('|'); //相关专线、相关地接、相关景区ID string selectInfoName = Utils.GetFormValue("selectInfoName"); //相关专线、相关地接、相关景区Name int ddlType = Utils.GetInt(Utils.GetFormValue(this.ddlType.UniqueID), -1); //分 类 string txtContent = Utils.EditInputText(Request.Form[this.txtContent.UniqueID]); //内容 string[] picPath = Utils.GetFormValue(this.filePic.UniqueID + "$hidFileName").Split(','); //已上传的图片路径 ,多个用逗号隔开 string[] filePath = Utils.GetFormValue(this.files.UniqueID + "$hidFileName").Split(','); //已上传的附件路径 ,多个用逗号隔开 /*数据验证开始*/ if (string.IsNullOrEmpty(txtTitle)) { str.Append("标题不能为空!\\n"); } if (string.IsNullOrEmpty(txtContent)) { str.Append("内容不能为空!\\n"); } if (str.Length > 0) { return(str.ToString()); } /*数据验证结束*/ Model.CompanyId = this.SiteUserInfo.CompanyID; Model.CompanyName = this.SiteUserInfo.CompanyName; Model.Content = txtContent; Model.Ip = StringValidate.GetRemoteIP(); if (this.SiteUserInfo.CompanyRole.HasRole(EyouSoft.Model.CompanyStructure.CompanyType.专线) || this.SiteUserInfo.CompanyRole.HasRole(EyouSoft.Model.CompanyStructure.CompanyType.地接)) { if (selectInfo.Length == 2) { Model.AreaId = Utils.GetInt(selectInfo[0]); Model.AreaType = (AreaType)Utils.GetInt(selectInfo[1]); } else { Model.AreaId = Utils.GetInt(selectInfo[0]); } } else if (this.SiteUserInfo.CompanyRole.HasRole(EyouSoft.Model.CompanyStructure.CompanyType.景区)) { Model.ScenicId = selectInfo[0]; } Model.AreaName = selectInfoName; Model.OperatorId = this.SiteUserInfo.ID; Model.OperatorName = this.SiteUserInfo.UserName; Model.Title = txtTitle; Model.TypeId = (PeerNewType)ddlType; /*文件上传开始*/ List <MPeerNewsAttachInfo> lstFile = new List <MPeerNewsAttachInfo>(); //图片 if (picPath.Length > 0) { for (int i = 0; i < picPath.Length; i++) { if (string.IsNullOrEmpty(picPath[i])) { break; } MPeerNewsAttachInfo picModel = new MPeerNewsAttachInfo(); picModel.FileName = picPath[i].Substring(picPath[i].LastIndexOf('/') + 1); picModel.Path = picPath[i]; picModel.Type = AttachInfoType.图片; lstFile.Add(picModel); } } //附件 if (filePath.Length > 0) { for (int i = 0; i < filePath.Length; i++) { if (string.IsNullOrEmpty(filePath[i])) { break; } MPeerNewsAttachInfo fileModel = new MPeerNewsAttachInfo(); if (filePath[i].IndexOf('|') > 0) { string[] strFileInfo = filePath[i].Split('|'); fileModel.FileName = strFileInfo[0]; fileModel.Path = strFileInfo[1]; } else { fileModel.FileName = filePath[i].Substring(filePath[i].LastIndexOf('/')); fileModel.Path = filePath[i]; } fileModel.Type = AttachInfoType.文件; lstFile.Add(fileModel); } } Model.AttachInfo = lstFile.Count == 0 ? null : lstFile; /*文件上传结束*/ return(str.ToString()); }