private static void SaveDocRoleCtrl(List <string> editRoleList, string strCrUsrId, string strDocId)
{
List <Model.DocRoleCtrl> docRoleCtrls = new List <Model.DocRoleCtrl>();
Model.DocRoleCtrl docAdminRoleCtrl = new Model.DocRoleCtrl
{
Crdt = DateTime.Now,
Updt = DateTime.Now,
CrUsrId = strCrUsrId,
UpUsrId = strCrUsrId,
CtrlType = 1,
DocId = strDocId,
RoleId = "4be2ec6a-5ca6-4a73-8975-892189b72137"
};
docRoleCtrls.Add(docAdminRoleCtrl);
if (editRoleList != null && editRoleList.Count > 0)
{
foreach (var item in editRoleList)
{
Model.DocRoleCtrl docRoleCtrl = new Model.DocRoleCtrl
{
Crdt = DateTime.Now,
Updt = DateTime.Now,
CrUsrId = strCrUsrId,
UpUsrId = strCrUsrId,
CtrlType = 1,
DocId = strDocId,
RoleId = item
};
docRoleCtrls.Add(docRoleCtrl);
}
}
if (docRoleCtrls.Count > 0)
{
DocRoleCtrl.Add(docRoleCtrls);
}
}
/// <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);
}
}