/// <summary> /// 修改角色名称 /// </summary> /// <returns></returns> public bool UpdatePowers(TF.RunSafty.Entry.Roles model) { string strSql = @"update tab_Roles set RolesPowers=@RolesPowers where Id=@id"; SqlParameter[] sqlParameter = { new SqlParameter("id", model.Id), new SqlParameter("RolesPowers", model.RolesPowers) }; return(SqlHelps.ExecuteNonQuery(SqlHelps.SQLConnString, CommandType.Text, strSql, sqlParameter) > 0); }
/// <summary> /// 得到一个对象实体 /// </summary> public TF.RunSafty.Entry.Roles DataRowToModel(DataRow row) { TF.RunSafty.Entry.Roles model = new TF.RunSafty.Entry.Roles(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } model.RolesName = row["RolesName"].ToString(); model.RolesPowers = row["RolesPowers"].ToString(); } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public TF.RunSafty.Entry.Roles GetModel(int Id) { string strSql = "select * from tab_Roles where Id='" + Id + "'"; DataSet ds = SqlHelps.ReturnDataSet(SqlHelps.SQLConnString, CommandType.Text, strSql); TF.RunSafty.Entry.Roles rl = new TF.RunSafty.Entry.Roles(); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 添加角色 /// </summary> /// <param name="name"></param> /// <returns></returns> public int Add(TF.RunSafty.Entry.Roles model) { string strSql = @"insert into tab_Roles (RolesName) values (@RolesName)"; SqlParameter[] sqlParameter = { new SqlParameter("RolesName", model.RolesName) }; object obj = SqlHelps.ExecuteNonQuery(SqlHelps.SQLConnString, CommandType.Text, strSql, sqlParameter); if (DBNull.Value.Equals(obj)) { return(0); } return(Convert.ToInt32(obj)); }
/// <summary> /// 更新一条数据 /// </summary> public bool UpdatePowers(TF.RunSafty.Entry.Roles model) { return(DBRl.UpdatePowers(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(TF.RunSafty.Entry.Roles model) { return(DBRl.Add(model)); }