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