/// <summary> /// 修改文件信息 /// </summary> /// <param name="model"></param> /// <param name="ItemType">附件类型</param> /// <returns></returns> public bool UpdateGovDocuments(EyouSoft.Model.GovStructure.MGovDocuments model, EyouSoft.Model.EnumType.ComStructure.AttachItemType ItemType) { if (model != null && !string.IsNullOrEmpty(model.DocumentsId) && !string.IsNullOrEmpty(model.CompanyId) && !string.IsNullOrEmpty(model.FontSize) && !string.IsNullOrEmpty(model.Company) && !string.IsNullOrEmpty(model.Title) && !string.IsNullOrEmpty(model.AttnId) && !string.IsNullOrEmpty(model.OperatorID)) { if (model.ComAttachList != null && model.ComAttachList.Count > 0) { for (int i = 0; i < model.ComAttachList.Count; i++) { model.ComAttachList[i].ItemId = model.DocumentsId; model.ComAttachList[i].ItemType = ItemType; } } else { model.ComAttachList = null; } if (model.GovDocumentsApproveList != null && model.GovDocumentsApproveList.Count > 0) { for (int i = 0; i < model.GovDocumentsApproveList.Count; i++) { model.GovDocumentsApproveList[i].DocumentsId = model.DocumentsId; } } bool result = dal.UpdateGovDocuments(model, ItemType); if (result) { SysStructure.BSysLogHandle.Insert("修改一条文件管理:编号为:" + model.DocumentsId); } return(result); } return(false); }
protected void PageInit(string id) { EyouSoft.BLL.GovStructure.BDocuments BLL = new EyouSoft.BLL.GovStructure.BDocuments(); EyouSoft.Model.GovStructure.MGovDocuments model = BLL.GetGovFilePersonnelModel(id); if (model != null) { this.lbTitle.Text = model.Title; this.lbCompany.Text = model.Company; this.lbFontSize.Text = model.FontSize; IList <EyouSoft.Model.ComStructure.MComAttach> lstFile = model.ComAttachList; StringBuilder strFile = new StringBuilder(); if (null != lstFile && lstFile.Count > 0) { for (int i = 0; i < lstFile.Count; i++) { strFile.AppendFormat("<span class='upload_filename'><a href='/CommonPage/FileDownLoad.aspx?doType=downLoad&filePath={0}&name={1}' target='_blank'>{1}</a></span>", lstFile[i].FilePath, lstFile[i].Name); } } this.lbFiles.Text = strFile.ToString(); if (model.GovDocumentsApproveList != null && model.GovDocumentsApproveList.Count > 0) { this.rpt_approve.DataSource = model.GovDocumentsApproveList; this.rpt_approve.DataBind(); if (model.GovDocumentsApproveList.Where(item => (item.ApproveID) == this.SiteUserInfo.UserId).ToList().Count > 0) { this.ph_Flies.Visible = true; } else { this.ph_Flies.Visible = false; } } } }
/// <summary> /// 添加文件信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddGovDocuments(EyouSoft.Model.GovStructure.MGovDocuments model) { if (model != null && !string.IsNullOrEmpty(model.CompanyId) && !string.IsNullOrEmpty(model.FontSize) && !string.IsNullOrEmpty(model.Company) && !string.IsNullOrEmpty(model.Title) && !string.IsNullOrEmpty(model.AttnId) && !string.IsNullOrEmpty(model.OperatorID)) { model.DocumentsId = Guid.NewGuid().ToString(); if (model.ComAttachList != null && model.ComAttachList.Count > 0) { for (int i = 0; i < model.ComAttachList.Count; i++) { model.ComAttachList[i].ItemId = model.DocumentsId; model.ComAttachList[i].ItemType = ItemType; } } if (model.GovDocumentsApproveList != null && model.GovDocumentsApproveList.Count > 0) { for (int i = 0; i < model.GovDocumentsApproveList.Count; i++) { model.GovDocumentsApproveList[i].DocumentsId = model.DocumentsId; } } bool result = dal.AddGovDocuments(model); if (result) { SysStructure.BSysLogHandle.Insert("增加一条文件管理:编号为:" + model.DocumentsId); } return(result); } return(false); }
/// <summary> /// 修改文件信息 /// </summary> /// <param name="model"></param> /// <param name="ItemType">附件类型</param> /// <returns></returns> public bool UpdateGovDocuments(EyouSoft.Model.GovStructure.MGovDocuments model, EyouSoft.Model.EnumType.ComStructure.AttachItemType ItemType) { bool IsTrue = false; DbCommand dc = this._db.GetStoredProcCommand("proc_GovDocuments_Update"); this._db.AddInParameter(dc, "DocumentsId", DbType.AnsiStringFixedLength, model.DocumentsId); this._db.AddInParameter(dc, "CompanyId", DbType.AnsiStringFixedLength, model.CompanyId); this._db.AddInParameter(dc, "FontSize", DbType.String, model.FontSize); this._db.AddInParameter(dc, "Company", DbType.String, model.Company); this._db.AddInParameter(dc, "Title", DbType.String, model.Title); this._db.AddInParameter(dc, "FileType", DbType.Byte, (int)model.FileType); this._db.AddInParameter(dc, "AttnId", DbType.AnsiStringFixedLength, model.AttnId); this._db.AddInParameter(dc, "OperatorId", DbType.AnsiStringFixedLength, model.OperatorID); this._db.AddInParameter(dc, "IssueTime", DbType.DateTime, model.IssueTime); this._db.AddInParameter(dc, "ApproveState", DbType.Byte, (int)model.ApproveState); this._db.AddInParameter(dc, "GovDocumentsApproveXML", DbType.Xml, CreateGovDocumentsApproveListXML(model.GovDocumentsApproveList));//审批人业务实体集合 this._db.AddInParameter(dc, "ComAttachXML", DbType.Xml, CreateComAttachListXML(model.ComAttachList)); this._db.AddInParameter(dc, "ItemType", DbType.Byte, (int)ItemType); this._db.AddOutParameter(dc, "Result", DbType.Int32, 4); EyouSoft.Toolkit.DAL.DbHelper.RunProcedure(dc, this._db); object Result = this._db.GetParameterValue(dc, "Result"); if (!Result.Equals(null)) { IsTrue = int.Parse(Result.ToString()) > 0 ? true : false; } return(IsTrue); }
/// <summary> /// 根据 文件ID 获取文件实体信息 /// </summary> /// <param name="DocumentsId">文件ID</param> /// <returns></returns> public EyouSoft.Model.GovStructure.MGovDocuments GetGovFilePersonnelModel(string DocumentsId) { EyouSoft.Model.GovStructure.MGovDocuments model = null; if (!string.IsNullOrEmpty(DocumentsId)) { model = new EyouSoft.Model.GovStructure.MGovDocuments(); model = dal.GetGovDocumentsModel(DocumentsId, ItemType); } return(model); }
/// <summary> /// 获取文件信息列表 /// </summary> /// <param name="CompanyId">公司编号</param> /// <param name="FontSize">文件字号</param> /// <param name="Company">发布单位</param> /// <param name="Title">标题</param> /// <param name="ItemType">附件类型</param> /// <param name="PageSize">页面数据总记录数</param> /// <param name="PageIndex">当前页数</param> /// <param name="RecordCount">每页显示的记录数</param> /// <returns></returns> public IList <EyouSoft.Model.GovStructure.MGovDocuments> GetGovDocumentsList(string CompanyId, string FontSize, string Company, string Title, EyouSoft.Model.EnumType.ComStructure.AttachItemType ItemType, int PageSize, int PageIndex, ref int RecordCount) { IList <EyouSoft.Model.GovStructure.MGovDocuments> ResultList = null; string tableName = "view_GovDocuments"; string identityColumnName = "Id"; string fields = "DocumentsId,CompanyId,FontSize,Company,Title,FileType,AttnId,OperatorID,IssueTime,ApproveState,AttnName,ComAttachXML,GovDocumentsApproveXML "; string query = string.Format(" CompanyId='{0}' ", CompanyId); if (!string.IsNullOrEmpty(FontSize)) { query = query + string.Format(" AND FontSize LIKE '%{0}%'", FontSize); } if (!string.IsNullOrEmpty(Company)) { query = query + string.Format(" AND Company LIKE '%{0}%'", Company); } if (!string.IsNullOrEmpty(Title)) { query = query + string.Format(" AND Title LIKE '%{0}%'", Title); } string orderByString = " IssueTime DESC"; using (IDataReader dr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(_db, PageSize, PageIndex, ref RecordCount, tableName, identityColumnName, fields, query, orderByString)) { ResultList = new List <EyouSoft.Model.GovStructure.MGovDocuments>(); EyouSoft.Model.GovStructure.MGovDocuments model = null; while (dr.Read()) { model = new EyouSoft.Model.GovStructure.MGovDocuments(); model.DocumentsId = dr.GetString(dr.GetOrdinal("DocumentsId")); model.CompanyId = dr.GetString(dr.GetOrdinal("CompanyId")); model.FontSize = dr.IsDBNull(dr.GetOrdinal("FontSize")) ? "" : dr.GetString(dr.GetOrdinal("FontSize")); model.Company = dr.IsDBNull(dr.GetOrdinal("Company")) ? "" : dr.GetString(dr.GetOrdinal("Company")); model.Title = dr.IsDBNull(dr.GetOrdinal("Title")) ? "" : dr.GetString(dr.GetOrdinal("Title")); model.FileType = (EyouSoft.Model.EnumType.GovStructure.FileType)dr.GetByte(dr.GetOrdinal("FileType")); model.AttnId = dr.IsDBNull(dr.GetOrdinal("AttnId")) ? "" : dr.GetString(dr.GetOrdinal("AttnId")); model.AttnName = dr.IsDBNull(dr.GetOrdinal("AttnName")) ? "" : dr.GetString(dr.GetOrdinal("AttnName")); model.OperatorID = !dr.IsDBNull(dr.GetOrdinal("OperatorID")) ? dr.GetString(dr.GetOrdinal("OperatorID")) : ""; if (!dr.IsDBNull(dr.GetOrdinal("IssueTime"))) { model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); } model.ApproveState = (EyouSoft.Model.EnumType.GovStructure.ApprovalStatus)dr.GetByte(dr.GetOrdinal("ApproveState")); model.ComAttachList = this.GetAttachList(dr["ComAttachXML"].ToString(), model.DocumentsId, ItemType); model.GovDocumentsApproveList = this.GetGovDocumentsApproveList(dr["GovDocumentsApproveXML"].ToString()); ResultList.Add(model); model = null; } }; return(ResultList); }
/// <summary> /// 根据 文件ID 获取文件实体信息 /// </summary> /// <param name="ID">文件ID</param> /// <param name="ItemType">附件类型</param> /// <returns></returns> public EyouSoft.Model.GovStructure.MGovDocuments GetGovDocumentsModel(string ID, EyouSoft.Model.EnumType.ComStructure.AttachItemType ItemType) { EyouSoft.Model.GovStructure.MGovDocuments model = null; StringBuilder StrSql = new StringBuilder(); StrSql.Append("SELECT DocumentsId,CompanyId,FontSize,Company,Title,FileType,AttnId,OperatorID,IssueTime,ApproveState, "); StrSql.Append(" (SELECT TOP 1 Name FROM tbl_GovFile WHERE ID=a.AttnId )AS AttnName, "); StrSql.AppendFormat(" (SELECT Name,FilePath,Size,Downloads FROM tbl_ComAttach WHERE ItemType={0} AND ItemId=a.DocumentsId FOR XML RAW,ROOT('ROOT'))AS ComAttachXML,", (int)ItemType); StrSql.Append(" (SELECT DocumentsId,ApproveID,ApproveName,ApproveTime,ApprovalViews,ApproveState FROM tbl_GovDocumentsApprove WHERE DocumentsId=a.DocumentsId FOR XML RAW,ROOT('ROOT'))AS GovDocumentsApproveXML "); StrSql.AppendFormat(" FROM tbl_GovDocuments a WHERE a.DocumentsId='{0}' ", ID); DbCommand dc = this._db.GetSqlStringCommand(StrSql.ToString()); using (IDataReader dr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(dc, this._db)) { if (dr.Read()) { model = new EyouSoft.Model.GovStructure.MGovDocuments(); model.DocumentsId = dr.GetString(dr.GetOrdinal("DocumentsId")); model.CompanyId = dr.GetString(dr.GetOrdinal("CompanyId")); model.FontSize = dr.IsDBNull(dr.GetOrdinal("FontSize")) ? "" : dr.GetString(dr.GetOrdinal("FontSize")); model.Company = dr.IsDBNull(dr.GetOrdinal("Company")) ? "" : dr.GetString(dr.GetOrdinal("Company")); model.Title = dr.IsDBNull(dr.GetOrdinal("Title")) ? "" : dr.GetString(dr.GetOrdinal("Title")); model.FileType = (EyouSoft.Model.EnumType.GovStructure.FileType)dr.GetByte(dr.GetOrdinal("FileType")); model.AttnId = dr.IsDBNull(dr.GetOrdinal("AttnId")) ? "" : dr.GetString(dr.GetOrdinal("AttnId")); model.AttnName = dr.IsDBNull(dr.GetOrdinal("AttnName")) ? "" : dr.GetString(dr.GetOrdinal("AttnName")); model.OperatorID = !dr.IsDBNull(dr.GetOrdinal("OperatorID")) ? dr.GetString(dr.GetOrdinal("OperatorID")) : ""; if (!dr.IsDBNull(dr.GetOrdinal("IssueTime"))) { model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); } model.ApproveState = (EyouSoft.Model.EnumType.GovStructure.ApprovalStatus)dr.GetByte(dr.GetOrdinal("ApproveState")); model.ComAttachList = this.GetAttachList(dr["ComAttachXML"].ToString(), model.DocumentsId, ItemType); model.GovDocumentsApproveList = this.GetGovDocumentsApproveList(dr["GovDocumentsApproveXML"].ToString()); } }; return(model); }