private void UpdateActions(SystemRule securtiyRule)
{
foreach (Actions action in _actionList)
{
if (action.ActionValue != 1024)
{
action.ActionCheckBox.Checked = false;
}
}
var actionNum = securtiyRule.actions;
foreach (Actions action in _actionList)
{
if (actionNum - action.ActionValue >= 0)
{
if (action.ActionValue == 1024)
{
actionNum -= action.ActionValue;
}
else
{
actionNum -= action.ActionValue;
action.ActionCheckBox.Checked = true;
}
}
}
}
private void UpdateDetails()
{
try
{
SystemRule securtiyRule = (SystemRule)dgvSysRules.CurrentRow.DataBoundItem;
cbContext.DataSource = Enum.GetValues(typeof(RuleContext));
RuleContext ruleContext = securtiyRule.RuleContext;
cbContext.SelectedItem = ruleContext;
UpdateActions(securtiyRule);
txtId.Text = securtiyRule.id;
dtpCreationDate.Text = securtiyRule.createdDate.ToString();
dtpModifiedDate.Text = securtiyRule.modifiedDate.ToString();
txtModifiedUser.Text = securtiyRule.modifiedByUserName;
txtCategory.Text = securtiyRule.category;
txtType.Text = securtiyRule.type;
txtName.Text = securtiyRule.name;
txtRule.Text = securtiyRule.rule;
txtComments.Text = securtiyRule.comment;
txtResourceFilters.Text = securtiyRule.resourceFilter;
cbDisabled.Checked = securtiyRule.disabled;
}
catch
{
MessageBox.Show("Nothing selected");
}
}
/// <summary>
/// 新增角色
/// </summary>
/// <param name="rule">rule</param>
/// Author : Napoleon
/// Created : 2015-01-27 15:29:05
public int InsertRule(SystemRule rule)
{
int count;
try
{
string sql = "SELECT Id FROM dbo.System_Rule WHERE ProjectId=@ProjectId AND Name=@Name";
SqlParameter[] parameters =
{
new SqlParameter("@ProjectId", rule.ProjectId),
new SqlParameter("@Name", rule.Name)
};
DataTable dt = DbHelper.GetDataTable(sql, parameters);
if (dt.Rows.Count > 0)
{
count = -1;
}
else
{
sql = "INSERT INTO dbo.System_Rule (ProjectId,Id,Name,ParentId,Sort,Remark,Operator) VALUES (@ProjectId,@Id,@Name,@ParentId,@Sort,@Remark,@Operator)";
count = DbHelper.ExecuteSql(sql, rule);
}
}
catch (Exception exception)
{
count = 0;
Log4Dao.InsertLog4(exception.Message);
}
return(count);
}
/// <summary>
/// 保存新增
/// </summary>
/// <param name="projectId">The project identifier.</param>
/// <param name="parentId">The parent identifier.</param>
/// <param name="name">The name.</param>
/// <param name="sort">The sort.</param>
/// <param name="remark">The remark.</param>
/// Author : Napoleon
/// Created : 2015-01-27 16:03:55
public ActionResult SaveRule(string projectId, string parentId, string name, decimal sort, string remark)
{
SystemRule rule = new SystemRule();
rule.ProjectId = projectId;
rule.Id = CustomId.GetCustomId();
rule.ParentId = string.IsNullOrWhiteSpace(parentId) ? "0" : parentId;
rule.Name = name;
rule.Sort = sort;
rule.Remark = remark;
rule.Operator = PublicFields.UserCookie.ReadCookie <SystemUser>().UserName;
int count = _ruleService.InsertRule(rule);
string status = "failue", msg, json;
switch (count)
{
case -1:
msg = "添加失败,该角色名称已经存在,请不要重复添加！";
break;
case 1:
status = "success";
msg = "添加成功！";
break;
default:
msg = "添加失败！";
break;
}
json = PublicFunc.ModelToJson(status, msg);
return(Content(json));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="rule">The rule.</param>
/// Author : Napoleon
/// Created : 2015-01-27 16:28:34
public int UpdateRule(SystemRule rule)
{
int count;
try
{
string sql = "SELECT Id FROM dbo.System_Rule WHERE ProjectId=@ProjectId AND Name=@Name";
SqlParameter[] parameters =
{
new SqlParameter("@ProjectId", rule.ProjectId),
new SqlParameter("@Name", rule.Name)
};
DataTable dt = DbHelper.GetDataTable(sql, parameters);
if (dt.Rows.Count == 0 || dt.Rows[0][0].ToString().Equals(rule.Id))
{
sql = "UPDATE dbo.System_Rule SET Name=@Name,ParentId=@ParentId,Sort=@Sort,Remark=@Remark,Operator=@Operator WHERE Id=@Id";
count = DbHelper.ExecuteSql(sql, rule);
}
else
{
count = -1;
}
}
catch (Exception exception)
{
count = 0;
Log4Dao.InsertLog4(exception.Message);
}
return(count);
}
public SystemRule UpdateSingleSecurityRule(SystemRule rule)
{
string systemRuleJson = JsonConvert.SerializeObject(rule);
string resultJson = GetBasicAPICall(@"systemrule\" + rule.id, UpdateType.PUT, systemRuleJson);
return(JsonConvert.DeserializeObject <SystemRule>(resultJson));
}
public string DeleteSecurityRule(SystemRule rule)
{
string systemRuleJson = JsonConvert.SerializeObject(rule);
string resultJson = GetBasicAPICall(@"systemrule\" + rule.id, UpdateType.DELETE, systemRuleJson);
return(resultJson);
}
public string GetUnitCode(string fullName, string name)
{
string text = string.Empty;
List <string> listUnitCodeByName = this.GetListUnitCodeByName(name);
foreach (string text2 in listUnitCodeByName)
{
if (fullName.Equals(SystemRule.GetUnitFullName(text2)))
{
return(text2);
}
}
return(text);
}
public List <EmployScoreMode> GetUserByUnitCode(string unitCode)
{
List <EmployScoreMode> list = new List <EmployScoreMode>();
EmployScoreMode item = new EmployScoreMode();
EntityData usersByUnit = SystemRule.GetUsersByUnit(unitCode);
foreach (DataRow row in usersByUnit.Tables[0].Rows)
{
item = new EmployScoreMode();
item.UserName = row["UserName"].ToString();
item.UserCode = row["UserCode"].ToString();
list.Add(item);
}
return(list);
}
/// <summary>
/// 根据ID查询
/// </summary>
/// <param name="id">id</param>
/// Author : Napoleon
/// Created : 2015-01-27 16:24:30
public SystemRule GetRule(string id)
{
SystemRule rule = new SystemRule();
try
{
string sql = "SELECT ProjectId ,Id ,Name ,ParentId,Person,Address,TelPhone ,Sort ,Remark ,Operator FROM dbo.System_Rule WHERE Id=@Id";
rule = DbHelper.GetEnumerable <SystemRule>(sql, new { @Id = id });
}
catch (Exception exception)
{
Log4Dao.InsertLog4(exception.Message);
}
return(rule);
}
private void txtDelete_Click(object sender, EventArgs e)
{
try
{
SystemRule sysrule = (SystemRule)dgvSysRules.CurrentRow.DataBoundItem;
dgvSysRules[1, 0].Selected = true;
securityRules.Remove(sysrule);
//Update QS via Repo API
txtServerInfo.Text = _currentConn.QsRepoAPI.DeleteSecurityRule(sysrule);
}
catch (Exception ex)
{
txtServerInfo.Text = "Delete failed: " + ex.Message;
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
SystemRule sysrule = (SystemRule)dgvSysRules.CurrentRow.DataBoundItem;
var obcSysrule = securityRules.Single(s => s.id == sysrule.id);
obcSysrule.name = txtName.Text;
obcSysrule.rule = txtRule.Text;
Int64 Action = 0;
foreach (Actions action in _actionList)
{
if (action.ActionValue != 1024)
{
if (action.ActionCheckBox.Checked)
{
Action += action.ActionValue;
}
}
}
obcSysrule.actions = Action;
obcSysrule.resourceFilter = txtResourceFilters.Text;
obcSysrule.comment = txtComments.Text;
obcSysrule.disabled = cbDisabled.Checked;
obcSysrule.RuleContext = (RuleContext)Enum.Parse(typeof(RuleContext), cbContext.SelectedItem.ToString());
//Update QS via Repo API
SystemRule updatedSysRule = _currentConn.QsRepoAPI.UpdateSingleSecurityRule(sysrule);
obcSysrule.modifiedByUserName = updatedSysRule.modifiedByUserName;
obcSysrule.modifiedDate = updatedSysRule.modifiedDate;
dgvSysRules.Refresh();
}
catch (Exception ex)
{
txtServerInfo.Text = "Update failed: " + ex.Message;
}
}
/// <summary>
/// 显示开标人列表
///
/// </summary>
/// <param name="IsNew"></param>
private void LoadBiddingOpener(bool IsNew)
{
List <string> listOpener = BiddingBFL.ListAvaiableBiddingOpener();
List <string[]> listSelectedOpener = BiddingBFL.ListBiddingOpener(this.BiddingEmitCode);
chkOpener.Items.Clear();
foreach (string item in listOpener)
{
ListItem opener = new ListItem();
opener.Text = SystemRule.GetUserName(item);
opener.Value = item;
if (IsNew)
{
opener.Selected = true;
}
else
{
foreach (string[] selectitem in listSelectedOpener)
{
if (selectitem[0] == item)
{
opener.Selected = true;
if (selectitem[1] != "")
{
opener.Text += "(" + selectitem[1] + ")";
}
else
{
opener.Text += "( - - - )";
}
}
}
}
chkOpener.Items.Add(opener);
}
chkOpener.Enabled = false;
}
public ActionResult Create([DataSourceRequest] DataSourceRequest request, SystemRuleVM viewModel)
{
try
{
if (viewModel != null && ModelState.IsValid)
{
SystemRule newviewModel = new SystemRule();
newviewModel.SystemName = viewModel.SystemName;
newviewModel.Description = viewModel.Description;
db.SystemRules.Add(newviewModel);
db.SaveChanges();
viewModel.SystemRuleId = newviewModel.SystemRuleId;
}
}
catch (DataException dataEx)
{
ModelState.AddModelError(string.Empty, "Data error");
Elmah.ErrorSignal.FromCurrentContext().Raise(dataEx);
}
return Json(new[] { viewModel }.ToDataSourceResult(request, ModelState));
}
public string GetDeptNameByDeptID(string deptID)
{
return(SystemRule.GetUnitName(deptID));
}
public DataTable GetDeptListByUserCode(string userCode)
{
return(SystemRule.GetNewUnitListByUserCode(userCode));
}
public string GetUserNameByUserID(string userID)
{
return(SystemRule.GetUserName(userID));
}
/// <summary>
/// 新增角色
/// </summary>
/// <param name="rule">The rule.</param>
/// Author : Napoleon
/// Created : 2015-01-27 15:29:05
public int InsertRule(SystemRule rule)
{
return(_ruleDao.InsertRule(rule));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="rule">The rule.</param>
/// Author : Napoleon
/// Created : 2015-01-27 16:28:34
public int UpdateRule(SystemRule rule)
{
return(_ruleDao.UpdateRule(rule));
}
public string GetDeptNameByDeptCode(string deptCode)
{
return(SystemRule.GetUnitName(deptCode));
}
public string GetUserNameByUserCode(string userCode)
{
return(SystemRule.GetUserName(userCode));
}
/// <summary>
///
/// </summary>
/// <param name="systemRule"></param>
public BNFSystemRef(SystemRule systemRule)
{
rule = systemRule;
}
public string GetUnitFullName(string unitCode)
{
return(SystemRule.GetUnitFullName(unitCode));
}
