/// <summary> /// 新增文档 /// </summary> /// <param name="strDocTypeId"></param> /// <param name="strDocTitle"></param> /// <param name="strDocContent"></param> /// <param name="strDocFullText"></param> /// <param name="strDocNum"></param> /// <param name="strDocDeptId"></param> /// <param name="strCrUsrId"></param> /// <param name="strUpUsrId"></param> /// <param name="strDocState"></param> /// <returns></returns> public static bool Add(string strDocTypeId, string strDocTitle, string strDocContent, string strDocFullText, int?strDocNum, string strDocDeptId, string strCrUsrId, int?strDocState, List <string> lstShareDeptIdList, string strDocAttachment, bool isDefault, List <string> viewRoleList, List <string> editRoleList) { string strDocId = Guid.NewGuid().ToString(); Model.HelpDoc helpDocModel = new Model.HelpDoc() { docContent = strDocContent, docCount = 0, docDeptId = strDocDeptId, docFullText = strDocFullText, docId = strDocId, docNum = strDocNum, docState = 1, docTitle = strDocTitle, docTypeId = strDocTypeId, crdt = DateTime.Now, crUsrId = strCrUsrId, updt = DateTime.Now, docAttachment = strDocAttachment, upUsrId = strCrUsrId }; return(Repository.HelpDoc.Add(helpDocModel, lstShareDeptIdList, isDefault, viewRoleList, editRoleList)); }
public static bool Add(Model.HelpDoc helpDocModel, List <string> lstShareDeptIdList, bool isDefault, List <string> viewRoleList, List <string> editRoleList) { using (TransactionScope ts = new TransactionScope()) { int rows = 0; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into helpdoc("); strSql.Append("docId,crdt,updt,docTypeId,docTitle,docContent,docFullText,docNum,docDeptId,docCount,crUsrId,upUsrId,docState,docAttachment)"); strSql.Append(" values ("); strSql.Append("@docId,@crdt,@updt,@docTypeId,@docTitle,@docContent,@docFullText,@docNum,@docDeptId,@docCount,@crUsrId,@upUsrId,@docState,@docAttachment)"); DynamicParameters parameters = new DynamicParameters(); parameters.Add("?docId", helpDocModel.docId); parameters.Add("?crdt", helpDocModel.crdt); parameters.Add("?updt", helpDocModel.updt); parameters.Add("?docTypeId", helpDocModel.docTypeId); parameters.Add("?docTitle", helpDocModel.docTitle); parameters.Add("?docContent", helpDocModel.docContent); parameters.Add("?docFullText", helpDocModel.docFullText); parameters.Add("?docNum", helpDocModel.docNum); parameters.Add("?docDeptId", helpDocModel.docDeptId); parameters.Add("?docCount", helpDocModel.docCount); parameters.Add("?crUsrId", helpDocModel.crUsrId); parameters.Add("?upUsrId", helpDocModel.upUsrId); parameters.Add("?docState", helpDocModel.docState); parameters.Add("?docAttachment", helpDocModel.docAttachment); Model.DocDeptRole docDeptRole = new Model.DocDeptRole() { Crdt = DateTime.Now, CrUsrId = helpDocModel.crUsrId, DocDeptRoleId = Guid.NewGuid().ToString(), DocDeptState = 1, Updt = DateTime.Now, UpUsrId = helpDocModel.crUsrId, DocId = helpDocModel.docId }; DocDeptRole.Set(docDeptRole, lstShareDeptIdList); //有编辑权限即有查看权限 foreach (var item in editRoleList) { if (!viewRoleList.Contains(item)) { viewRoleList.Add(item); } } SaveDocRole(viewRoleList, helpDocModel.crUsrId, helpDocModel.docId, isDefault); SaveDocRoleCtrl(editRoleList, helpDocModel.crUsrId, helpDocModel.docId); rows = mysql.ExcuteNonQuery <Model.HelpDoc>(DapperMySQLHelper.ConnectionString, strSql.ToString(), parameters, false); ts.Complete(); return(rows > 0); } }
/// <summary> /// 获取指定文档信息详情 /// </summary> /// <param name="strDocId">文档编号</param> /// <returns></returns> public static Model.HelpDoc GetModel(string strDocId) { Model.HelpDoc doc = Repository.HelpDoc.GetModel(strDocId); if (doc != null) { doc.IsDefaultRole = DocUsrRole.QueryExist(strDocId, "4b5df8d4-e422-48b4-8138-7fd6806dd214"); doc.docFullText = null; doc.viewRoleList = DocUsrRole.GetListByDocId(strDocId); doc.editRoleList = DocRoleCtrl.GetEditRoleList(strDocId); } return(doc); }
/// <summary> /// 获取所有文档清单(分页) /// </summary> /// <returns></returns> //public static IList<Model.HelpDoc> Search(int pageIndex,int rowCount,string strKeyWord, out int totalCount, out int pageCount, ClaimsPrincipal user) //{ // IList<Model.HelpDoc> helpDocList = // user.Identity.IsAuthenticated ? Repository.HelpDoc.Search(pageIndex,rowCount, strKeyWord,out totalCount,out pageCount, user.Identities.First(u => u.IsAuthenticated).FindFirst("UsrId").Value) // : Repository.HelpDoc.VisitorSearch(pageIndex, rowCount, strKeyWord, out totalCount, out pageCount); // return helpDocList; //} public static bool Update(string strDocId, string strDocTypeId, string strDocTitle, string strDocContent, string strDocFullText, int?strDocNum, string strDocDeptId, string strUpUsrId, int?strDocState, List <string> strShareDeptIdList, string strDocAttachment, bool isDefault, List <string> viewRoleList, List <string> editRoleList) { Model.HelpDoc helpDocModel = new Model.HelpDoc() { docContent = strDocContent, docDeptId = strDocDeptId, docFullText = strDocFullText, docId = strDocId, docNum = strDocNum, docState = 1, docTitle = strDocTitle, docTypeId = strDocTypeId, updt = DateTime.Now, docAttachment = strDocAttachment, upUsrId = strUpUsrId }; return(Repository.HelpDoc.Update(helpDocModel, isDefault, viewRoleList, editRoleList)); }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(Model.HelpDoc helpDocModel, bool isDefault, List <string> viewRoleList, List <string> editRoleList) { var roleList = UsrRole.GetModel(helpDocModel.upUsrId).ToList(); bool checkRole = false; //检查文档修改人是否有权限更新 foreach (var item in roleList) { if (DocRoleCtrl.Get(helpDocModel.docId, item.roleId).Count > 0) { checkRole = true; break; } } if (!checkRole) { return(false); } using (TransactionScope ts = new TransactionScope()) { StringBuilder strSql = new StringBuilder(); strSql.Append("update helpdoc set "); strSql.Append("docTypeId=?docTypeId,"); strSql.Append("docTitle=?docTitle,"); strSql.Append("docContent=?docContent,"); strSql.Append("docFullText=?docFullText,"); strSql.Append("docNum=?docNum,"); strSql.Append("docDeptId=?docDeptId,"); strSql.Append("docState=?docState,"); strSql.Append("updt=?updt,"); strSql.Append("updt=?updt,"); strSql.Append("docAttachment=?docAttachment"); strSql.Append(" where docId=?docId"); DynamicParameters parameters = new DynamicParameters(); parameters.Add("?docTypeId", helpDocModel.docTypeId); parameters.Add("?docTitle", helpDocModel.docTitle); parameters.Add("?docContent", helpDocModel.docContent); parameters.Add("?docFullText", helpDocModel.docFullText); parameters.Add("?docNum", helpDocModel.docNum); parameters.Add("?docDeptId", helpDocModel.docDeptId); parameters.Add("?docState", helpDocModel.docState); parameters.Add("?updt", helpDocModel.updt); parameters.Add("?upUsrId", helpDocModel.upUsrId); parameters.Add("?docId", helpDocModel.docId); parameters.Add("?docAttachment", helpDocModel.docAttachment); //有编辑权限即有查看权限 foreach (var item in editRoleList) { if (!viewRoleList.Contains(item)) { viewRoleList.Add(item); } } SaveDocRole(viewRoleList, helpDocModel.crUsrId, helpDocModel.docId, isDefault); SaveDocRoleCtrl(editRoleList, helpDocModel.crUsrId, helpDocModel.docId); int rows = mysql.ExcuteNonQuery <Model.HelpDoc>(DapperMySQLHelper.ConnectionString, strSql.ToString(), parameters, false); ts.Complete(); return(rows > 0); } }