/// <summary> /// 更新一条数据 /// </summary> public bool Update(GSSModel.Roles model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_Roles set "); strSql.Append("F_RoleName=@F_RoleName,"); strSql.Append("F_IsUsed=@F_IsUsed,"); strSql.Append("F_Power=@F_Power"); strSql.Append(" where F_RoleID=@F_RoleID"); SqlParameter[] parameters = { new SqlParameter("@F_RoleName", SqlDbType.NVarChar, 16), new SqlParameter("@F_IsUsed", SqlDbType.Bit, 1), new SqlParameter("@F_Power", SqlDbType.NVarChar),//2017-08-29 存储的权限ID列表不做长度限制 new SqlParameter("@F_RoleID", SqlDbType.Int, 4) }; parameters[0].Value = model.F_RoleName; parameters[1].Value = model.F_IsUsed; parameters[2].Value = model.F_Power; parameters[3].Value = model.F_RoleID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(GSSModel.Roles model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_Roles("); strSql.Append("F_RoleName,F_IsUsed,F_Power)"); strSql.Append(" values ("); strSql.Append("@F_RoleName,@F_IsUsed,@F_Power)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@F_RoleName", SqlDbType.NVarChar, 16), new SqlParameter("@F_IsUsed", SqlDbType.Bit, 1), new SqlParameter("@F_Power", SqlDbType.NVarChar) }; parameters[0].Value = model.F_RoleName; parameters[1].Value = model.F_IsUsed; parameters[2].Value = model.F_Power; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 保存数据 /// </summary> private void SaveData() { //验证数据项 string msg = ""; if (f_RoleNameTextBox.Text.Trim().Length == 0) { msg += "角色名不能为空!\r\n"; } if (msg.Length > 0) { MessageBox.Show(msg, "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } //数据准备 GSSModel.Roles model = new GSSModel.Roles(); model.F_RoleName = f_RoleNameTextBox.Text; model.F_IsUsed = f_IsUsedCheckBox.Checked; model.F_Power = GetTreeValue(null); model.F_Power += ","; //数据提交 GSSBLL.Roles bll = new GSSBLL.Roles(); bool isok = false; if (_id != 0) { model.F_RoleID = int.Parse(f_RoleIDTextBox.Text); isok = bll.Update(model); } else { int num = bll.Add(model); if (num > 0) { isok = true; } } if (isok) { MessageBox.Show("数据保存成功!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("数据保存失败!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// 初始化窗体 /// </summary> private void InitForm() { BindPower(); if (_id != 0) { this.Text = "角色修改"; GSSBLL.Roles bll = new GSSBLL.Roles(); GSSModel.Roles model = bll.GetModel(_id); f_RoleIDTextBox.Text = model.F_RoleID.ToString(); f_RoleNameTextBox.Text = model.F_RoleName; f_IsUsedCheckBox.Checked = model.F_IsUsed; SetTreeValue(null, model.F_Power); } }
/// <summary> /// 得到一个对象实体 /// </summary> public GSSModel.Roles GetModel(int F_RoleID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 F_RoleID,F_RoleName,F_IsUsed,F_Power from T_Roles "); strSql.Append(" where F_RoleID=@F_RoleID"); SqlParameter[] parameters = { new SqlParameter("@F_RoleID", SqlDbType.Int, 4) }; parameters[0].Value = F_RoleID; GSSModel.Roles model = new GSSModel.Roles(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["F_RoleID"].ToString() != "") { model.F_RoleID = int.Parse(ds.Tables[0].Rows[0]["F_RoleID"].ToString()); } if (ds.Tables[0].Rows[0]["F_RoleName"] != null) { model.F_RoleName = ds.Tables[0].Rows[0]["F_RoleName"].ToString(); } if (ds.Tables[0].Rows[0]["F_IsUsed"].ToString() != "") { if ((ds.Tables[0].Rows[0]["F_IsUsed"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_IsUsed"].ToString().ToLower() == "true")) { model.F_IsUsed = true; } else { model.F_IsUsed = false; } } if (ds.Tables[0].Rows[0]["F_Power"] != null) { model.F_Power = ds.Tables[0].Rows[0]["F_Power"].ToString(); } return(model); } else { return(null); } }