/// <summary> /// 插入T_SYS_ROLES /// </summary> public virtual bool Insert(RolesOR roles) { string sql = "insert into T_SYS_ROLES (GUID, ROLE_NAME, ROLE_DESC) values (@GUID, @ROLE_NAME, @ROLE_DESC)"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@GUID", Guid.NewGuid().ToString()), new SqlParameter("@ROLE_NAME", roles.RoleName), new SqlParameter("@ROLE_DESC", roles.RoleDesc) }; return db.ExecuteNoQuery(sql, parameters) > -1; }
public RolesOR selectARowDate(string m_id) { string sql = string.Format("select * from T_SYS_ROLES where GUID='{0}'", m_id); DataTable dt = null; try { dt = db.ExecuteQueryDataSet(sql).Tables[0]; } catch (Exception ex) { throw ex; } if (dt == null) return null; if (dt.Rows.Count == 0) return null; DataRow dr = dt.Rows[0]; RolesOR m_Role = new RolesOR(dr); return m_Role; }
/// <summary> /// 更新T_SYS_ROLES /// </summary> public virtual bool Update(RolesOR roles) { string sql = "update T_SYS_ROLES set ROLE_NAME = @ROLE_NAME, ROLE_DESC = @ROLE_DESC where GUID = @GUID"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@GUID", SqlDbType.VarChar, 36, ParameterDirection.Input, false, 0, 0, "GUID", DataRowVersion.Default, roles.Guid), new SqlParameter("@ROLE_NAME", SqlDbType.NVarChar, 128, ParameterDirection.Input, false, 0, 0, "ROLE_NAME", DataRowVersion.Default, roles.RoleName), new SqlParameter("@ROLE_DESC", SqlDbType.NVarChar, 512, ParameterDirection.Input, false, 0, 0, "ROLE_DESC", DataRowVersion.Default, roles.RoleDesc) }; return db.ExecuteNoQuery(sql, parameters) > -1; }
private RolesOR setValue() { RolesOR T_SY = new RolesOR(); if (Request.QueryString["id"] != null) T_SY.Guid = Request.QueryString["id"].ToString(); T_SY.RoleName = txtName.Text;//角色名称 T_SY.RoleDesc = txtROLE_DESC.Text;//角色说明 return T_SY; }