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="strDocDeptRoleId"></param>
/// <param name="strUsrId"></param>
/// <param name="strRoleIdList"></param>
/// <param name="docDeptRoleState"></param>
/// <param name="strCrUsrId"></param>
/// <returns></returns>
public static bool Set(string strDocDeptRoleId, string strDocId, List <string> DeptIdList, int?docDeptRoleState, string strCrUsrId)
{
Model.DocDeptRole docDeptRole = new Model.DocDeptRole()
{
Crdt = DateTime.Now,
CrUsrId = strCrUsrId,
DocDeptRoleId = Guid.NewGuid().ToString(),
DocDeptState = docDeptRoleState,
Updt = DateTime.Now,
UpUsrId = strCrUsrId,
DocId = strDocId
};
return(Repository.DocDeptRole.Set(docDeptRole, DeptIdList));
}
public static bool Set(Model.DocDeptRole docDeptRole, List <string> shareDeptList)
{
int rows = 0;
List <CmdParams> parameters = new List <CmdParams>();
/*先清空原有关系*/
CmdParams cpDel = new CmdParams
{
cmd = "delete from docdeptrole where docId=?docId",
param = new DynamicParameters()
};
cpDel.param.Add("?docId", docDeptRole.DocId);
mysql.ExcuteNonQuery <Model.DocDeptRole>(DapperMySQLHelper.ConnectionString, cpDel.cmd, cpDel.param, false);
/*批量更新到最新关系*/
foreach (var item in shareDeptList)
{
rows = 0;
CmdParams cp = new CmdParams
{
cmd = "insert into docdeptrole(docDeptRoleId,docId,deptId,docDeptState,crdt,crUsrId,updt,upUsrId) values (?docDeptRoleId,?docId,?deptId,?docDeptState,?crdt,?crUsrId,?updt,?upUsrId)",
param = new DynamicParameters()
};
cp.param.Add("?docDeptRoleId", docDeptRole.DocDeptRoleId);
cp.param.Add("?docId", docDeptRole.DocId);
cp.param.Add("?deptId", item);
cp.param.Add("?docDeptState", docDeptRole.DocDeptState);
cp.param.Add("?crdt", docDeptRole.Crdt);
cp.param.Add("?crUsrId", docDeptRole.CrUsrId);
cp.param.Add("?updt", docDeptRole.Updt);
cp.param.Add("?upUsrId", docDeptRole.CrUsrId);
rows = mysql.ExcuteNonQuery <Model.DocDeptRole>(DapperMySQLHelper.ConnectionString, cp.cmd, cp.param, false);
}
return(rows > 0);
}
