/// <summary> /// 更新一条数据 /// </summary> public bool Update(OnLineTest.Model.UserAuthority model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update UserAuthority set "); strSql.Append("AuthorityId=@AuthorityId,"); strSql.Append("UserGroupId=@UserGroupId,"); strSql.Append("UserRankId=@UserRankId,"); strSql.Append("UserAuthoriryRemark=@UserAuthoriryRemark"); strSql.Append(" where UserAuthorityId=@UserAuthorityId"); SqlParameter[] parameters = { new SqlParameter("@AuthorityId", SqlDbType.Int, 4), new SqlParameter("@UserGroupId", SqlDbType.Int, 4), new SqlParameter("@UserRankId", SqlDbType.Int, 4), new SqlParameter("@UserAuthoriryRemark", SqlDbType.Text), new SqlParameter("@UserAuthorityId", SqlDbType.Int, 4) }; parameters[0].Value = model.AuthorityId; parameters[1].Value = model.UserGroupId; parameters[2].Value = model.UserRankId; parameters[3].Value = model.UserAuthoriryRemark; parameters[4].Value = model.UserAuthorityId; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public OnLineTest.Model.UserAuthority DataRowToModel(DataRow row) { OnLineTest.Model.UserAuthority model = new OnLineTest.Model.UserAuthority(); if (row != null) { if (row["UserAuthorityId"] != null && row["UserAuthorityId"].ToString() != "") { model.UserAuthorityId = int.Parse(row["UserAuthorityId"].ToString()); } if (row["AuthorityId"] != null && row["AuthorityId"].ToString() != "") { model.AuthorityId = int.Parse(row["AuthorityId"].ToString()); } if (row["UserGroupId"] != null && row["UserGroupId"].ToString() != "") { model.UserGroupId = int.Parse(row["UserGroupId"].ToString()); } if (row["UserRankId"] != null && row["UserRankId"].ToString() != "") { model.UserRankId = int.Parse(row["UserRankId"].ToString()); } if (row["UserAuthoriryRemark"] != null) { model.UserAuthoriryRemark = row["UserAuthoriryRemark"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(OnLineTest.Model.UserAuthority model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into UserAuthority("); strSql.Append("AuthorityId,UserGroupId,UserRankId,UserAuthoriryRemark)"); strSql.Append(" values ("); strSql.Append("@AuthorityId,@UserGroupId,@UserRankId,@UserAuthoriryRemark)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@AuthorityId", SqlDbType.Int, 4), new SqlParameter("@UserGroupId", SqlDbType.Int, 4), new SqlParameter("@UserRankId", SqlDbType.Int, 4), new SqlParameter("@UserAuthoriryRemark", SqlDbType.Text) }; parameters[0].Value = model.AuthorityId; parameters[1].Value = model.UserGroupId; parameters[2].Value = model.UserRankId; parameters[3].Value = model.UserAuthoriryRemark; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public OnLineTest.Model.UserAuthority GetModel(int UserAuthorityId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 UserAuthorityId,AuthorityId,UserGroupId,UserRankId,UserAuthoriryRemark from UserAuthority "); strSql.Append(" where UserAuthorityId=@UserAuthorityId"); SqlParameter[] parameters = { new SqlParameter("@UserAuthorityId", SqlDbType.Int, 4) }; parameters[0].Value = UserAuthorityId; OnLineTest.Model.UserAuthority model = new OnLineTest.Model.UserAuthority(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }