public static bool Set(string strDocRoleId, int docRoleState, string strCrUsrId, string strUpUsrId, string[] docIdList, string strRoleId)
{
Model.DocUsrRole docUsrRole = new Model.DocUsrRole()
{
crdt = DateTime.Now,
crUsrId = strCrUsrId,
docRoleState = docRoleState,
docRoleId = strDocRoleId,
roleId = strRoleId,
updt = DateTime.Now,
upUsrId = strUpUsrId
};
return(Repository.DocUsrRole.Set(docUsrRole, docIdList));
}
public static bool Delete(Model.DocUsrRole docUsrRole)
{
/*先清空原有关系*/
CmdParams cpDel = new CmdParams
{
cmd = "delete from docUsrRole where roleId=?roleId and docId=?docId",
param = new DynamicParameters()
};
cpDel.param.Add("?roleId", docUsrRole.roleId);
cpDel.param.Add("?docId", docUsrRole.docId);
/*调用事务处理*/
int rows = mysql.ExcuteNonQuery <Model.DocUsrRole>(DapperMySQLHelper.ConnectionString, cpDel.cmd, cpDel.param, false);
return(rows > 0);
}
public static bool Set(Model.DocUsrRole docUsrRole, string[] docIdList)
{
List <CmdParams> parameters = new List <CmdParams>();
/*先清空原有关系*/
CmdParams cpDel = new CmdParams
{
cmd = "delete from docUsrRole where roleId=?roleId",
param = new DynamicParameters()
};
cpDel.param.Add("?roleId", docUsrRole.roleId);
parameters.Add(cpDel);
/*批量更新到最新关系*/
foreach (var item in docIdList)
{
CmdParams cp = new CmdParams
{
cmd = "insert into docUsrRole(docRoleId,docId,roleId,docRoleState,crdt,crUsrId,updt,upUsrId) values (?docRoleId,?docId,?roleId,?docRoleState,?crdt,?crUsrId,?updt,?upUsrId)",
param = new DynamicParameters()
};
cp.param.Add("?docRoleId", Guid.NewGuid().ToString());
cp.param.Add("?roleId", docUsrRole.roleId);
cp.param.Add("?docId", item);
cp.param.Add("?docRoleState", 1);
cp.param.Add("?crdt", docUsrRole.crdt);
cp.param.Add("?crUsrId", docUsrRole.crUsrId);
cp.param.Add("?updt", docUsrRole.updt);
cp.param.Add("?upUsrId", docUsrRole.upUsrId);
parameters.Add(cp);
}
/*调用事务处理*/
int rows = mysql.ExcuteNonQueryTransaction <Model.DocUsrRole>(DapperMySQLHelper.ConnectionString, parameters, false);
return(rows > 0);
}
private static void SaveDocRole(List <string> viewRoleList, string strCrUsrId, string strDocId, bool isDefault)
{
List <Model.DocUsrRole> viewDocRoleList = new List <Model.DocUsrRole>();
//增加管理员权限
Model.DocUsrRole docAdminRole = new Model.DocUsrRole()
{
crdt = DateTime.Now,
crUsrId = strCrUsrId,
docId = strDocId,
docRoleId = Guid.NewGuid().ToString(),
docRoleState = 1,
roleId = "4be2ec6a-5ca6-4a73-8975-892189b72137",
updt = DateTime.Now,
upUsrId = strCrUsrId
};
//DocUsrRole.Add(docAdminRole);
viewDocRoleList.Add(docAdminRole);
//游客是否可见权限
Model.DocUsrRole docUsrRole = new Model.DocUsrRole()
{
crdt = DateTime.Now,
crUsrId = strCrUsrId,
docId = strDocId,
docRoleId = Guid.NewGuid().ToString(),
docRoleState = 1,
roleId = "4b5df8d4-e422-48b4-8138-7fd6806dd214",
updt = DateTime.Now,
upUsrId = strCrUsrId
};
//为文档增加默认游客可见权限
if (isDefault)
{
//DocUsrRole.Add(docUsrRole);
viewDocRoleList.Add(docUsrRole);
}
else
{
DocUsrRole.Delete(docUsrRole);
}
if (viewRoleList != null && viewRoleList.Count > 0)
{
//List<Model.DocUsrRole> viewDocRoleList = new List<Model.DocUsrRole>();
foreach (var item in viewRoleList)
{
Model.DocUsrRole _docUsrRole = new Model.DocUsrRole()
{
crdt = DateTime.Now,
crUsrId = strCrUsrId,
docId = strDocId,
docRoleId = Guid.NewGuid().ToString(),
docRoleState = 1,
roleId = item,
updt = DateTime.Now,
upUsrId = strCrUsrId
};
viewDocRoleList.Add(_docUsrRole);
}
}
if (viewDocRoleList.Count > 0)
{
DocUsrRole.Add(viewDocRoleList);
}
}
