/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.SMT_ROLE_FUN model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SMT_ROLE_FUN("); strSql.Append("ROLE_ID,FUN_ID,ROLE_TYPE)"); strSql.Append(" values ("); strSql.Append("@ROLE_ID,@FUN_ID,@ROLE_TYPE)"); SqlParameter[] parameters = { new SqlParameter("@ROLE_ID", SqlDbType.Decimal, 9), new SqlParameter("@FUN_ID", SqlDbType.Decimal, 9), new SqlParameter("@ROLE_TYPE", SqlDbType.TinyInt, 1) }; parameters[0].Value = model.ROLE_ID; parameters[1].Value = model.FUN_ID; parameters[2].Value = model.ROLE_TYPE; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.SMT_ROLE_FUN model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SMT_ROLE_FUN set "); #warning 系统发现缺少更新的字段,请手工确认如此更新是否正确! strSql.Append("ROLE_ID=@ROLE_ID,"); strSql.Append("FUN_ID=@FUN_ID,"); strSql.Append("ROLE_TYPE=@ROLE_TYPE"); strSql.Append(" where ROLE_ID=@ROLE_ID and FUN_ID=@FUN_ID and ROLE_TYPE=@ROLE_TYPE "); SqlParameter[] parameters = { new SqlParameter("@ROLE_ID", SqlDbType.Decimal, 9), new SqlParameter("@FUN_ID", SqlDbType.Decimal, 9), new SqlParameter("@ROLE_TYPE", SqlDbType.TinyInt, 1) }; parameters[0].Value = model.ROLE_ID; parameters[1].Value = model.FUN_ID; parameters[2].Value = model.ROLE_TYPE; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.SMT_ROLE_FUN GetModel(decimal ROLE_ID, decimal FUN_ID, int ROLE_TYPE) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ROLE_ID,FUN_ID,ROLE_TYPE from SMT_ROLE_FUN "); strSql.Append(" where ROLE_ID=@ROLE_ID and FUN_ID=@FUN_ID and ROLE_TYPE=@ROLE_TYPE "); SqlParameter[] parameters = { new SqlParameter("@ROLE_ID", SqlDbType.Decimal, 9), new SqlParameter("@FUN_ID", SqlDbType.Decimal, 9), new SqlParameter("@ROLE_TYPE", SqlDbType.TinyInt, 1) }; parameters[0].Value = ROLE_ID; parameters[1].Value = FUN_ID; parameters[2].Value = ROLE_TYPE; Maticsoft.Model.SMT_ROLE_FUN model = new Maticsoft.Model.SMT_ROLE_FUN(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.SMT_ROLE_FUN DataRowToModel(DataRow row) { Maticsoft.Model.SMT_ROLE_FUN model = new Maticsoft.Model.SMT_ROLE_FUN(); if (row != null) { if (row["ROLE_ID"] != null && row["ROLE_ID"].ToString() != "") { model.ROLE_ID = decimal.Parse(row["ROLE_ID"].ToString()); } if (row["FUN_ID"] != null && row["FUN_ID"].ToString() != "") { model.FUN_ID = decimal.Parse(row["FUN_ID"].ToString()); } if (row["ROLE_TYPE"] != null && row["ROLE_TYPE"].ToString() != "") { model.ROLE_TYPE = int.Parse(row["ROLE_TYPE"].ToString()); } } return(model); }
private void btnOk_Click(object sender, EventArgs e) { //读取菜单权限 List <Maticsoft.Model.SMT_FUN_MENUPOINT> funs = GetSelectModels <Maticsoft.Model.SMT_FUN_MENUPOINT>(advPrivate, CheckState.Indeterminate, CheckState.Checked); //读取部门菜单 List <Maticsoft.Model.SMT_ORG_INFO> orgs = null; if (deptTree.IsLoaded) { orgs = GetSelectModels <Maticsoft.Model.SMT_ORG_INFO>(deptTree.Tree, CheckState.Checked); } //读取门参数 List <Maticsoft.Model.SMT_DOOR_INFO> doors = null; if (doorTree.IsLoaded) { doors = GetSelectModels <Maticsoft.Model.SMT_DOOR_INFO>(doorTree.Tree, CheckState.Checked); } //读取人脸参数 List <Maticsoft.Model.SMT_FACERECG_DEVICE> faces = null; if (faceDevTree.IsLoaded) { faces = GetSelectModels <Maticsoft.Model.SMT_FACERECG_DEVICE>(faceDevTree.Tree, CheckState.Checked); } CtrlWaiting waiting = new CtrlWaiting(() => { try { Maticsoft.BLL.SMT_ROLE_FUN rolefunBll = new Maticsoft.BLL.SMT_ROLE_FUN(); Maticsoft.DBUtility.DbHelperSQL.ExecuteSql("delete from SMT_ROLE_FUN where ROLE_ID=" + _roleInfo.ID + " and (ROLE_TYPE=1 or ROLE_TYPE is null)"); if (funs.Count > 0) { foreach (var item in funs) { Maticsoft.Model.SMT_ROLE_FUN rf = new Maticsoft.Model.SMT_ROLE_FUN(); rf.ROLE_ID = _roleInfo.ID; rf.FUN_ID = item.ID; rf.ROLE_TYPE = 1; rolefunBll.Add(rf); } } SmtLog.InfoFormat("用户", "更新角色:{0}菜单权限,个数:{1}.", _roleInfo.ROLE_NAME, funs.Count); if (orgs != null) { Maticsoft.DBUtility.DbHelperSQL.ExecuteSql("delete from SMT_ROLE_FUN where ROLE_ID=" + _roleInfo.ID + " and ROLE_TYPE=2"); foreach (var item in orgs) { Maticsoft.Model.SMT_ROLE_FUN rf = new Maticsoft.Model.SMT_ROLE_FUN(); rf.ROLE_ID = _roleInfo.ID; rf.FUN_ID = item.ID; rf.ROLE_TYPE = 2; rolefunBll.Add(rf); } SmtLog.InfoFormat("用户", "更新角色:{0}部门权限,个数:{1}.", _roleInfo.ROLE_NAME, orgs.Count); } if (doors != null) { Maticsoft.DBUtility.DbHelperSQL.ExecuteSql("delete from SMT_ROLE_FUN where ROLE_ID=" + _roleInfo.ID + " and ROLE_TYPE=3"); foreach (var item in doors) { Maticsoft.Model.SMT_ROLE_FUN rf = new Maticsoft.Model.SMT_ROLE_FUN(); rf.ROLE_ID = _roleInfo.ID; rf.FUN_ID = item.ID; rf.ROLE_TYPE = 3; rolefunBll.Add(rf); } SmtLog.InfoFormat("用户", "更新角色:{0}门禁权限,个数:{1}.", _roleInfo.ROLE_NAME, doors.Count); } if (faces != null) { Maticsoft.DBUtility.DbHelperSQL.ExecuteSql("delete from SMT_ROLE_FUN where ROLE_ID=" + _roleInfo.ID + " and ROLE_TYPE=4"); foreach (var item in faces) { Maticsoft.Model.SMT_ROLE_FUN rf = new Maticsoft.Model.SMT_ROLE_FUN(); rf.ROLE_ID = _roleInfo.ID; rf.FUN_ID = item.ID; rf.ROLE_TYPE = 4; rolefunBll.Add(rf); } SmtLog.InfoFormat("用户", "更新角色:{0}人脸设备权限,个数:{1}.", _roleInfo.ROLE_NAME, faces.Count); } this.Invoke(new Action(() => { this.DialogResult = DialogResult.OK; this.Close(); })); } catch (Exception ex) { WinInfoHelper.ShowInfoWindow(this, "更新角色权限失败:" + ex.Message); log.Error("更新角色权限失败:", ex); } }); waiting.Show(this); }