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