/// <summary> /// 增加一条数据 /// </summary> public bool Add(hm.Model.roleMenu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into roleMenu("); strSql.Append("roleId,menuId)"); strSql.Append(" values ("); strSql.Append("@roleId,@menuId)"); OleDbParameter[] parameters = { new OleDbParameter("@roleId", OleDbType.Integer, 4), new OleDbParameter("@menuId", OleDbType.Integer, 4) }; parameters[0].Value = model.roleId; parameters[1].Value = model.menuId; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(hm.Model.roleMenu model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update roleMenu set "); strSql.Append("roleId=@roleId,"); strSql.Append("menuId=@menuId"); strSql.Append(" where rmId=@rmId"); OleDbParameter[] parameters = { new OleDbParameter("@roleId", OleDbType.Integer, 4), new OleDbParameter("@menuId", OleDbType.Integer, 4), new OleDbParameter("@rmId", OleDbType.Integer, 4) }; parameters[0].Value = model.roleId; parameters[1].Value = model.menuId; parameters[2].Value = model.rmId; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public hm.Model.roleMenu GetModel(int rmId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select rmId,roleId,menuId from roleMenu "); strSql.Append(" where rmId=@rmId"); OleDbParameter[] parameters = { new OleDbParameter("@rmId", OleDbType.Integer, 4) }; parameters[0].Value = rmId; hm.Model.roleMenu model = new hm.Model.roleMenu(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["rmId"] != null && ds.Tables[0].Rows[0]["rmId"].ToString() != "") { model.rmId = int.Parse(ds.Tables[0].Rows[0]["rmId"].ToString()); } if (ds.Tables[0].Rows[0]["roleId"] != null && ds.Tables[0].Rows[0]["roleId"].ToString() != "") { model.roleId = int.Parse(ds.Tables[0].Rows[0]["roleId"].ToString()); } if (ds.Tables[0].Rows[0]["menuId"] != null && ds.Tables[0].Rows[0]["menuId"].ToString() != "") { model.menuId = int.Parse(ds.Tables[0].Rows[0]["menuId"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public hm.Model.roleMenu GetModel(int rmId) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 rmId,roleId,menuId from roleMenu "); strSql.Append(" where rmId=@rmId"); SqlParameter[] parameters = { new SqlParameter("@rmId", SqlDbType.Int,4) }; parameters[0].Value = rmId; hm.Model.roleMenu model=new hm.Model.roleMenu(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["rmId"]!=null && ds.Tables[0].Rows[0]["rmId"].ToString()!="") { model.rmId=int.Parse(ds.Tables[0].Rows[0]["rmId"].ToString()); } if(ds.Tables[0].Rows[0]["roleId"]!=null && ds.Tables[0].Rows[0]["roleId"].ToString()!="") { model.roleId=int.Parse(ds.Tables[0].Rows[0]["roleId"].ToString()); } if(ds.Tables[0].Rows[0]["menuId"]!=null && ds.Tables[0].Rows[0]["menuId"].ToString()!="") { model.menuId=int.Parse(ds.Tables[0].Rows[0]["menuId"].ToString()); } return model; } else { return null; } }